postgres-2-postgres RRS feed

  • Question

  • Any solutions or examples that can synchronize between postgresql to postgresql?
    Saturday, January 16, 2010 5:01 AM


All replies

  • Hi,

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

    You could also use the Oracle Example provided (http://code.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=sync&ReleaseId=3761) 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 abeltsov@gmail.com

    it would be great

    Wednesday, August 11, 2010 6:59 AM