Answer / 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

What are different types of replication in sql server?

0 Answers  

---

How to loop through result set objects using odbc_fetch_row()?

0 Answers  

---

How to run queries with sql server management studio express?

0 Answers  

---

What is a table called, if it does not have neither Cluster nor Non-cluster Index?

2 Answers  

---

Where are SQL server users names and passwords are stored in sql server?

0 Answers   HCL,

---

---

How do I create a stored procedure in dbml?

0 Answers  

---

What is triggers in ms sql server?

0 Answers  

---

Tell me what do we need queues in sql service broker?

0 Answers  

---

What is the use of floor function in sql server?

0 Answers  

---

What is the difference between seek predicate and predicate?

0 Answers  

---

What is the difference between Triggers and Stored Procedure?

0 Answers   HCL,

---

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

0 Answers  

---