All geek questions in one place

How to transfer data automatically between MySql and Sql Server back and fourth?

I need to create a procedure to read data from SQL Server and paste it into MySql. I also need another procedure more for reading data from MySql server and inserting it into SQL Server.

I have never done that. I can’t figure out how to do this. Can someone tell me how I can do this?

I appreciate at least the idea of ​​where I can look for it.

I searched for it but did not find help.

I have Scribe software. I'm not sure if there is a future in Scribe that can help me with this?

Please note that this procedure will automatically start to transfer data or receive data from the source.

+4
source share
1 answer

The best way to achieve this is to create a Linked Server in SQL Server, so you can query SQL Server and MySQL from the same place. You can write a stored procedure to access both or a task to execute on a specific schedule.

Update: INSERT Request Example

INSERT OPENQUERY (SERVNAME, 'SELECT subject, notes FROM cms.mysql_table') SELECT subject, notes FROM sql_server_table
+3
source

Source: https://habr.com/ru/post/1484945/

More articles:


All Articles