|
Home > Archive > BizTalk Server General > June 2004 > Database synchronization
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Database synchronization
|
|
|
| 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 appreciated.
Thanks in advance.
Regards,
Ram
| |
| Scott Cairney 2004-06-26, 10:51 am |
| 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
news:28BF86F1-9E45-441F-9E9C-9CF83E5FF8D5@microsoft.com...
> 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
appreciated.
>
> Thanks in advance.
> Regards,
> Ram
| |
|
| Hi scott,
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?
Regards,
Ram
"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
> news:28BF86F1-9E45-441F-9E9C-9CF83E5FF8D5@microsoft.com...
> as SQL 2000, sybase and DB2.
> systems till such time that the existing legacy systems are decommissioned
> So we planned to use replication to notify the changes to BTS2004.
> appreciated.
>
>
>
|
|
|
|
|