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 fla
On Thu, May 21, 2015 at 11:33 AM, Steve Midgley 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
> entities. Plus it s
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 tha