What about doing your conversion to relational locally to Access (or even to Paradox) and then just shooting up the complete final data.
James Sleeman wrote: > > Hi all, > I have an old, ugly and large Paradox database that I inherited and am >converting into a new, beautiful and large SQL Server (7) driven schema. > > Problem is the importing of this old database - it takes a VERY long time and i >have to watch it like a hawk because invariably the Paradox data is broken beyond >belief in places and I have to fix the data or scrap that row or work around it... > > The reason it takes so long (it's not to do with Paradox itself, those queries >get cached), is that the inserting of this data generates, about 500 insert queries >per row of data in the old paradox database (it was a big flat file thing more or >less, my schema is fully relational), there are just under 1000 rows, that's, 500000 >inserts ! Not to mention the fact that the SQL server is all the way across the net >:-) > > So, is there any way to do a BULK insert into single tables aside from using >"BULK INSERT" itself, which inserts from a file on the SQL server (I don't have >access to put files on the SQL server anyway), so that instead of 500 individual >inserts per old database row I can just do one insert for each of my new tables (that >is insert all the "Education" data for a row in one shot, insert all the "Staff" data >in one shot etc) there by reducing the load to maybe 40 "bulk" inserts per row, and >the total down to 40000 "bulk" inserts (which is still a lot, but not staggeringly). > > Ideas anybody ? > > --- > James Sleeman > > Innovative Media Ltd > Ph: (03) 377 6262 > http://www.websolutions.co.nz > > CAUTION: The information contained in this email message is confidential and may be >legally privileged. If the reader of this message is not the intended recipient you >are notified that any use, dissemination, distribution or reproduction of this >message is prohibited. If you have received this message in error please notify the >sender immediately and destroy the original message and any attachments. > > Views expressed in this communication may not be those of Innovative Media Ltd. > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
