Datatype image in MS-SQL

[expired user #6791]'s profile image [expired user #6791] posted 11 years ago in General Permalink
Hi, am still so happy that HeidiSQL is such a great product.
Was extra happy when I got a new job and have to deal with
MS-SQL-Server and realized that Heidi can deal with this, too.
I have to examine the tables of this huge database (900 tables with about 200 columns each). I have only read access.
It works fine, but I am missing two features.
The first is most important for me. Several tables have columns with datatype 'image', approximately the same as 'binary'.
See http://technet.microsoft.com/en-us/library/ms187752.aspx
Heidi cannot display any row if one of these columns are selected. I'd propose either to display these columns as hex or deselect them automatically.
The other feature would be great, but maybe too much work:
Using Heidi as a converter from MS-SQL to MySQL. The feature is already present (SQL Export), but does not work, because of datatype confusion.
Thanks a lot
Werner
jfalch's profile image jfalch posted 11 years ago Permalink
for the second, you could use this.

Please login to leave a reply, or register at first.