将BLOB数据从MS SQL Server迁移到MySQL [英] Migrating BLOB data from MS SQL Server to MySQL

问题描述

我具有读取访问权限的远程MS SQL Server.它在BLOB中有成千上万张图片-许多问题之一是它们位于数据类型图像中.

There is a remote MS SQL Server that I have read access to. It has thousands of pictures in a BLOB- one of the many problems being that they are in datatype image.

我想将所有的BLOB数据传输到本地MySQL BLOB.我曾尝试使用php mssql_connect(很坏)，但无济于事，我也找到了textcopy.exe的副本.但是，textcopy.exe仅将数据作为照片提供给我，而不作为BLOB/HEX原始数据提供给我.最好的方法是什么，以便在将更多数据添加到MS SQL Server DB中时，我可以随时运行它?

I want to transfer all of that BLOB data to a local MySQL BLOB. I have tried using php mssql_connect (which is pretty broken) to no avail, I have also hunted down a copy of textcopy.exe; however, textcopy.exe only gives me the data as a photo-- not as the raw BLOB/HEX data. What is the best way of doing this, so that I can run it whenever I want to bring over more data as it is added to the MS SQL Server DB?

推荐答案

在 dbForge Studio for MySQL .选择一种ODBC数据导入格式，配置与MS SQL数据库的ODBC连接，然后尝试将数据迁移到MySQL.

Try Data Import tool in dbForge Studio for MySQL. Select an ODBC data import format, configure ODBC connection to MS SQL database, and try to migrate data into MySQL.

这篇关于将BLOB数据从MS SQL Server迁移到MySQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！