You can use the SQL Publishing wizard in VS 2008/VWD 2008 to deploy a local database from your development machine to a hosting environment on a remote machine. This is how you will accomplish this: Step 1: Create a new web site by selecting menu File
Read More...
Read the complete post at http://blogs.iis.net/webdevelopertips/archive/2009/09/27/tip-96-did-you-know-you-could-publish-your-sql-databases-using-the-sql-publishing-wizard.aspx