Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old June 20th, 2003, 05:25 PM
Authorized User
 
Join Date: Jun 2003
Location: , , .
Posts: 34
Thanks: 0
Thanked 0 Times in 0 Posts
Default Still needs advice on “Upload MSDE to SQL Server

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!!
Reply With Quote
  #2 (permalink)  
Old June 23rd, 2003, 06:56 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Sydney, NSW, Australia.
Posts: 215
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #3 (permalink)  
Old June 23rd, 2003, 07:24 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Hudson, MA, USA.
Posts: 839
Thanks: 0
Thanked 1 Time in 1 Post
Default

Quote:
quote:As you have MSDE you can't backup the database
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
Reply With Quote
  #4 (permalink)  
Old June 23rd, 2003, 07:29 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Sydney, NSW, Australia.
Posts: 215
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #5 (permalink)  
Old June 23rd, 2003, 07:39 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Hudson, MA, USA.
Posts: 839
Thanks: 0
Thanked 1 Time in 1 Post
Default

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
Reply With Quote
  #6 (permalink)  
Old June 23rd, 2003, 07:54 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Sydney, NSW, Australia.
Posts: 215
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for the correction, sorry for being misleading.

regards
David Cameron
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Server Advice Wanted kwilliams SQL Server 2000 1 June 27th, 2006 03:47 PM
Porting MSDE database to SQL server hgberman SQL Server ASP 2 January 23rd, 2005 08:03 PM
SQL Server & MSDE reyboy SQL Server 2000 0 September 6th, 2004 10:15 PM



All times are GMT -4. The time now is 03:34 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.