Answered by:
postgres-2-postgres

Question
-
Any solutions or examples that can synchronize between postgresql to postgresql?
- Moved by Liam Cavanagh - MSFTMicrosoft employee Thursday, January 21, 2010 7:37 PM (From:SyncFx - Microsoft Sync Framework Database Providers)
Saturday, January 16, 2010 5:01 AM
Answers
-
Hi,
You can follow these instructions to create your own provider for postgresql.
http://msdn.microsoft.com/en-us/library/cc807291(SQL.105).aspx
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.
HTH,
Rudi- Proposed as answer by Rudi - Euricom Monday, January 18, 2010 10:20 AM
- Marked as answer by Liam Cavanagh - MSFTMicrosoft employee Tuesday, January 19, 2010 11:22 PM
Monday, January 18, 2010 7:56 AM
All replies
-
Hi,
You can follow these instructions to create your own provider for postgresql.
http://msdn.microsoft.com/en-us/library/cc807291(SQL.105).aspx
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.
HTH,
Rudi- Proposed as answer by Rudi - Euricom Monday, January 18, 2010 10:20 AM
- Marked as answer by Liam Cavanagh - MSFTMicrosoft employee Tuesday, January 19, 2010 11:22 PM
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 -
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