New post
Question
· Mar 9, 2022

How I can copy exact same data from IRIS Instance 2019.1 to IRIS 2021.1 with the Identity column from the IRIS database?

#Databases #Data Import and Export #InterSystems IRIS

Hello,

Can anyone help on the below point? It will very helpful for me.

Copy exact same data from IRIS Instance 2019.1 to IRIS 2021.1 with the Identity column from the IRIS database.

Thanks,

Harshdeep Acharya

Product version: IRIS 2021.1
Discussion (5)3
Log in or sign up to continue
Warlin Garcia · Mar 9, 2022

Few options without knowing much about current setup and the use case (eg. how much involvement you want to have in the process)

  • Synchronizing(shadow) between the 2 instances - Global export/import
  • Global mapping from one instance to another
    • You could merge global from source to target
  •  File transfer (traditional ETL) and manipulating the global directly (risky but doable) 
1 0
Vic Sun · Mar 9, 2022

I totally agree with Warlin that it really depends on what you are trying to do and your current setup. My interpretation of your question is that you are trying to migrate your data / user settings to a new server / instance?

I would say to use the server migration guide as a starting point - but definitely test the process since you're crossing versions also which is beyond the scope of that documentation.

0 0