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

Difference between report and query parameter.

0 Answers  

---

Explain differentiate between a having clause and a where clause?

0 Answers  

---

What is the definition for sql server 2000?

0 Answers  

---

what is maximum size of temp db?

4 Answers   iSoft,

---

What is stored procedures?

0 Answers  

---

---

Do comments need to go in a special place in sql server 2005?

0 Answers  

---

Explain trigger classes i.e. Instead of and after trigger?

0 Answers  

---

OPTIMIZATION OF SP,CURSOR,TRIGGERS

0 Answers  

---

Tell me what is a linked server?

0 Answers  

---

How do I find the transaction log size in sql server?

0 Answers  

---

what are default? Is there a column to which a default cant be bound?

1 Answers  

---

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

0 Answers  

---