Re: Copy data from mssql to mysql

Peter <[email protected]>
Newsgroups gmane.comp.web.interchange.users
Message-ID <[email protected]> 
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.