Web Services vs Standard Replication

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

megha - 02 Jun 2004 18:57 GMT

I am interested in any suggestions you might have. I have different
heterogeneous databases (max 100 in number) which need to transfer
their data to a central SQL Server database. This is going to be one
way channel where central database consolidates the data which is
coming from different sources. Central location needs to be kept
up-to-date on a periodic basis. Each source can have max 50KB of data.
Is this transfer size decent enough to go through web services or
standard replication would be the better alternative?

Source database can be either SQL Server or Oracle. During the
synchronization period, each source will push the data to central
server at different time. Supposedly, concurrency is not going to be
an issue.

What approach should I pursue - what are the pros and cons of each?

Reply to this Message

megha - 02 Jun 2004 23:10 GMT

Hi Dino

Thanks for the response! I am worried about the security of
transferred data in conventional DTS provided by SQL Server. Web
Services sounded more promising in that regard. I don't know much
about DTS though. I will greatly appreciate if you could point me to
some related documentation which will guide me through the feature set
and usage of DTS.

Thank You
Megha

> I am interested in any suggestions you might have. I have different
> heterogeneous databases (max 100 in number) which need to transfer
[quoted text clipped - 11 lines]
>
> What approach should I pursue - what are the pros and cons of each?

Reply to this Message

Dino Chiesa [Microsoft] - 05 Jun 2004 01:14 GMT

DTS is not my thang, but

there is a group here dedicated to it: microsoft.public.sqlserver.dts

and you can find tons of info here
http://www.google.com/search?hl=en&num=30&q="data+transformation+services"+++sit
e:microsoft.com

-dino

> Hi Dino
>
[quoted text clipped - 23 lines]
> >
> > What approach should I pursue - what are the pros and cons of each?

Reply to this Message

Rate this thread:

Web Services vs Standard Replication

Free Magazines