SQL Server data synchronization to MySQL

This way you need to synchronize the daily data generated by the POS to MySQL on the server. And this POS machine produces the database file has a number of tables, the third party company this side gave some database table structure data.

Then the database on the POS machine is SQL Server. Now there is a previous synchronization program, but also the synchronization between the databases. Here is a MySQL configuration information, some host,port and so on.

Because my personal research on the database is relatively shallow, so I do not know where to start. And the previous synchronization program is written in PHP, so test the line and do not know what to do.

So hopefully a little big God pointing out that I got a sync program if you want to modify what you want to see based on my needs, some experience or method of synchronizing data between databases.

Reply content:

This way you need to synchronize the daily data generated by the POS to MySQL on the server. And this POS machine produces the database file has a number of tables, the third party company this side gave some database table structure data.

Then the database on the POS machine is SQL Server. Now there is a previous synchronization program, but also the synchronization between the databases. Here is a MySQL configuration information, some host,port and so on.

Because my personal research on the database is relatively shallow, so I do not know where to start. And the previous synchronization program is written in PHP, so test the line and do not know what to do.

So hopefully a little big God pointing out that I got a sync program if you want to modify what you want to see based on my needs, some experience or method of synchronizing data between databases.

You can synchronize data with some of the tools that SQL Server comes with or a third-party tool

http://www.databasejournal.com/features/mssql/article.php/1438201/ Setting-up-transactional-replication-a-step-by-step-guide.htm

https://www.baidu.com/s?wd=SyncNavigator%C2%A0&rsv_spt=1&rsv_iqid=0xbc26ab53000011e4&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 synchronization between databases, if there is no logical conversion, usually using the database comes with or third-party tools to synchronize directly (SQL Server with DTS tools), if there is more complex logical calculation, usually through some ETL tools to achieve, such as Kettle,powercenter.

You say the scene, is the use of PHP program data synchronization, want to understand the specific logic, the best to the program developers to design documents, if not, you can only directly see the source code.

First, you need to know the data table structure of the synchronicity database! Everything else can be converted in words or statements.

