_________________ Feature is used to copy database from one source server to a destination server.
-
Synchronization
-
Replication
-
Collation
-
Copy
Replication is the SQL Server feature designed to copy and distribute data from one database to another, supporting various models like snapshot, transactional, and merge replication. Synchronization implies bidirectional updates, collation refers to text encoding rules, and Copy is not a standard SQL Server feature.
Replication is the SQL Server (and general database) feature specifically designed to copy and synchronize data from a source/publisher server to one or more destination/subscriber servers, keeping them in sync on an ongoing or scheduled basis. "Synchronization" and "Collation" are related but distinct concepts (collation governs sort/comparison rules for text, not data transfer), and there is no dedicated feature simply called "Copy" for this purpose.