14
Views
2
Comments
Solved
Copy only data not code from prod to non-prod environment
Application Type
Traditional Web

Hi ,

Our application and database(RDS  SQL Server)  are hosted in AWS servers.

Last time when we copied data from Production to non -prod environment, not only our business data but also our code got overwritten.

Is there a way to migrate only the business data and not the Outsystems code?


Regards,


Nishit



mvp_badge
MVP
Rank: #51
Solution

Hi Nishit,

AFAIK there is no out of the box feature or  tool exists to migrate only transitional data from prod to non prod environment. In this case i think you would need to write some sql scripts or timer to export data from Prod and and similar to upload the extracted data in non prod environment.

Regards,

-PJ-


Rank: #68

Hi Nishit,


Be aware of GDPR compliance when moving data from Production to other environments, you probably will want to anonymize that data.

Perhaps you want to take a look at Infosistema DMM component which is suited for these kind of actions.


Regards,
João