We help IT Professionals succeed at work.

int Vs Numeric , Varchar vs NVarchar - Which is good? (MS ACCESS TO SQL SERVER MIGRATION)

4,901 Views
Last Modified: 2009-05-07
Hi..
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???

suggestions please....
Comment
Watch Question

Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Jai STech Arch

Commented:
nvarchar - accepts unicode characters
varchar doe not ...so it depends on your application...
either you can change to varchar or keep it as such if you want unicode characters.
rather than (INT and NVARCHAR) use (INT and VARCHAR)  where NVarchar is the unicode type. which i assume you wont need. And int is better than numeric is you dont have precision in column values.

Commented:
Since in access you can have only number as datatype and in SQL server we have a range of datatypes for numbers like Numeric, int, double etc.
As per the other experts advice, i too ve the same opinion, if the data is going to be purely numbers with no precision, then simply go for int rather tham numeric.

Nvarchar and varchar choice is completly yours depending on the values that you have stored in that field.
By default when you use DTS package to transfer data from text it takes as nvarchar. you can use varchar if you don have any special character set data to be stored in the coulmn
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.