New post
Question
· Oct 31, 2019

Working with Data: System in production

#Backup #Big Data #Databases #SQL #Caché #InterSystems IRIS #InterSystems IRIS for Health

Greetings community. I would like to know how to migrate a BD in production to a local environment. When I have a system in production (BD Sql Server) what we do is mount a local copy to do the analysis with the data and not occupy resources of the system in production. My question is: How do you do it with Intersystems technology? I already tested the PowerBi connector and it looks great, but that's where the question came up.
 

Discussion (2)1
Log in or sign up to continue
Eduard Lebedyuk · Nov 1, 2019

There are many ways to do what you need.

  • Copy CACHE.DAT / IRIS.DAT
  • Export globals and code
  • Use ASYNC mirror or backup

Here's the questions you need to answer to choose the best path:

  • Is downtime OK or not?
  • Do you need a whole database or some part?
  • What's the size of your DB?
  • Are there mirrors/backups available?
  • Are your code/data in separate DBs?
  • Do you need to run the pipeline once or do you need to stay somewhat up to date?
0 0