what is replication?
where do u use Go Keyword?
- 1 Answers
- 4478 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / jijo
Synchronizing data and object between systems .
For example i have 50gb data in Delhi server(Publisher or
source ) i need to replicate into tow locations one into
mumbai server 10gb data (subscriber ) and another one into
kerala server 20gb data.
Publisher ---Source
Subscriber ---destination
Distributor--- Receive from publisher and forward to sub
Type of replications
1)Snapshot (one way)
Data refresh of the subscriber every time you synchronize.
2)Merge Replication (Two way)
Both publisher and subscriber can make change to the data.
Conflict :- When two participant chenge the same row at same
time
3)Transactional replication
As change made at the publisher its send to the distributor
and distributor into subscriber
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are sub reports and how to create them?
What is sharding?
What is difference between oltp and olap?
How to create indexed view?
what are the different ways to return the rowcount of a table?
what information is maintained within the msdb database? : Sql server administration
How to define output parameters in stored procedures?
How many types of built in functions are there in sql server 2012?
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?
How to create nested stored procedure?
How can we determine what objects a user-defined function depends upon?
What are the database objects? : SQL Server Architecture
How to use the inserted and deleted pseudo tables?
Does partitioning ssd reduce performance?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
