Synchronize SQL server data to MySql

The daily data generated by the POs server needs to be synchronized to the MySql on the server. In addition, the database files generated by this POS machine have many tables, and third-party companies have provided some database table structure information. Then, the database on the POS machine is SqlServer. At present, there is an old one on the same side... We need to synchronize the daily data generated by the POS machine to MySql on the server. In addition, the database files generated by this POS machine have many tables, and third-party companies have provided some database table structure information.

Then, the database on the POS machine is SQL Server. At present, there is a previous synchronization program, which is also a synchronization between databases. Here we will provide a MySql configuration, Host, Port, and so on.

I personally have a relatively small amount of research on databases, so I don't know where to start. In addition, the previous synchronization program was written in PHP, so I don't know what to do if I want to test the program.

So I hope you can give me some advice on how to get a synchronization program. If you want to modify those items as needed, you can also use some experience or methods to synchronize data between databases.

Reply content:

The daily data generated by the POs server needs to be synchronized to the MySql on the server. In addition, the database files generated by this POS machine have many tables, and third-party companies have provided some database table structure information.

Then, the database on the POS machine is SQL Server. At present, there is a previous synchronization program, which is also a synchronization between databases. Here we will provide a MySql configuration, Host, Port, and so on.

I personally have a relatively small amount of research on databases, so I don't know where to start. In addition, the previous synchronization program was written in PHP, so I don't know what to do if I want to test the program.

So I hope you can give me some advice on how to get a synchronization program. If you want to modify those items as needed, you can also use some experience or methods to synchronize data between databases.

You can use some tools or third-party tools provided by sqlserver to synchronize data.

Http://www.databasejournal.com/features/mssql/article.php/1438201/Setting-Up-Transactional-Replication-A-Step-by-step-Guide.htm

Https://www.baidu.com? Wd = SyncNavigator % C2 % A0 & rsv_spt = 1 & rsv_iqid = required & issp = 1 & f = 8 & rsv_bp = 0 & rsv_idx = 2 & ie = UTF-8 & tn = baiduhome_pg & rsv_enter = 1 & rsv_n = 2 & rsv_sug3 = 1 & rsv_sug1 = 1 & rsv_sug7 = 100 & rsv_sug2 = 0 & inputT = 507 & rsv_sug4 = 507

Data is synchronized between databases. If there is no logical conversion, it is usually directly synchronized using the database or a third-party tool (DTS tool provided by sqlserver). If there is a complicated logical computing, it is generally implemented through some ETL tools, such as kettle and powercenter.

The scenario you are talking about is to use a PHP program for data synchronization. To learn more about the specific logic, it is best to design documents to the program developers. If not, you can only directly view the source code.

First, you must know the structure of the data table in the databases database! Others can be converted using languages or statements.