Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    1

    Unanswered: How to move tables from database to another

    hi all.....
    iam trying to move or export database tables between two sql server 2000 databases..but i always lose the relations between the moved(exported) tables...
    please tell me how to export or import tables between two sql 2000 server databases without losing relations...thx for ur time...
    plz replay me quick guys......

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Create a script for the database using SQL Enterprise Mangler. Play that script into an empty database. You'll be "good to go".

    -PatP

  3. #3
    Join Date
    Dec 2003
    Posts
    22

    More Details...

    Yes, I agree with Pat. Open Enterprise Manager, highlight the tables you want to move, right-click > all tasks > generate sql script. This will give you the script you need to run on the target database. It will create the tables and the constraints. Then you can just DTS the data over to the newly copied structure.

    Rob

Posting Permissions

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