SQL Server Database Synchronization Solution

Quasi-real-time SQL Server Database Synchronization Solution

1. Requirements
1) How to synchronize online SQL Server database data to another SQL Server database in a timely manner.
2) data extraction from the data warehouse system puts a great deal of pressure on the source system, seriously affecting performance and response speed. How to quickly extract production data to a historical data warehouse to improve the performance of the business system.
3) Distributed Database: how to copy the database data of a branch to the database of the headquarters to facilitate the summary and statistics of the headquarters.
Common SQL Server database synchronization requirements in these business applications require a professional replication system.

2. Synchronization Solution
Introduction to longyun Image System
Langlang · Image System is a mature application system replication solution in the industry. It does not require the same source and target hardware specifications or configurations, it features quasi-real-time replication, less system and network resources, and flexible application methods. The image system supports quasi-real-time synchronization and backup disaster tolerance for SQL Server databases, Oracle databases, file systems, and other application systems.

Product components
Sqlserver database image proxy (for sqlserver 2000, 2005 ).
Image Storage Server (for Windows 2000, 2003 ).

Replication Principle
The image proxy of the Image System sqlserver database monitors the source sqlserver database and captures its changing transactions in real time, transmits the captured results to the target sqlserver database, and then executes the data to the target sqlserver database through the storage process.
The target sqlserver instance is running and can read and write data. The target system ensures the consistency and integrity of business data. The system is not affected by the operating system, hardware platform, and storage device, and does not need to be consistent with the source and target.

Application Deployment

Deployment Architecture

Install the sqlserver image proxy on the source sqlserver database server; install the image server on the target sqlserver database server.
The system administrator can configure image policies, full and incremental jobs on the Management end.

Configuration Policy: After the benchmark synchronization is run for the first time, data from the source sqlserver database will be copied to the target database in real time.
Benchmark synchronization for the first operation: You can back up the database of sqlserver and restore it on the slave sqlserver. For file systems, copy all files to the target server using a "full image.
Quasi-real-time incremental Image: The image proxy monitors transaction changes, captures database operations in real time, and then transmits this operation to the image server. After the backup server receives the image, it submits it to the backup sqlserver server to complete an image process.

　

Sqlserver synchronization Technical Parameters

Technical Parameters	Description
Replication Principle	Capture sqlserver incremental transactions for replication
Replication Granularity	Database records
Copy DDL Language	Copy the database definition language, for example: 1) add, delete, and modify tables 2) add, delete, and modify field definitions 3) add, delete, and modify triggers and stored procedures ...
Copy DML Language	Copy the data submitted by the application
Save transaction logs	The system saves the captured transaction logs.
Source and target hardware specifications	No need for consistency
Network bandwidth usage	Far smaller than storage layer Replication
Replication latency	Asynchronous replication, latency in seconds
Maximum replication distance	Unlimited
Impact on system performance	The CPU usage of the source system cannot exceed 5%
Supported Application Methods	One-to-one, one-to-many, and multiple-to-one
Transaction integrity	Complete and consistent
Target application system status	Running status, capable of reading and writing
Replication direction	Unidirectional from source to target
Filter supported	Configurable filter conditions
Supported versions	Sqlserver 2000, sqlserver 2005