Share via

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.
14,492 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,697 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,707 questions
0 comments
Accepted answer
  1. Ravi Kakarla 161 Reputation points
    2021-08-22T19:09:19.31+00:00
    1 person found this answer helpful.
    0 comments

1 additional answer

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

    Thanks a lot this helps.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.