I have a question :
I am importing an older Access 97 database into SQL 2k/2k5 (I've tried both), and when I import (using the sql server management studio) it wants to convert ALL character types (char, number etc) into nvarchar, whereas I want it to convert to varchar2. I can't seem to find out WHY it is defaulting to nvarchar. Besides editing every single column reference in the import tool (well over 1000 total columns across 140 tables), is there a setting I can set to force the
import tool to use varchar2 instead (ie: I don't want to use ANY n types at all).
The reason for this is because once I have the database in SQL2k5 I need to run two queries, to convert all table and column names to full uppercase, and then I need to export the database directly into an oracle database. If the column definitions stay as n types, oracle uses NLS for character conversions and it royally screw things up for some software. So simple solution: use varchar2.
Thanks in advance,