Re: Copy data from mssql to mysql

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.

HTRH.

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"