0
365

Written by

Mary George
Barts Health NHS Trust
Follow
Question Mary George · Aug 14, 2020

[Resolved]Persistent data transfer

#HealthShare #Data Import and Export

Hi All,

What will be the best way to transfer the persistent data stored in the SQL tables from one instance of Healthshare to a new instance ?  Is there any InterSystems recommended process or documentation for this?

Thanks,

Mary

Discussion (5)2
Log in or sign up to continue

Comments

Yaron Munz · Aug 14, 2020

Hello,

I recommend either ways:

1. copy the *.DAT file to new server: for this you need to dismount the DB on source before copy (so you have downtime), mount it and do a merge between 2 DB/Namespaces.

2. Do a (hot) backup for the DB that has the table  = NO downtime (!) - then copy the *.BCK file to other server, restore to a NEW DB and merge.
This is slower - but downtime is 0

0
Neerav Verma  Aug 14, 2020 to Yaron Munz

Export import globals can work too.

If you need some help doing it, feel free to ping me on LinkedIn.

0
Mary George  Aug 19, 2020 to Neerav Verma

Thank you @Neerav Verma 

What is the best way to export global,  is it from management portal or the terminal export? 

0
Neerav Verma  Aug 19, 2020 to Mary George

Both are good.

Search documentation and you will get exact steps.

Still if you can't do it, let me know.

0