18 Januari 2008 19:14
22 Januari 2008 13:23Moderatorlast time I tried this with PostGres and SQL 2000 there was no oledb provider and I could not get the ODBC driver to work. It might be possible now, but you would have to use a SQL 2000 server as a gateway/republisher.
05 Juni 2008 8:06
this type of replication is interesting for me too: SQLServer 2005->Postgersql 8.3
My colleagues and me are working on the PostgerSql OLEDB provider (32-bit and 64-bit), it works good, I tested it for the linked server etc.
Could you please check it may be it can help us to maintain replication. Naturally, if it is possible..
25 Nopember 2011 12:02
We did replication of tables from sql-server 2000 to PostgreSQL 9.0 using ODBC and linked server. It was good enough but with one exception that,
Table with table name <TableName> is maintaining its case when replicated to postgre. That is the table is replicated to postgre but with name "TableName" making it not possible to access with simply giving name as TableName, SELECT * FROM TableName wont work.
Can anybody suggest how to make sql-server not maintain case of the table names while replicating them to Postgre, for example table <TableName> should be replicated as just tablename and not "TableName"
06 April 2012 6:48
To add more, even if we ignore the tablename case, we are still facing issues with data types. Data type bit of sql-server when replicated to postgresql it is converted into varchar(1) and datatype decimal and numeric are also converted into varchar ... any clue on how to handle that ?