On 5/21/2015 9:51 AM, Suresh Raja wrote:
I'm looking at directions or help in extracting data from
production and alter employee id information while
extracting. But at the same time maintain referential
integrity across tables. Is it possible to dump data to
On Thu, May 21, 2015 at 11:33 AM, Steve Midgley scie...@misuse.org wrote:
I would update the IDs using SQL before dumping if possible. If necessary
clone the tables, adjust the IDs and then dump. SQL has better tools than
most languages/scripts to adjust values in columns across multiple
I would update the IDs using SQL before dumping if possible. If necessary
clone the tables, adjust the IDs and then dump. SQL has better tools than
most languages/scripts to adjust values in columns across multiple
entities. Plus it should be easier to build some test queries in SQL to
validate