I am trying to use your product (v2.1.0.22) to move an old database accessible via ODBC to an Oracle 10G database for archive puposes. I can generate scripts for just the table structure and or the data without any particualr problem expect for the fact that the character fields in the resulting table structure are being defined are nvarchar2 format rather than the varchar2 format I would prefer. I could do a global replace but I would be happier if the scripts were generated in this form in the first place. Is there any way to change the default varchar2 data type please ?
Thanks
Chris

News