Hey All
I have 2 DBases - Production and Archive - that need rows copied from Porduction to Archive, then deleted from Production.

The Issue is that rows from multiples tables need to be copied, and the number of Child rows that need to be copied for foreign key integrity.

Any suggestions of how to do this? And at a reasonable speed?

I can post/email the current stored procs i am using, but they are rather lengthy due to the need to step through each of the Foreign Keys.

Thanx in advance!