Interested to Buy Any Domain ? << Click Here >> for more details...
what is replication?
where do u use Go Keyword?
- 1 Answers
- 4912 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 is a natural primary key?
What is ms sql server index?
How do I delete a sql server database?
What is a self join in sql server?
what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration
What is snapshot parameter in ssrs?
Explain about SQLOS?
How to create a new login name in ms sql server?
What is the boxing and unboxing concept in .net?
How to receive output values from stored procedures?
Explain go command in sql server?
How do you size a resultset?
How to assign null values to variables or columns?
Explain transaction isolation levels in sql server?
Explain transaction server isolation?
