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 a
s 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 appreciat
ed.

Thanks in advance.
Regards,
Ram

[ Post a follow-up to this message ]

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

[ Post a follow-up to this message ]

Hi scott,

Thanks for ur suggestions. But how do the webservice know the changes happen
ed in the databases.
whenever the insert/update happens at the DB side, the same will be reflecte
d 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 S
QL
> 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. 
>
>
>

[ Post a follow-up to this message ]