I'm a home user with Visual Studio .NET Professional (Academic) 2002 & 2003. I have MSDE installed. Can someone tell me how to transfer my local database with tables and stored procedures to my Web Hosting SQL server?

I can connect to the database my Web Host setup in Visual Studio, but I can't copy and paste my tables and stored procedures. I'm new to this, so if you respond, please deal with me as a relative beginner. Thanks.

Backup your local database which include table and store procedures. This will make a file which you can upload your Web server. There you can restore it in Web SQL server.
-ned

   some problem about sqladapeter

Care to give us a little more to go on?



There are two secrets to success in this world:
1. Never tell everything you know

From the older Sqlserver get your Data files (mdf , ldf) and upload them to your new sqlserver using DTS

Ahmed Ali
Software Developer

We do it with DTS (data transformation services) Transfer Databases Task.

In your enterprise manager, create a new dts Package, and look for Transfer Databases Task in the Task tools.

Your Web Hoster's sql server will have to be registerd in your Enterprise Manager (right click on SQL Server Group, New SQL Server Registration).

Good luck

Eric