Slow learner still needs advice on “Upload MSDE database to SQL Server”

I just want to simply upload my database to a Web Hosting service. I’d like to be able to see both databases local and on Web Host, and just copy and paste.

I’ve received some responses, but either they didn’t work for me, or I did not understand them completely. Please assume nothing about my level of intelligence.

I’m new to doing this, but can anyone walk me through some simple steps on uploading my local database from my PC (has tables and stored procedures) to my Web Hosting Service SQL Server.

I’m a unemployed home user with few $$$ to spend, but can consider purchasing a cheap utility if that’s what this takes, and I am open for suggestions on database management utilities.

Also, I already tried one utility that had a login screen, but when I tried to logged in to my local database, I kept getting “Not associated with a trust SQL Server.” Can someone also tell me on my PC (step by step) how I can become associated with a trusted SQL Server?

My local PC has installed:
MSDE 2000
Visual Studio .NET Professional Academic 2002 & 2003

Web Hosting Service has setup a Microsoft SQL Server database for me.

Thank you!!

As you have MSDE you can't backup the database. Option 2 is to run sp_detach_db <your database name> in query analyzer and copy the ldf and mdf files of the database out of the MSSQL data directory. Then copy the files up to the server and attach the databse using sp_attach_db <your database name>, <filepath 1>, <filepath 2>. You will probably want to reattach the database back to your local instance of MSDE. There is a good amount of information on sp_attach_db and sp_detach_db in SQL Books online. If you need any more information just ask.

regards
David Cameron

Um David,

Just because it's MSDE doesn't mean you can't backup the database. It simply means you don't have spiffy tools like Enterprise Manager to do it for you.

It takes a little work, but MSDE does come with osql.exe, a command line utility which can execute queries, stored procedures, etc. See
http://support.microsoft.com/default...;EN-US;q325003
for info on how to do a backup and other management tasks using this utility.


Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

Sorry, I was thinking of creating backup jobs. I forgot that you can create backups, you just can't set them to run regularly.

regards
David Cameron

Honest, I'm not picking on you David :D, but see
http://support.microsoft.com/default...b;EN-US;241397
for ways to schedule backup jobs using the SQL Agent that comes with MSDE.

MSDE is SQL Server - it's throttled a bunch and it doesn't come with the GUI tools, but it does come with all the system stored procedures. Armed with OSQL you can do everything you can do with EM, only via the command line, and with a lot more typing...

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

Thanks for the correction, sorry for being misleading.

regards
David Cameron