What are the different types of replication? How are they used?
- 3 Answers
- 12308 Views
- I also Faced
- E-Mail Answers
Answer Posted / meeran
Replication is the process of sharing data between
databases in different locations. Using replication, we can
create copies of the database and share the copy with
different users so that they can make changes to their
local copy of database and later synchronize the changes to
the source database.
Microsoft SQL Server 2000 supports the following types of
replication:
Snapshot Replication
Transactional Replication
Merge Replication
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
When columns are added to existing tables, what do they initially contain?
Are all views updatable ?
How to fetch the next row from a cursor with a "fetch" statement?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
What is Sqlpaging in SqlServer 2005 ?
How do I find my localdb version?
What is the distinction amongst delete and truncate?
How raid can influence database performance?
Difference between 2NF &3NF ?
What is set nocount on?
What is RAID? What are the different types of RAID configurations?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
What is report subscription?
What is table join?
how many triggers you can have on a table? : Sql server database administration
