what is replication?
where do u use Go Keyword?
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
How to delete all rows with truncate table statement in ms sql server?
Explain about link server in sql server?
How many levels of sp nesting is possible?
How to execute a sql statement using odbc_exec()?
What is the template in sql?
What are triggers? How do you invoke a trigger on demand?
Explain index in sql server?
What is normalization process?
What is the difference between stored procedure and user defined functions?
What is a schema in ms sql server 2005?
What is an indexing strategy?
How many databases can we create in a single server?
What is exclusive locks?
what are the reporting service components in SSRS?
How column data types are determined in a view?