Interested to Buy Any Domain ? << Click Here >> for more details...
what is replication?
where do u use Go Keyword?
- 1 Answers
- 4881 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 differences in between sql server 2012 and sql server 2016?
Is INSTEAD OF trigger directly applicable to Table ?
What is Extended user-defined?
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
What are the authentication modes in sql server? How can it be changed?
what do you understand by change data capture?
What are the lambda triggers?
What is the difference between cartesian product and cross join?
What does set rowcount do?
How can I create a new template for import ? : sql server management studio
How do use Having,Group by,Group function in SQL?
How to download and install microsoft .net framework version 2.0?
write an SQL query to list the employees who joined in the month of January?
How to disconnect from a sql server using mssql_close()?
How efficient you are in oracle and SQL server?
