If you are updating existing data, you can create an insert/update
stored procedure to add/update each row.
You could add a date field called INSERTED to each primary key, so you
only do inserts and have a transaction history.
You could define the foreign keys with cascading delete ( ON DELETE
CASCADE ) so when the parent record is deleted, so are its children.

-----Original Message-----
From: Myles Wakeham [mailto:myles@...]
Sent: Tuesday, February 22, 2005 1:28 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] What's the best way to do this?


I have to copy a series of about 40 tables from an ODBC data source into
a
Firebird SQL database everynight at 12 midnight. This is a 'Data
Warehouse'
dump of information from a transactional system to Firebird. All data in
Firebird that was there before, can be completely deleted but I'd like
to
keep the table structure intact.

I thought this would be a simple DELETE * from TABLE NAME for each table
that has to be transferred over, but there are primary/foreign key
relationships between the tables and therefore I can't delete out the
tables
without upsetting the data integrity in the database.

What is the best practice in these situations?

Myles

===========================
Myles Wakeham
Director of Engineering
Tech Solutions Inc.
Scottsdale, Arizona USA
Phone (480) 451-7440
Web: www.techsol.org





Yahoo! Groups Links