Best solution to import records from MySQL database to MS SQL (Hourly)
- by xkingpin
I need to import records stored in a MySQL Database that I do not maintain into my Sql Server 2005 database (x64)
We should import the records at an interval basis (probably 1 hour).
What would be the best solution to perform the regular import?
Windows Service (using reference MySql.data dll)
Windows Client (could make it automated)
SQL Extended Stored Procedure (is it possible to reference the MySQL.data dll?)
SSIS package - Install MySQL ODBC driver
The problem with #4 is that I do not really want to support the ODBC driver on the sql server.
I'm not sure if you can even reference the x86 MySql.data dll into a x64 sql server process for #3. (Or if you can even reference that dll within a sql server project)