Crash and Errors using with DTSWizard

More
9 years 3 months ago #9745 by justbobchico
MSSQL Import and Export Data tool (DTSWizard) to import data to PostGreSQL 9 from MSSQL 2008R2
PGNP 1.4.0.3076

Source table 24 column primitive data type 1 column nvarchar(4000) - 3.7M rows
Where I try to use the wizard to replicate a table from MSSQL to PostGreSQL it either performs very slow or crashes.
Tried 32bit DTSWizard with Bulk Insert Method: Value Sets Buffer Size:1 - very slow 50K rows in about an hour
Tried 32bit DTSWizard with Bulk Insert Method: Value Sets Buffer Size:200 - application crashes in a few seconds

Tried 64bit DTSWizard with Bulk Insert Method: Copy Command Buffer Size:10 - Consumed 10G ram after 250K rows causing system unresponsiveness due to memory exhaustion
Same with Pipe/Copy and any value for Buffer Size.

What is the best way method and setting to use to duplicate data from MS SQL to PostGreSQL. My intention is to duplicate the data for development work but then to used Linked Server Replication once in production.

Bob-

Please Log in or Create an account to join the conversation.

More
9 years 3 months ago #9783 by Moderator
Would you send the table DDL to Support?

We will look at the issue closely, and will try to help. Thank you!

Please Log in or Create an account to join the conversation.

Time to create page: 0.045 seconds
Powered by Kunena Forum