In Visual Studio .NET 2002, I can connected to my Web Hosting service's database that they have set up for me for MSSQL.

I tried to transfer the tables and stored procedures I have on my local machine to my database on my Hosting service via Studio IDE. Visual Studio won't let me just copy, and paste.

Also, I do have Visual Studio .NET 2003 installed, but I haven't used it yet because I'm not quite ready to convert my project in 2003 because of some fears of some possible unexpected problems.

Can anyone help me on how to transfer a database to a Web Hosting SQL server? I read about the Copy Database Wizard, but I am running MSDE 2000, and I don't know if I have this wizard to use, or where it would be if I do have it.

Jan_Ma
Contact me at: [email protected]

Get yourself a copy of the SQL Server client tools (you can download the trial version of Microsoft SQL Server from here, and just install the client tools during setup: http://www.microsoft.com/sql/evaluat...al/default.asp)

In your Enterprise Manager and/or Query Analyser, connect to both your local MSDE, and your remote SQL Server. Then, you can copy the necessary objects between the two. I would *strongly* suggest that you script the creation of your objects (eg tables/sprocs), because then you can save these in a .sql file, load that into Query Analyser, and run it, and viola, your entire database is (re-)created.

Cheers
Ken

www.adOpenStatic.com

Ken, thank you for responding.

I am really interested in what you stated, but I do not believe I have access to Enterprise Manager and/or Query Analyser. I only have Visual Studio .NET Professional (Academic) 2002/2003.

Can you advise me further. I am just a person working on their own PC in a home office.

Thanks ... I hope you get this message, and reply back.