is xml and activeX necessary for DBA?
-
Oh ya forgot to mention this to. This software goes into hospitals and some of 'em don't want to have to install Office componants. So let's just say that this program has been challenging to say the least!
But thanx again for the information. I'm currently using the recordset.save (fielname, xml) option and it works pretty fast. The slow part is reinserting the data one row at the time... maybe I'll look into sending it as batchs but the really slow part is the loop into the loop into another few loops :
- Read from master xml file (20 xml files merged into one)
- Export as single valid xml file
- Load into recordset from XML
- Extract the table name and create temp table using select into
- Open a new empty record set connected on the temp table
- For each row
- Set each column into a new recordset object and save the data into previously created temp tables.
Now the fun begins :
- Find the duplicate ids between the current and imported data and generate new valid unused ones in a mapping table.
- Find all columns from all tables which use that id ; oh! and btw there's no documentation and no relations in the database.
- Update all columns using the mapping table
- Repeat that for 20 tables (± 1300 columns)
So looks like I'll talk to you guys on Monday
.
Viewing post 16 (of 15 total)
You must be logged in to reply to this topic. Login to reply