sqlbase 9.1 to sql server 2008 r2 convertion.

Legacy Contributor

The transfer program VMXFER will not transfer my table OPERATION_BINARY. The table has several .bmp and .jpeg pictures in it. I have tried to use Access to link the tables and move it up that way and it didn't work. All the columns look ok except the BITS field. It only moves 1 character. I then made a local-binary table moved 6 records into it and tried to move them up and it did the same thing only 1 character moved up. looked at the local_binary table and it looks ok and it shows the text. The column was defaulted to a memo field which only allows @ 65000 characters. Several of the records are over that. Changed the field to ole object and tried that and same thing. Do have a long work around unless someone can tell me something else. First take a copy of the database and load it on SQLBase ver 8. When I did this it loaded right up. Then do the transfer to SQL server 2005. Everything seems to work there just fine. Then move the database to SQL Server 2008. Any other suggestions would be grealtly appreciated.

Thanks
Joel