Community thoughts about data merging
Posted: Thu Feb 14, 2013 2:20 pm
Hello Servoyians!
For the following situation I like to know your input, ideas and how to's:
Most of you probably have a dedicated customer database (with only the data from 1 customer).
Then in other cases there are databases that contain data of multiple customers (saas).
Suppose you need to migrate data from the dedicated customer database to the saas database.. how would you do that?
(Please mention your tools, approach, etc. Also note that you cannot use the same primary keys when migrating your data into the saas database)
Looking forward to whatever you come up with
For the following situation I like to know your input, ideas and how to's:
Most of you probably have a dedicated customer database (with only the data from 1 customer).
Then in other cases there are databases that contain data of multiple customers (saas).
Suppose you need to migrate data from the dedicated customer database to the saas database.. how would you do that?
(Please mention your tools, approach, etc. Also note that you cannot use the same primary keys when migrating your data into the saas database)
Looking forward to whatever you come up with