Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

need information on replication Expand / Collapse
Author
Message
Posted Tuesday, August 6, 2013 11:39 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 14, 2014 7:58 AM
Points: 139, Visits: 402
Hi

here i want some clarification on replication.
1) i want to know what is the difference between snapshot,transactional,merge,transaction with updatable sub replication

2) how each replication method will work.

here in my environment we have a large table in production database which has 4lacs records.

in that they have the access to users for reporting purpose due to that load is increasing on server so we want to configure the merge replication to ship the data in to another server.

here in merge replication if we did any changes in subscriber end those changes will reflect in publisher as well or not ?

please help me regarding usage and funcationality of replication.
Post #1481657
Posted Friday, August 9, 2013 1:55 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 14, 2014 7:58 AM
Points: 139, Visits: 402
please help me on above questions
Post #1482678
Posted Monday, August 19, 2013 9:57 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, September 26, 2014 4:52 AM
Points: 279, Visits: 849
You would probably be best doing a google search for the information about different types of replication. To explain everything in detail would take somebody a long time to type.

http://technet.microsoft.com/en-us/library/ms152531.aspx
Post #1485873
Posted Tuesday, August 20, 2013 8:29 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 4:35 AM
Points: 193, Visits: 734
Hi,

I'll be brief in my explanation.

Snapshot replication distributes data exactly as it appears at a specific moment in time and does not monitor for updates to the data. When synchronization occurs, the entire snapshot is generated and sent to Subscribers.

Transactional replication typically starts with a snapshot of the publication database objects and data. As soon as the initial snapshot is taken, subsequent data changes and schema modifications made at the Publisher are usually delivered to the Subscriber as they occur (in near real time). The data changes are applied to the Subscriber in the same order and within the same transaction boundaries as they occurred at the Publisher; therefore, within a publication, transactional consistency is guaranteed.

Merge replication, like transactional replication, typically starts with a snapshot of the publication database objects and data. Subsequent data changes and schema modifications made at the Publisher and Subscribers are tracked with triggers. The Subscriber synchronizes with the Publisher when connected to the network and exchanges all rows that have changed between the Publisher and Subscriber since the last time synchronization occurred.

Why do you want to implement Merge Replication when the same can be done through snapshot/transactional replication if it's only for transferring data for reporting purposes.
Post #1486278
Posted Tuesday, August 20, 2013 10:01 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 14, 2014 7:58 AM
Points: 139, Visits: 402
Thanks for your response

as per my client requirement we have one table which is having 5cr records presently we are given the access to users on production.

they want to reduce the load on prod so we want to configure the merge replication. here in the article properties synchronization mode is showing as bidirectional due to that performance is decreased.

so here which mode we have to choose. here user can change the data in subscriber as well.
Post #1486349
Posted Tuesday, August 20, 2013 11:07 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 4:35 AM
Points: 193, Visits: 734
I believe 5 cr request is not that huge. We have a setup with transactional replication that transfers millions of records for reporting purposes each day. As per your client requirement you need bidirectional flow of data so I would suggest to go with "Transactional Replication with Updates". I still don't understand the need to go for Merge Replication, you only would complicate things as it's kinda difficult to manage, and the requirement which you've provided doesn't support that either.

Check on BOL for more info.


Post #1486514
Posted Wednesday, August 21, 2013 2:48 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 14, 2014 7:58 AM
Points: 139, Visits: 402
thanks for your valuable information

in transactional replication with updates can we change any modifications on subscriber and those will reflect in publisher as well
Post #1486591
Posted Wednesday, August 21, 2013 2:55 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 4:35 AM
Points: 193, Visits: 734
You're welcome.

Yes it does push the changes made at the subscriber back on to the Publisher.


Post #1486594
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse