SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,361 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
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
Thanks a lot this helps.