postgres-2-postgres RRS feed


All replies

  • Hi,

    You can follow these instructions to create your own provider for postgresql.

    You could also use the Oracle Example provided ( to get a feeling of how this works. It's basically creating the set of tracking tables, triggers and stored procedures so that they work on postgresql.

    Monday, January 18, 2010 7:56 AM
  • Finally I can did it by follow the methodology listed in oracle example but change some commands to match the plpgsql. Thank you very much.
    Monday, January 18, 2010 9:46 AM
  • Can you please tell me what were the changes?

    I had the sync sample for SQL server and i tried to make it work for Postgresql.
    There were some problems
    1. Anchor value had to be stored as 'bytea' , which when returned from database, will be of byte[4098] format. But the achor value should be byte[2048].

    2. There is a timestamp column in sql server which is similar to binary data and it can be compared with the binary value. But i couldn't figure how to do it in postgresql.

    Could you please help me solving these issues.
    Any code will be excellent.
    Wednesday, March 3, 2010 10:27 AM
  • Hi, sync lover!

    Could you please provide any information about your successful experience?
    I try to do postgres 2 postgres sync too and get,get,get error during sync.
    Please share the source code of your DbSyncProvider, DbSyncAdapter.
    some stored procedure and scopeinfo table definition...
    Please send it to

    it would be great

    Wednesday, August 11, 2010 6:59 AM