Crash and Errors using with DTSWizard

Using PGNP with MS SQL Server, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Linked Servers, Snapshot and Transactional Replication and more.

Crash and Errors using with DTSWizard

Postby justbobchico » Mon Sep 24, 2012 10:20 am

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-
justbobchico
 
Posts: 1
Joined: Mon Sep 24, 2012 9:57 am

Re: Crash and Errors using with DTSWizard

Postby Moderator » Tue Sep 25, 2012 9:05 am

Would you send the table DDL to Support?

We will look at the issue closely, and will try to help. Thank you!
User avatar
Moderator
Site Admin
 
Posts: 306
Joined: Wed Oct 29, 2008 11:27 pm


Return to SQL Server/DTS/SSIS/Linked servers/Replication

Who is online

Users browsing this forum: No registered users and 1 guest

cron