Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    93

    Talking Unanswered: appending data from database 1 to database 2 (live into Dev env)

    have 2 databases in sql server 2000

    Live
    Dev

    I need to append all the data from LIVE into DEV environment. I have tried using MS Access (linking tables & importing tables and running APPEND query to update the rows from LIVE to DEV but PK & FK is causing problems as some data will have the same ID's....

    Could I use DTS--Access wizard in SQL Server.

    What is the best option to use?

    Thanks all in advance
    Cheers
    Etravels

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    If this is a one-time transfer, or if does not need to occur on a scheduled basis, you can just right click on your production database in Enterprise Manager and follow the wizard to export data.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Jan 2005
    Location
    TempDb
    Posts
    228
    The best thing, IMHO, is to restore you production to development. It will force you to write a script to do a delta, and it will clean up your dev environment. If you don't have the space, buy it. It is cheap.

Posting Permissions

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