Oh Great Datbase Gurus
stimpy | Posted 1:03pm 5. September 2007 Server Time |
I lay my soul bare at the alter of your knowledge seeking enlightenment... Okay, so enough with the groveling...
Here's the deal.
I need help figuring how to get a lot of data from a Paradox DB not housed on local servers into a SQL Server 2005 Data base housed on a local server. I am attempting to convert a classic ASP application to ASP.NET using C#.
The thing is this site (the largest indigenous plants database site for Wisconsin) gets a ton of traffic (from other universities and the Federal Gov't) and the site cannot be taken down completely under any circumstances.
I have approximately 34 tables in a SQL Server 2005 DB. Some of these tables have between 10,000 and 100,000 records. I need to be able to easily insert, Update, and delete a lot of records from those tables in a very short amount of time.
Under normal circumstances I would receive one XML file per table from the Paradox database with only those records that need to be changed in that table that would then need to be updated to the SQL Database running my site.
I'm looking for suggestions on how best to handle this. Is there an easy way to do Batch updating of tables using XML? Could you do this with a web service or something similar? Any ideas??? |
