What to use for periodic import from a remote DB?

Question

linux

Good afternoon.
There is a task: periodically (every 5 seconds, the period must be configured) connect to a remote database (MS SQL), and take the last records from a certain table (5-10 pieces) from there. These records must be entered into the local database (MySQL). Then perform further processing of information from the local database.
Post-processing will be done by php or perl scripts.
What came to my mind:
1. Create a task in cron, run a php or perl script task that will import data from a remote database. By cron'om to adjust the period of import of a remote DB.
2. Write a daemon that will either import the data itself or run the import script (php, perl).
Вопрос: Каким образом лучше реализовать указанный функционал периодического импорта данных из удаленной БД? Ваши варианты? Может есть готовые решения?

Answer 1

in the opposite direction, through SSIS did not consider? not to pull the muscle, but write MSSQL to it? from the point of view of ease of implementation (installation of all drivers), this option may be simpler.

Answer 2

cron is simpler and more reliable, the main thing is to make sure that one script instance always works.