What are the different types of replication? How are they used?
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
How will you hide an attribute? : sql server analysis services, ssas
what is the information that can be stored inside a bit column? : Sql server database administration
Mention the uses of stored procedures.
What is a rollup clause?
What are the different types of columns types constraints in the sql server?
What happens if null values are involved in arithmetic operations?
What is default constraint?
What is left outer join in sql server joins?
What is the use of custom fields in report?
How many databases Microsoft SQL server provides?
What is relationship? What number of sorts of relationship are there?
In which sql server version report builder introduced?
What is the use of “join” in sql server?
What is apply operator in sql?
What does it mean to normalize a database and why would you do it?