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

Explain what is “asynchronous” communication in sql server service broker?

0 Answers  

---

I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers   DELL,

---

What is postgresql server?

0 Answers  

---

Explain the relational database management system (rdbms)?

0 Answers  

---

What are the approximate numeric data types?

0 Answers  

---

how you can move data or databases between servers and databases in sql server? : Sql server administration

0 Answers  

---

What is bit datatype and what's the information that can be stored inside a bit column?

1 Answers  

---

What is the contrast between sql and mysql?

0 Answers  

---

What are sql servers used for?

0 Answers  

---

what is the Ticketing tool used in Wipro technologies at Bangalore...???

0 Answers   Liquid Hub,

---

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

0 Answers  

---

How can you find out how many rows returned in a cursor?

0 Answers  

---