Deploying all the .aspx, CSS and image files of a website to the hosting environment is not that big a deal, however making sure that the whole database including data is created correctly is sometimes more difficult.
At CodePlex they've launched a new project called "Database Publishing Wizard" which aid in deploying a SQL Server 2005 database (both schema and data) to a shared hosting environment on either a SQL Server 2000 or 2005 server. Also Scott Gu has written a detailed post about this nice tool, be sure to check it out.