On 4/23/15 1:08 PM, Raymond O'Donnell wrote:
>> What I am trying to figure out is that if I also have other relations
>> >that have foreign keys into the data I am moving, how would I also move
>> >the data from those relations and maintain the FK integrity?
> I'd create the tables in the new schema without the FK constraints, copy
> the data, then add the constraints afterwards.
You could also deffer the constraints, but that's probably going to be a
lot slower.
--
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com