20 GB Database to be Merge Replicated.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rogers - 30 May 2008 00:15 GMT

Dear Professional,

I would really appreciate if anyone of you can guide me, I have 20 GB of
database and I want to apply merge replication,

What would be the best approach?

Shoud I take a backup and restore into subscriber box first and after that I
will create Merge Replication? so that it won't eat network tranfic initially
becauase 20 GB of database needs to be moved into subscriber server?

Or should I keep the 20 GB database on Publisher Server and create merge
replication it will automatically move all the objects into Subscriber but
the only worry is 20 GB, it will eat alot of network traffic,

Please advice

Reply to this Message

Hilary Cotter - 30 May 2008 12:19 GMT

Yes, the backup with no-sync is probably the best option for you.

If you use merge replication with a push subscription it will likely take
quite some time depending on your network bandwidth.

> Dear Professional,
>
[quoted text clipped - 14 lines]
>
> Please advice

Reply to this Message

Noor - 31 May 2008 23:20 GMT

Quick question about PUSH and PULL subscription. What are the major
different between PUSH and PULL becauase while creating subscription it ask
me for two option. I am confused .. can any one help me?

Thanks

> Yes, the backup with no-sync is probably the best option for you.
>
[quoted text clipped - 20 lines]
>>
>> Please advice

Reply to this Message