• State Verified Answer
  • Locked Locked
  • Replies 4 replies
  • Answers 1 answer
  • Subscribers 92 subscribers
  • Views 3318 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Trying to create a Reference System from my Prod Environment using The Data Transporter. Anyone have a recipe for doing this> (1IM 6.1.4)

ToddFendt
over 5 years ago

Hi, 

1IM 6.1.4 on windows servers, MS SQL DB.

I am trying to create a reference system and have created a empty 6.1.4 DB. Now I am trying to copy non user data to the target empty system.

Using Data Transporter I get many errors because related table data is not included in my choices.

Does anyone have a recipe for doing this? And the order in which to copy data?

Any help is appreciated. Thanks, Todd

Parents Reply Children
  • 0 over 5 years ago in reply to Barry Jackson

    Hi Barry, Thanks for your input. Now I will have to invent the SQL statements to delete user data in the proper order ( including group memberships, resources, etc.).

    You wouldn't happen to have some code I could review?

    Thanks, Todd 

  • +1 over 5 years ago in reply to ToddFendt

    Hi Todd,

    Well that really depends on the tables you have populated ......

    I generally go from the bottom up .....

    delete from adsaccountinadsgroup

    delete from adsgroupinadsgroup

    delete from adsgroup

    delete from adsaccount

    delete from person

    You may have dynamic groups that need clearing down, attestation cases etc ......

    It's just a case of walking through your system and identifying what you need to clear out.

    HTH, Barry.

  • 0 over 5 years ago in reply to Barry Jackson

    Hi Barry, Thanks for your info.