Re: Transfering tables

M Auger wrote: > > My exact situation is : we will be running 2 databases in parallel for at > least one month, and a transfer between databases can be triggered by the user > at any moment which could be every 10 minutes or 30 minutes. That's why we > need to determine the order at which the tables should be inserted first. We > started doing this manually, someone is also trying to find a script > solution, but I thought I could a quicker solution on the Net. The > No constraints solution would not be practical in our situation. > Thanks for your comment. > > Michel What version is your OnLine ? I saw "set constraint all deferred" statement in this newsgroup; it is to be used to not control constraints during transaction. I do not whether the statement really exists and in what version. It does not work in version 5.x. Seems to me that the best solution is to do analysis of constraints and use appropriate tables order in program. If you want SQL script, which will show constraints from/to table, let me know. Michal -- -------------------------------------------------------------- Michal Hajek mailto:hajek@nspuh.cz Sprava NIS http://www.nspuh.cz NsP Uherske Hradiste phone : voice +420 0632 529 204 Purkynova 365 fax +420 0632 551 014 686 68 Uherske Hradiste Czech Republic --------------------------------------------------------------