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

how to get the salary in descending order with out using the keyword desc in sql

5 Answers   Ramco,

---

What is 'write-ahead log' in sql server 2000 ?

0 Answers  

---

What is the difference between indexing and hashing?

0 Answers  

---

What is the difference between resultset and resultsetmetadata?

0 Answers  

---

What are commonly used odbc functions in php?

0 Answers  

---

What is an index in sql?

0 Answers  

---

What are cursors? Name four types of cursors and when each one would be applied?

3 Answers   Adea Solutions,

---

What is the default port for SQL Server over a firewall?

0 Answers   Microsoft,

---

What are the types of model in sql server and explain

2 Answers   TCS,

---

Mention the different types of triggers?

0 Answers  

---

What's the difference between a primary key and a unique key?

10 Answers   Wipro,

---

What are the limitation of the Online Index Rebuild Operation?

1 Answers  

---