2-way real-time synchronisation MS SQL and Postgresql

IN PROGRESS
Bids
10
Avg Bid (USD)
$222
Project Budget (USD)
$30 - $250

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

Server 1 : MS SERVER 2003, SQL SERVER 2003
Server 2: Ubuntu 12.04, 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.

Skills required:
.NET, Java, Python, Software Architecture, SQL
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 200
in 4 days
$ 500
in 15 days
$ 185
in 5 days
$ 125
in 7 days
Hire gyk
$ 300
in 14 days
$ 75
in 3 days
$ 200
in 0 days
$ 300
in 15 days
$ 80
in 5 days
$ 250
in 3 days