[ic] Copy data from mssql to mysql

marco m.mescoli at omnib.it
Fri Jun 23 16:49:09 UTC 2017

Thanks Jon, I read about Bucardo (sounds as italian name) a real time db 
data mirror? Very interesting and powerful but seems too hard and heavy 
work for me to adapt for mssql mysql.


Il 22/06/2017 17:54, Jon Jensen ha scritto:
> 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

"Fino alla bara sinpara"
"Up to demise we rize"

More information about the interchange-users mailing list