I am new in SQL tools and I have to export my notes db to SQL server because it 's going to disappear.
I have a db in local in SQL Server. I connect to it from Notes with a Lotus Script agent.
From my understanding, I think that SQL server can only accommodate 8000 characters per field. My problem is that some notes fields have more than 8000 characters, and I would have to export each notes field per SQL cell.
Also, some of those characteres are Japanese and Nordic, like:
ø, ÿ,ô,Ö, å,Ø...
My questions are:
does anyone knows if there is any way to resolve that character limit by cell in SQL?, or how can I export those fields?
will we have problems with converting due to foreign characters (Japanese,Nordic)?. I have maden a little test about it and the character å, ÿ ...have been exported in a right way......but It may be I haven't done it my best.
Can anyone help me?, has anyone worked on it?
Thanks a lot and regards