I am planning to migrate my website which uses the MS ACESS Database to MS SQL Server 2000.
So, I have to move the tables and queries from access db to sql server using DTS IMPORT EXPORT DATA.
BUT... In MS Access DB, I have set some field datatypes as text and number
but, when moved to SQL SERVER, it is set as INT and NVARCHAR...
Is it good to continue with this datatype(INT and NVARCHAR) or converting it to NUMERIC and VARCHAR is better???