Interested to Buy Any Domain ? << Click Here >> for more details...
what is replication?
where do u use Go Keyword?
- 1 Answers
- 4796 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 locks in sql?
How to change server name in sql server?
How many databases instances are there in sql server 2000?
What is the difference between varchar and nvarchar datatypes?
How do I find my localdb version?
List some major differences between triggers and stored procedures?
What is database replication? What are the different types of replication you can set up in sql server?
What program is used to store the data source file?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
How connect excel to sql server?
what is a mixed extent? : Sql server administration
How to verify the port number of the sql server?
Explain nested trigger in sql?
What is tcl in sql server?
How efficient you are in oracle and SQL server?
