Re: Trying to write a prog to load data AND comply w/referentail

root@TeamInfinity.com (root) wrote: > > This may sound like a very easy question, so much the easier for you to > answer hopefully... Clipped > I do alot of C programming. This is for duplicating tables, as for merging tables, thats another story. When we do this to duplicate data on our developement system, there are certain criteria we have to meet. 1. Do it when there is no, if possible, additions to the tables being copied. 2. Start from the bottom up, load a the tables with not referentail integrity first, then the ones dependant on them and so on. 3. Very important, load to a temporary set of tables names, and when done, drop the orignal tables and rename the tables to the correct name. I know the first to steps are obvious, but the third step allows us to load will people are using the developement system and it I screw up, nothing is damaged. I don't even want to think about merging data and keeping referentail integrity:^( ===================================================================== Paul Watje Database Something or Another watjep@hasting.com Hastings Books, Music, & Video