New post
Question
Harshdeep Acharya · 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 #Caché #InterSystems IRIS #InterSystems IRIS for Health

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
0
0 194
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
Harshdeep Acharya · Mar 9, 2022

Hi Garcia,

Thanks for the response.

Can you please provide the step-by-step process for the above question?

So, I will follow that step and copy data for the same.

0 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
Harshdeep Acharya · Mar 9, 2022

Yes, Vic Sun

I am migrating data from IRIS 2019 to 2021 instance. Also, I follow server migration guide documentation.

But, When I copied data from 2019 to 2021 DB. There is mismatching the data into the tables. So, How can I resolve this?

Thanks.

0 0
Vic Sun · Mar 9, 2022

It's not possible to answer that question without knowing exactly what you did and probably looking at the system. What constitutes a "data mismatch"?

You could reach out to the WRC (InterSystems support).

0 0