Re: extracting PII data and transforming it across table.

On Thu, May 21, 2015 at 11:33 AM, Steve Midgley <science(at)misuse(dot)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
> entities. Plus it should be easier to build some test queries in SQL to
> validate that your ID adjustments were valid.
>
> On Thu, May 21, 2015 at 9:27 AM, Suresh Raja <suresh(dot)rajaabc(at)gmail(dot)com>
> wrote:
>
>> Hi Folks:
>>
>> 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 flat file and then run some script to change emp id data on all files.
>> I'm looking for a easy solution.
>>
>> Thanks,
>> -Suresh Raja
>>
>
> Steve:
I too would like to update the id's before dumping. can i write a sql to
union all tables and at the same time create unique key valid across tables.

Thanks for prompt reply.