Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi hilmar,
>The tricky part is to copy parent table before child table (avoid "trigger failed"). Also, if you have a lot of data, it helps to compare table structures and skip tables that haven't changed (use COPY FILE instead).
Therefore you might want to take a look at my TaxRiBuilder in the files section. I use it to turn RI off in such particular cases. It also is a lot faster (when using the fast) than the original builder when appending record. In a lot of my products I use the same strategy (Of copying a new empty database and appending new records) and works fine. Only when the database grows too large it might be a slow option.
Regards,
Walter,
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only