How to load data from MYSQL to SQL Server and update all the tables every 15 mins

Question

Hello,

I have an MYSQL server that has like 25 tables. I need to move them to the SQL server and keep them updated every 15 mins.

Can anyone suggest to me what would be the best methods or approaches to achieving this?

Thanks.

Answer 1

Using SSIS you can achieve this. Please refer to the below links for the detailed steps:

https://www.cdata.com/kb/tech/mysql-ssis-task-import-2008.rst

https://www.clariontech.com/blog/migrating-mysql-data-into-ms-sql-through-ssis

Answer 2

Thanks a lot this helps.