After upsizing the Web Wiz Forum Access database to SQL I found a problem with the datatypes, most important in tblthread.
The upsizing assistant changes the tblthread.message datatype from memo in the Access database to ntext in the SQL version.
The original SQL database, when setting up with the Web Wiz SQL_setup script, has the field tblthread.message set to text, and not to ntext. The problem with that is that ntext is using twice as much space as text, so I would like to ask:
Can I change the SQL datatype of tblthread.message from ntext to text without losing data? I already tried it and the SQL database size was cut into half almost (From 70MB down to 38MB), but I would appreciate a technical explanation whether I am losing data that way.
Can some people here who upsized from Access to SQL please post the datatype of their field tblthread.message in the SQL database?
Thank you for your help.
Edited by madolik - 12 October 2005 at 7:10am
Topic Options
Post Options
Thanks(0)
