New post
Question
· Aug 14, 2020

[Resolved]Persistent data transfer

#Data Import and Export #HealthShare

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
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

1 0