2-way real-time synchronisation MS SQL and Postgresql

This project was successfully completed by nitinmms for $125 USD in 7 days.

Get free quotes for a project like this
Employer working
Completed by:
Project Budget
$30 - $250 USD
Completed In
7 days
Total Bids
Project Description

I need a solution to synchronise 2 databases in real time:

Server 1 : MS SERVER 2003, SQL SERVER 2003
Server 2: Ubuntu [url removed, login to view], Postgresql 8.4 or 9.1
The 2 servers are at different locations.

Requirements :
1) Records written in "table_IN" on server 1. This record needs to be immediately written to "table_IN" on "server 2". Then deleted from server 1.
2) Records written to "table_OUT" on server 2 need to be written immediately to "table_OUT" on server 1 and deleted from server2.
3) The communication must be secure and FAST
4) Communication must be sent using a "guaranteed delivery" system. We must be sure that each record is transferred, but only once. Even if one side breaks down, records must be transferred when system is running again. I was thinking of message queues.
5) Use open source software where possible.
6) Provide source codes and small installation documentation for each end.

Please feel free to suggest optimised architecture or alternative approaches, replication software etc.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online