[ic] Copy data from mssql to mysql
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.
More information about the interchange-users