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 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.
it sounds like you have a weak grasp of delational database design
I would have a single Employee table, with employee ID as the primary
key, and any other attributes which are common to all employees, then I
would have other tables which contain information about specific
employee types or groups, these other tables could have their own
primary key, but would reference the Employee table EmployeeID field for
the common employee attributes.
--
john r pierce, recycling bits in santa cruz
