Image from Access database to SQL Server

Question

I am writing code in C# and I am reading some values from an MS-ACCESS database file and transferring them to a SQL Server database. One column is of type "OLE Object" and contains an image. I get the byte array and store it to SQL server database but it seems that value is corrupt and it can't be rendered back into an image. Any ideas on how to make it work?

Is your SQL field VARBINARY? There are some recommendations here about when to store it in the database and when to use FILESTREAM instead: stackoverflow.com/questions/5613898/… — Russell Fox
– Russell Fox, Commented Jan 9, 2017 at 23:41

Geovanny Hernandez · Accepted Answer · 2017-01-09 23:15:50Z

1

Have you tried to rendered back and check before to store in SQL Server? I think that you would do this first. However, there is a tool called: SSMA Migration Assistant for Access (SSMA) which I think is more convenient that move one by one, there is an interesting link to use it.

https://blogs.msdn.microsoft.com/ssma/2011/03/06/access-to-sql-server-migration-understanding-data-type-conversions/

answered Jan 9, 2017 at 23:15

Geovanny Hernandez

2371 silver badge10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

V. Vouvonikos Over a year ago

I had tried that but finally the problem was my method of showing the image on the webpage so everything is solved now

Collectives™ on Stack Overflow

Image from Access database to SQL Server

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related