October 7, 2005 at 11:17 am
Help appreciated here...porting Notes DBs via notesSQL, DTS to 2K with no problems save I can't seem to port the binary data (Word docs usually, less than 64K) held in Notes Rich Text fields.
My Blob field is always the last one in the tables in SQL2K.
I know zip about Notes and have probably missed the obvious solution whilst banging my head off the table today, so it's cap in hand time.
Would appreciate any pointers at all. TIA.
October 11, 2005 at 11:11 am
Hi...worked this out by my self (sort of).
For anyone with the same problem the answer is at http://www.advisor.com in document 16166 under the IBM or Notes forum.
You'll need to register and pay, but the solution and code download is well worth it.
The solution ports the notes DB to Access, but the beauty is that it extracts the BLOBS and places them in a file directory under the MDB created. You can edit the code to accomodate SQL, keep the BLOBs as they are or just port the resultant Access DB direct to SQL and copy the file directory to your IIS app or whatever. Lovely!
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply