Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    25

    Unanswered: the best way to transfer with identity keys?

    hello,

    i have two databases, stage and production. some data has been entered directly into production, but most needs to be transferred from stage. what is the best way to do this, when i have several tables that are related by identity keys? thanks for any suggestions.
    Last edited by kfenstad; 06-04-03 at 13:50.

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Use DTS and refer to books online for info.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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