What is data Replication
Here I am going say a brief about data replication and data transformation which will helpful for your enterprise server and desktop needs. Today as you know most organizations depend on data from multiple databases. And data replication is a set of techniques for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency. Using replication we can distribute data over local and wide are networks, dial-up connections, Internet etc.
We can use transactional replication server to server which require high throughput, including improving scalability and availability for example data warehousing and reporting, and may need to integrate data from multiple sites,
Steps to be followed in data replication