backup local sql server db tables for use on hosted db server using visual studio

I'm using Visual Studio 2010 and created database tables with relationships. Is there an easy way to save/view the sql and then run a new query on my hosted sql server db to crea开发者_运维百科te each table?

Visual Studio 2010 can do a lot of stuff around databases - but at some point, you just have to switch to SQL Server Management Studio, and this is one of those cases.

In SSMS, you can easily generate T-SQL scripts to create your database objects - tables, procedures, whatever. I don't know of any way to do this inside VS.

Actually VS can make a full synchronization of a database against a known schema - very nice for source control. You need a high version, though - I think Ultimate. Check the different database style projects you have available.

I finally figured it out. In Visual Studio you can right click on any database, hosted or local and use the publishing wizard. I followed the steps at this link as the wizard is not very user friendly. http://products.secureserver.net/products/hosting/PublishingWithDPW.htm