Re: Copy data from mssql to mysql

On Thu, 22 Jun 2017, 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.
>
> Search and found more then one solutions but none fits my needs, CSV 
> esport and import is considerated not reliable.
>
> Any suggestions about ?

That sounds like a good use case for Bucardo, a replication system 
primarily focused on PostgreSQL, but which also supports MySQL, Oracle, 
Firebird, MongoDB, and others. But not yet Microsoft SQL Server! So you 
would need to do some development work on it to get it to talk to SQL 
Server.

I have never used any of these, but you may want to check them out:

https://www.symmetricds.org/

https://www.packtpub.com/books/content/mysql-data-transfer-using-sql-server-integration-services-ssis

HTH,
Jon


-- 
Jon Jensen
End Point Corporation
https://www.endpoint.com/