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]