Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Unanswered: How to port SQL Server data?

    Hello!

    I have an SQL Server 2000 database at home PC that has several tables and plenty of data in it...also stored procedures.

    I want to port all that data so that I can use it at another PC that has SQL Server installed in college.

    How to do this?

    Thanks in advance!


    Lala the don

  2. #2
    Join Date
    Aug 2003
    Location
    Andover, MA
    Posts
    256
    You want to detach the database, copy the files to the new server, and attach them. All using Enterprise Manager.
    -bpd

  3. #3
    Join Date
    Jan 2004
    Posts
    2

    Thanks man! But problem....

    Originally posted by bpdWork
    You want to detach the database, copy the files to the new server, and attach them. All using Enterprise Manager.
    Thanks a lot man! But when I detach the database disappears....

    How do I copy it?

    So nice of you!
    Last edited by mian1; 01-27-04 at 15:45.

  4. #4
    Join Date
    Aug 2003
    Location
    Andover, MA
    Posts
    256
    Well, I am an incredibly nice guy. What can I say?
    -bpd

  5. #5
    Join Date
    Jul 2003
    Location
    Penang, Malaysia
    Posts
    212
    err...it seems to dissapear...but it's not.
    Find your database and transaction log file from your computer.
    Usually it would be <yourdatabasename>_data and <yourdatabasename>_log

    If you install your SQL Server by default it should be in

    C:\Program Files\Microsoft SQL Server\MSSQL\Data

    Now go there and copy your files. And paste it to your destination. Then go to Enterprise manager, click attach, and find your files.

    Read up on Attach/Detach and refer Books Online.
    Patrick Chua
    LBMS ( Learn By My Self) NPQ ( No paper Qualification )

  6. #6
    Join Date
    Nov 2003
    Posts
    53
    attach/detach? y not use export daatabase function of the enterprise manager? i use it to transfer database from a computer to another computer with ease...jus a minute's work..

  7. #7
    Join Date
    Aug 2003
    Location
    Andover, MA
    Posts
    256
    Whoa. What happened to my post? I had a detailed description of how to copy the files. Weird.
    -bpd

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •