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

Can a rule be bound to any column of any data type?

0 Answers  

---

How can I enforce to use particular index?

1 Answers   Symphony,

---

What do you mean by sql server 2005 express management tools?

0 Answers  

---

Explain the cursor lock types?

0 Answers  

---

Where to find ntwdblib.dll version 2000.80.194.0?

0 Answers  

---

How do we rollback the table data in SQL Server

3 Answers  

---

What is a mutating table error and how can you get around it?

0 Answers  

---

What do you understand by check constraint in sql server?

0 Answers  

---

What is user stored procedure & it purpose?

4 Answers   Wipro,

---

What is sql view?

0 Answers  

---

What are binary string data types in ms sql server?

0 Answers  

---

Can Having clause be used without Group by clause?

6 Answers   CarrizalSoft Technologies, CSC, CTS,

---