Re: Database synchronization
From: Ram (Ram_at_discussions.microsoft.com)
Date: Mon, 28 Jun 2021 02:24:02 -0700
Thanks for ur suggestions. But how do the webservice know the changes happened in the databases.
whenever the insert/update happens at the DB side, the same will be reflected in the new database. Can i do this thru webservice?
"Scott Cairney" wrote:
> One suggestion I would have to replace replication would be to implement
> webservices that gather the data from the various sources, have a BizTalk
> orchestration call these services, consolidate the data then write it to SQL
> Server with the SQL Adapter.
> That would allow you to build a very flexible solution using the business
> process management features such as the rules engine. - also available to
> you will be the monitoring capabilities of BAM.
> "Ram" <Ram@discussions.microsoft.com> wrote in message
> > Dear experts,
> > I need your suggestions whether my approach is correct or not.
> > Problem:
> > 1. We have a several applications which are using different databases such
> as SQL 2000, sybase and DB2.
> > 2. We planned to build a centralized database in SQL 2000.
> > 3. The data in the new database needs to be in sync with the legacy
> systems till such time that the existing legacy systems are decommissioned
> > Apporach:
> > 1. We planned to build a bridge between these databases using the BTS2004.
> > 2. Planned to use MSMQ(T) to get the primary data of changed table.
> > 3. Don;t want to write any triggers or SP in the legacy system database.
> So we planned to use replication to notify the changes to BTS2004.
> > Any other best soution to achieve this scenario? your help will be
> > Thanks in advance.
> > Regards,
> > Ram