Tx Replication from SQL Server 2008 R2 to Postgres 9.1

Actually, the error message is :

OLE DB provider "PGNP" for linked server "PGNP_Samples" returned message "Undefined column name "Tbl1001"."columnname"".
Msg 7321, Level 16, State 2, Line 1

We have tested the stored procedure call, and it worked fine in current version: 1.4.0.3056.

EXEC('pgnp_refreshmetadata('''',''test'')') AT PGNP_SAMPLE

What version of provider are you using?

Btw, another way of refreshing metadata cache in all connected OLEDB providers is to execute following statement: NOTIFY pgnp_rtx.

I used the same script in order to setup a transactionnal replication between sql 2008 r2 ( publisher) and Postgresql 9.2 .
The table MSREPL7 has been created, a row is inserted , but I coudn't find the replicated table. ( Even if I reinitialize the subscription)
I've got no error on SQLSERVER.

Thank you

I do not know the reason. It can happen if a step was missed during the replication configuration. Could you check SQL Server logs, NT Events log and Postgres logs in order to see if any errors were reported?

Second thought: usually a snapshot replication is used in order to create destination table(s).

Hello,

I have these errors :
invalid parameter
when the agent try to bulk copy

and right after: ERROR: relation "dossier" already exists (Source : MSSQLServer, Numéro d'erreur : -2147217900)

Thank you

Would you send more details on how to reproduce the issue to Support? We need configuration script, table(s) DDL, sample rows. Thank you!