Database synchronization


We need to map and keep in sync a remote DB2 database on AS/400 with an internal database (that has jet to be created). When a record is added edited or deleted on the remote database, the internal database must be kept in constant sync. On the remote DB there are more or less 20 tables with 200 fields (20-30 thousand records).

It will just need to go one way so you don't need to refresh the remote database in case the internal DB is modified.

For the internal database I would suggest Postgres as cost effective solution, but is absolutely not a constrain and any suggestion is welcome.

There are many ways to do this (via transaction logs, or creating a small daemon etc.) you can use a Windows environment (no vb6 just dot net for visual studio solutions) or a *nix environment.

Just remember that we need something that is completely reliable.

I attached two files to give you a general overview of the system environment and a simpler one of what the system has to do. The part that needs to be developed is the orange box.

For any further info you might need just ask me in PM

Thanks for your interest in our project

Good bidding

Beceriler: .NET, C Programlama, Delphi, Perl, Python

Daha fazlasını gör: use case map, creating use case, a small orange, synchronization remote database, local database synchronization pda, net remoting database sync, remote database synchronization tcpip, database synchronization daemon, synchronization local database remote server database, website development synchronize office database website database, syncrhonization local database, as400 data synchronization, perl database synchronization, database sync, database synchronization, synchronization datebase, what is visual studio, db transaction, db solutions, postgres, nix solutions, map database, map box, database info, C# database

İşveren Hakkında:
( 27 değerlendirme ) Wilmington, United States

Proje NO: #112800



Hello. We have done similar idea for SQL Server database with C#.Net (Visual Studio 1.1 and may be easy to transfer to [login to view URL] 2.0 C#). It worked with SQL Server databases for eCommerce application to synchronize the of Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 300%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(1 Yorum)

Bu iş için 4 freelancer ortalamada $285 teklif veriyor


Hello, Please look at the PMB. Thanks, Sergey

in %bids___i_period_sub_35% gün içinde300%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(31 Değerlendirme)

I have been working on similar application. Althoug it was MS SQL master DB and few handheld PDA'as with local DB on each. Relication operated bidirectionally. Essential idea was auxiliary table on master DB, in which Daha Fazla

in %bids___i_period_sub_35% gün içinde300%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Thanks for the project and Please check PM.

in %bids___i_period_sub_35% gün içinde240%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

wrote several scripts for the same sort of task. definitely not a complicated one and ofcourse reliability would be my primary concern always. regards, RaviGoru

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)