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

sujith kumar matharasi 351 Reputation points
2021-08-21T03:18:52.14+00:00

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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,894 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,467 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,564 questions
0 comments No comments
{count} votes

1 additional answer

Sort by: Most helpful
  1. sujith kumar matharasi 351 Reputation points
    2021-08-22T21:40:22.14+00:00

    Thanks a lot this helps.

    0 comments No comments