SSMA for Sybase truncating image data type to 32768

Tahir Khalil 61

Hi,

I am using SSMA for Sybase to migrate Sybase ASE 16 database to MS SQL Server 2022 on Linux.

A table with image type column is migrated but the data in this column limited to 32768. I believe if this data migration program is using bcp - it might be the limitation of that, but I am not sure.

Can someone help in this? I try to figure out the setting, but could not find anything related to image data type.

Thanks

1 answer

LiHongMSFT-4306 28,576 Reputation points

2024-10-23T03:19:46.8333333+00:00
Hi @Tahir Khalil

How about change the column type to VARBINARY(MAX):

CAST(ColumnName AS VARBINARY(MAX))

Best regards,

Cosmog

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Please sign in to rate this answer.
Tahir Khalil 61 Reputation points

2024-10-23T13:41:29.76+00:00

You mean at target SQL Server side - Although I read in some documentations of SQL Server that the image type would be deprecated but still the SSMS is mapping it to image data type at target. I am not sure the impact - if someone can confirm that SQLBulkCopy class functionality would work without limiting the copying of data from source to target for varbinary. I have seen the defaults of BCP usually dont go beyond 32K.

The Sybase documentation says for BCP

When you copy out text or image data, the SAP ASE server, by default, copies only the first 32K of data in a text or image field.

The -T text_or_image_size parameter allows you to specify a different value.

Just need a confirmation a way to get more than 32k from Sybase is enabled in SQLBulkCopy class?

Thanks

Tahir Khalil 61 Reputation points

2024-11-04T17:21:16.84+00:00

Anyone can check this please?

Tahir Khalil 61 Reputation points

2024-11-05T22:09:26.0866667+00:00

@LiHongMSFT-4306I tried with your suggestion the result is same - the data migrator is again transferring the same amount of data ie. 32768.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

SSMA for Sybase truncating image data type to 32768

1 answer

Your answer