Biztalk Server 2004 - Database synchronization

Hi all,

I have a requirement where in I need to synchronize my legacy Progress
database to SQL Server.

a) whenever a row gets inserted into my Progress tables, I need this
row to get inserted into my SQL Server table as well. what are the
various options to access this database from biztalk? Progress adapter?
Get the changed data onto MSMQ somehow and use MSMQ adapter?

b) The Progress tables are not normalized. Hence, in some cases, a
column in Progress table maps to 3 columns in SQL Server tables. Also,
I need to slice the column data from Progress and send the individual
slices to each of the 3 columns in SQL Server.

c) When a table gets updated in Progress, I want 3 tables in SQL Server
to get updated. And, all the 3 updates should happen or none should
happen.

d) I need to have transaction ordering support. For e.g. in Progress,
table T1 and table T2 get updated. So, in SQL Server, I want the table
T2 to get updated first and then T1 should get updated.

e) There is a reverse synchronization requirement from SQL Server to
Progress. Whenever a row in SQL Server gets updated, I need to update
the corresponding tables in Progress as well.

Can I achieve all these things using Biztalk server 2004? Is Biztalk
2004 the right tool for such requirements? Any help in this regard
would be appreciated.

.

Relevant Pages

  • How to narrow down the failure message
    ... I have a nightly job which copies the entire contents from a Progress database to a SQL Server 2005 one. ... Is there any way to make a Failure statement pinpoint the exact item that caused the failure? ...
    (microsoft.public.sqlserver.server)
  • Re: Need Help Exporting a Progress Table
    ... apllication connects to a progress database using a Data Direct SQL92 ... In order to stop using this database and just use SQL Server 2005 I ... export delimiter "," tablename. ...
    (comp.databases.progress)
  • Access to Progress data files from SQL Server
    ... I've got a backup of a Progress 8.3 database that I need to access and ... eventually port into MS SQL Server. ...
    (comp.databases.progress)
  • Re: Biztalk Server 2004 - Database synchronization
    ... There are cases where these types of problems are well addressed by BizTalk ... > I have a requirement where in I need to synchronize my legacy Progress ... > database to SQL Server. ... > row to get inserted into my SQL Server table as well. ...
    (microsoft.public.biztalk.general)
  • Re: Progress ODBC Connection Problem
    ... SELECT prod, cono, whse ... trying to connect to a progress 9.1E db. ... I have the Datadirect drivers ... SQL Server Inport & Export Wizard ...
    (microsoft.public.sqlserver.odbc)