Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    8

    Unanswered: determine right copy order (foreign keys)

    Hi all,

    Im trying to create a program that can copy bulk data from one database to another.
    Im looking for a query (or something else) that can extract the right copy order : parent child relations

    So I dont get in trouble with foreign key constraints

    Thanks all !

  2. #2
    Join Date
    Oct 2003
    Posts
    5

    Re: determine right copy order (foreign keys)

    you can disable all the foreign key constraint, load the data and then re-enable those constraints

  3. #3
    Join Date
    Sep 2003
    Posts
    8

    Re: determine right copy order (foreign keys)

    Originally posted by oralearner
    you can disable all the foreign key constraint, load the data and then re-enable those constraints
    Thats exactly what I want to avoid : disable foreign keys !

Posting Permissions

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