SQL Server Replication

Case Study

We were contacted by the client to provide SQL Server consultancy, as we have many years of experience providing database services to medium and large enterprises.   After evaluating several possible approaches against the client’s requirements, we implemented SQL Server Replication. We chose this solution because:

• It allows fine-control over what data is synchronised
• It is a reliable and well-understood technology
• The target database is not read-only, meaning that it can be optimised for a specific workload, without impacting the source database
• Transactional consistency is guaranteed
• There is a very low performance impact on the source database
• The implementation cost is low

We were able to quickly implement the solution in a development environment. The client was then able to test it and confirm it met their expectations. Shortly after, the solution was implemented in the production environment.