CODEWITHSUNDEEP
mysqlsql-servertransfer
adam Kearsley
adam Kearsley

Reputation: 999

Copy MSSQL data to MySQL DB every 5 mins?

I'm looking for some advice over the best way to transfer data from a local MSSQL DB to a remote MYSQL database every 5 mins? At the moment I am using a tool called SQLYOG which allows me to create a connection to my local MSSQL database and to my remote MYSQL server and set up some queries and mapping. It also allows me to create a windows scheduled task which runs every 5 minutes. This solution has been working ok but is only about 95% reliable and seems to struggle sometimes. This software runs in GUI mode and via cmd prompt so is reasonably light weight when running a scheduled task.

Does anyone know of any other light weight tools or methods I can use to get the same outcome?

Upvotes: 0

Views: 1072

Answers (4)

AnandPhadke
AnandPhadke

Reputation: 13506

What I feel is the best soultion for this is to design an ETL job using either SSIS or Talen Open Studio.

Upvotes: 0

user2001117
user2001117

Reputation: 3777

Couple of options: 1. create linked server to mysql then copy rows via linked server in sp, set sql job to execute. 2. build ssis package and run it in sql job.

Upvotes: 0

Euclides Mulémbwè
Euclides Mulémbwè

Reputation: 1687

you can use SSIS packages to do that.

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks.

Upvotes: 1

Raul
Raul

Reputation: 607

You can use SymmetricDS. its a good & efficient open source tool for this purpose.

Upvotes: 2

Related Questions