The last project, requires the use of MySQL community edition (5.5 or above) real-time read data from MS SQL Server2012, I understand is probably can be decomposed into two problems:
1, how the SQL Server2012 as a data source, using MySQL ODBC or OLE DB or using other methods from the former read data?
2, on the basis of 1, how to realize the real-time, synchronous data?
Question 1 more prominent and urgent, want to ask the bosses here do give directions!
Talk about ideas can also ah, now didn't find relevant information, SQL Server access MySQL data in the BBS, but I don't know how to draw lessons from,

CodePudding user response:

It seems to be unable to access heterogeneous data sources in the MySQL
Can consider in SQL server build links to access the mysql server, and from the link to the mysql server data synchronization

CodePudding user response:

reference 1st floor ZJCXC response:

seems to be unable to access heterogeneous data sources in MySQL
Can consider in SQL server build links to access the mysql server, and writing a synchronous data from the link to the mysql server

Uh huh, using SQL Server and MySQL connection, SQL Server to write data in MySQL in this line of thought, can have a try! thank you

CodePudding user response:

This can be implemented at the code level and plan: real-time subscription data in a SQL Server, and then synchronization to MySQL, try!

Finally make a advertisement: personal WeChat public "andyqian", recently updated a lot of MySQL related knowledge, looking forward to communicate with you!

CodePudding user response:

This no good solution, different database, there is no way to transfer data directly, you can be in SQL server to establish the link of connection to the mysql server, and then reverse the data inserted into a mysql table,

Because mysql can't access to the SQL server data, unless, that is, the timing of the SQL server data import to the mysql server in a file, and then mysql data read from the file regularly, inserted into a mysql table,

The best way, I think it's implementation, on the application end connecting two database at the same time, from the SQL server check regularly, and then add new data to mysql, seemingly this comparison,

CodePudding user response:

reference JuQian blog's reply: 3/f

this can be implemented at the code level and plan: real-time subscription data in a SQL Server, and then synchronization to MySQL, try!

Finally make a advertisement: personal WeChat public "andyqian", recently updated a lot of MySQL related knowledge, looking forward to communicate with you!

Has been attention, hope to learn more!
Can be said to be specific, first of all, how to use data in a SQL server, mysql subscriptions need to write your own interface are available?

CodePudding user response:

reference 4 floor don't want to grow up ah response:

that it's not a good idea, different database, can't transfer data directly, you can be in SQL server to establish the link of connection to the mysql server, and then reverse the data inserted into a mysql table,

Because mysql can't access to the SQL server data, unless, that is, the timing of the SQL server data import to the mysql server in a file, and then mysql data read from the file regularly, inserted into a mysql table,

The best way, I think it is in the application side, two database connection at the same time, from the SQL server check regularly, and then add new data to mysql, looks like the comparison,

Applications can't connected two database implementation, only keep the data in the SQL server, center of gravity is out on his own database

CodePudding user response:

Datax can refer to it

CodePudding user response:

refer to 7th floor Loney1996 response:

datax can consult

Thank you,
Checked the, this is ali heterogeneous database synchronization tool for open source, to use this tool must use the JDBC interface, and now we are planning to use c + +, do not know to have the corresponding ODBC interface, or thanked first!