Unanswered: Replicating from MS SQL to Postgres 8.1 data type problems
Hello I'm a noob poster.
I have been trying to replicate from Sql Server to Postgres using Enterprise Manager and the Postgres ANSI ODBC driver version 8.02.02.
I was able to copy tables over when I used the article option to "DROP existing table and re-create it" only columns of data types datetime and decimal were copied as varchar.
So I tried drop the tables manually and then creating them in postgres with the proper data types (timestamp without time zone, and numeric). I then tried changing the article option to "Keep the existing table unchanged" and I get the following error from the Distribution agent: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
So I then tried using the article snapshot option "Delete all data in the existing table" and I got the same error.
Anyone got any suggestions or comments?
Reply With Quote