How to upload database to sql server

  • I am a home user running Visual Studio .NET Professional 2002/2003. I only have MSDE installed. I don't own Enterprise Manager, and need a check way to upload my database with tables and stored procedures to my Web Host's SQL Server. Can you help me. I'm new to doing this as well so please give details. Thank you.

  • One way is to script out all the objects using DMO. Another would be to just sto the service, FTP the files directly. Might also look at freeware tools.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply