[ic] Copy data from mssql to mysql

Peter peter at pajamian.dhs.org
Thu Jun 22 19:44:17 UTC 2017


On 23/06/17 01:34, marco wrote:
> I am begin to work about a nightly data bridge, a scheduled procedure
> running on web server that read from mssql and write on mysql, not a
> definitive migration.

I do a very similar replication from mssql to mysql using perl DBI.  You
can use dbd::ODBC to connect and retrieve data from the mssql server and
dbd::mysql for the mysql side and script the transfer.

Note that it's also possible for Interchange to connect directly to the
mssql server using dbd::ODBC.


Peter



More information about the interchange-users mailing list