SQl2000 Data Synchronization Technology (DTS, Replication)

Method 1> execute jobs and submit SQL statement statements (you can generate the statement as needed ...)
Method 2> use the Data transmission service package.
Method 1>
Niu Ren can directly establish it here :]

For example, we recommend that you use the data transfer method to generate your own logs.

 

Then, follow our steps to initiate an outbound operation.

 

We can see from above

Data transmission packages can be saved in four forms.
(1) SQL Server (saved in the msdb database of SQL Server)
(2) SQL Server Meta Data Services
(3) structured storage file
(4) Visual basic File

We have created the DTS package according to the above.

How to record data in a row: 1> record data in Enterprise 2> use the command line tool dtsrun to execute the data transmission package

Execute the structured storage file DTS package

 

Dtsrun/Ffilename/Npackage_name/Mpackage_password

 

Run the data transmission package stored in the SQL Server msdb database.

 

Dtsrun/Sserver_name/Uuser_nName/Ppassword/Npackage_name/Mpackage_password

 

Run the Data transmission package stored in Meta Data Services.

 

Dtsrun/Sserver_name/Uuser_nrame/Ppassword/Npackage_name/Mpackage_password/Rrepository_name

 

Iii. Compile

The Compile System is the time when the data processing root server is empty, the technical skills of data synchronization can be realized through the development and release (if the server has too many requests, this method is not recommended)

You must first create a deployment and then perform deployment again.

Release:

 
Zookeeper