Re: [GENERAL] [SQL] extracting PII data and transforming it across table.

2015-05-27 Thread John R Pierce
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

Re: [GENERAL] [SQL] extracting PII data and transforming it across table.

2015-05-21 Thread Suresh Raja
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

Re: [GENERAL] [SQL] extracting PII data and transforming it across table.

2015-05-21 Thread Steve Midgley
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