In Progress

2-way real-time synchronisation MS SQL and Postgresql

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.

Skills: .NET, Java, Python, Software Architecture, SQL

See more: sql server open source, open source sql, free java codes, time record, sql java, sql and c, postgresql c++, Java SQL, delivery time, python ubuntu, java record software, sql different, queues, real time system, use java python, real replication, real time server architecture, time server, python message, open source java postgresql, sql server replication, postgresql sql, python small, delivery system sql, sql replication

About the Employer:
( 8 reviews ) Montpellier, France

Project ID: #4250575

Awarded to:

nitinmms

Can be done as required with Message Queue in between. Application will be event driven (no polling required).

$125 USD in 7 days
(5 Reviews)
4.5

10 freelancers are bidding on average $222 for this job

DandDSolutions

We are interested in your job offer. what we need is java + opens source MQ

$200 USD in 4 days
(190 Reviews)
6.7
aaravsoft

Hello, Please check pmb. Regards,

$185 USD in 5 days
(62 Reviews)
5.8
ils7

I developed similar project

$500 USD in 15 days
(23 Reviews)
5.1
gyk

Hello, Have done similar work before, I am happy to help you.

$300 USD in 14 days
(6 Reviews)
4.8
NirvanaWebDev

I know exactly how to handle this. I have extensive knowledge and experience using Python to interact with databases. I can start immediately or whenever you're ready and can guarantee your satisfaction. Regards

$75 USD in 3 days
(12 Reviews)
4.0
zkutch

Hello. More 20 years programming experiense. See pmb, please.

$200 USD in 0 days
(6 Reviews)
3.2
mouVo1P

Consider it done. Thank you

$250 USD in 3 days
(0 Reviews)
0.0
bap0n

please check my pm

$80 USD in 5 days
(0 Reviews)
0.0
hainguyen83

Please check pmb. Regards

$300 USD in 15 days
(0 Reviews)
0.0