Re: dumb question- can you backup only data from tables? DBA sez no

"Syltrem" <syltremzulu_at_videotron.ca> wrote in message news:<y204c.986$Xy3.3688_at_tor-nn1.netcom.ca>...
> "Bib Endum" <gd-newsgroups_at_spamex.com> a écrit dans le message de
> news:gK%3c.42576$lT6.218546_at_news20.bellglobal.com...
> > In your case, it looks like your application probably has no referential
> > integrity built in and the data is messed up in some way. Many 3rd party
> > apps generated with stuff like uniface do not implement native referential
> > integrity because they are portable accross databases. This generally
> lends
> > to poor performing code, and to integrity problem.
> >
> > I suspsect that is what you have.
> >
> >
>
> If the OP re-loaded all the data from the original db, to the new db he
> created from the application's setup script, I don't see referential
> integrity as the problem.

no, it wasn't RI because I reloaded the data from the tables "manually" and the data is the same and the data pulls up. In fact, I had to load in the data following RI rules with tables containing foreign key indexes loaded last, so I looked at the (undocumented) database pretty carefully. The problem is that I don't have the time to investigate the application scripts that call the data to find what the original errors might have been. I presume the problem was user rights now that I think about it and they were probably imported with the import command.

In general I feel like our DBA is not being honest with me and not exploring all options before asking me to solve his problems (I am a low level manager and programmer, not an OCP), but the comments that people left have sort of exonerated him.

thanks,

Don Received on Thu Mar 11 2004 - 16:13:42 CST