Loading dumped tables to MS SQL 2008, incredibly slow

Our Progress -> SQL conversion took about 24 hours total, final database
size about 7GB. Epicor did the conversion for us, so I don't know
details of the process or what the bottleneck was.



But in general for bulk data loads, delete/disable indexes & triggers
during the load, and rebuild afterwards - much faster.



Brian.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Clive
Sent: Friday, January 20, 2012 12:03 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Loading dumped tables to MS SQL 2008, incredibly slow





As part of our upgrade from Vantage 8 to Epicor 9 I'm also moving us
over to MS SQL 2008, and slowly but surely we're getting there.

I'm now pinning down the process for loading the dumped Epicor 9.05.607B
Progress tables into MS SQL using the Data Administrator, and it's going
incredibly slowly.

The load of the dumped tables is occuring on what will be our live
Epicor 9 server, an eye watering beast of a server with hoards of disks
in multiple RAID 10 arrays, but the the load from tables A to G alone
(2.74 GB of dunped tables) takes upwards of 12 hours.

I'm not sure what can be done to speed the process up, it's certainly
not being restricted in any way by the hardware. Anyone have any advice
?.

Thanks.





[Non-text portions of this message have been removed]
As part of our upgrade from Vantage 8 to Epicor 9 I'm also moving us over to MS SQL 2008, and slowly but surely we're getting there.

I'm now pinning down the process for loading the dumped Epicor 9.05.607B Progress tables into MS SQL using the Data Administrator, and it's going incredibly slowly.

The load of the dumped tables is occuring on what will be our live Epicor 9 server, an eye watering beast of a server with hoards of disks in multiple RAID 10 arrays, but the the load from tables A to G alone (2.74 GB of dunped tables) takes upwards of 12 hours.

I'm not sure what can be done to speed the process up, it's certainly not being restricted in any way by the hardware. Anyone have any advice ?.

Thanks.