Interested to Buy Any Domain ? << Click Here >> for more details...
what is replication?
where do u use Go Keyword?
- 1 Answers
- 4923 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / 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
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
What is index, cluster index and nonclustered index?
What are the encryption mechanisms in sql server?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
How to compare the top two records using sql?
Tell me about the approaches which you used to counter the DI problems.
Explain external key management in sql server 2008
How to create a login account in ms sql server to access the database engine using "create login" statements?
What are the common performance issues in sql server?
How can you manage sql azure security?
What are policy management terms?
How do you delete a trigger?
Explain few of the new features of sql server 2008 management studio
What protocol does sql server use?
Tell me about builtinadministrator?
