sql2000 server and MSDE Replication

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jongwoo - 30 May 2006 01:38 GMT

Hello.

I will construct client application with MSDE.

I face with a difficult question.

It's in sync with SQL2000 Server and MSDE.

Client number is 5000.

I fall in a dilemma. Which do i use, Replication or to make DB Sync
application ?

Thank you

jongwoo

Reply to this Message

Paul Ibison - 30 May 2006 09:14 GMT

Your question is an incredibly wide one :). Some considerations you might
have are:

Is the subscriber updatable?
Will you have several subscribers?
Do you want to overwrite all the data?
Do you want to take a subset of the publisher's data or the complete
database?
If you give up as much info as possible, including answering the above
questions, we should be more able to help out.

Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Reply to this Message

jongwoo - 30 May 2006 10:15 GMT

Thank you Paul.

The subscriber does updatable.
The subscribers are 5000 .
A part data is overwrited all the data and any data is not overwrited.
The subscriber take data querying database by it's condition.

for example. client take data with exactly his customer
and client update local database -MSDE- finaly local datadase sync the sql
server.

thanks

Reply to this Message

Paul Ibison - 30 May 2006 20:17 GMT

Wow - you have a LOT of subscribers! You have updatable subscribers and as I
understand it, each subscriber has its own distinct subset of the data? ie
the data is partitioned? In this case I'd recommend merge replication with
dynamic subscriptions and pull subscriptions.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Reply to this Message