SQL Replication to PostgreSQL

Question

 

Has anyone successfully used transactional replication with SQL 2005 as the publisher and distributor to a Postres DB as the subscriber? Or is this even possible? Thanks in advance!

Answer 1

last 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.

 

Answer 2

Hello Hilary,

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..

 

www.zenkov.com

 

Thank you.

Best regads,

Oleg.

 

 

 

Answer 3

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"

thank you.

Answer 4

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 ?

Thank you.