Question

12
Replies
1797
Views
DavidE79 Member since 2014 2 posts
M2C
Posted: 4 years ago
Last activity: 4 years 11 months ago
Closed

What is the best practice for updating large volume of Customer data (referencing purpose) in a 24*7 production environment

Hello,

is there any OOTB activity to update any property (for instance, Table Name) of Database Table instances?

We are interested in change table mapped to an other backup table (same structure) during update process of main table (this update process becomes main table blank for a few seconds).

So our approach to let end users to use data of main table during update process is to copy data in main table to a work table, update instance of Database Table that maps table to referenced class, using work table, udpate data in new table and when process is finished, update again Database Table instance to map to main table.

Any help to agree our need will be appreciated!

Regards,

David Encinas

M2C Consulting

System Administration
Moderation Team has archived post
Share this page LinkedIn