Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm trying to find a data type equivalents for data types in Netezza when migrating table schema to SQL Server. Where can I find a complete list? When getting down to brass tacks, I am specifically looking for Netezza 6 & SQL Server 2008.

Here is a complete list of the data types we're using in Netezza. Obviously some of these are dependent on length.

SELECT DISTINCT FORMAT_TYPE
FROM _v_relation_column


ABSTIME
BIGINT
BOOLEAN
BYTEA
BYTEINT
CHAR
CHARACTER VARYING(1)
CHARACTER VARYING(10)
CHARACTER VARYING(100)
CHARACTER VARYING(1000)
CHARACTER VARYING(10000)
CHARACTER VARYING(1024)
CHARACTER VARYING(108)
CHARACTER VARYING(11)
CHARACTER VARYING(110)
CHARACTER VARYING(1100)
CHARACTER VARYING(117)
CHARACTER VARYING(12)
CHARACTER VARYING(120)
CHARACTER VARYING(1200)
CHARACTER VARYING(128)
CHARACTER VARYING(13)
CHARACTER VARYING(14)
CHARACTER VARYING(140)
CHARACTER VARYING(15)
CHARACTER VARYING(150)
CHARACTER VARYING(1500)
CHARACTER VARYING(157)
CHARACTER VARYING(16)
CHARACTER VARYING(160)
CHARACTER VARYING(17)
CHARACTER VARYING(1700)
CHARACTER VARYING(18)
CHARACTER VARYING(1800)
CHARACTER VARYING(184)
CHARACTER VARYING(188)
CHARACTER VARYING(19)
CHARACTER VARYING(192)
CHARACTER VARYING(2)
CHARACTER VARYING(20)
CHARACTER VARYING(200)
CHARACTER VARYING(2000)
CHARACTER VARYING(201)
CHARACTER VARYING(2048)
CHARACTER VARYING(206)
CHARACTER VARYING(21)
CHARACTER VARYING(22)
CHARACTER VARYING(220)
CHARACTER VARYING(23)
CHARACTER VARYING(24)
CHARACTER VARYING(25)
CHARACTER VARYING(250)
CHARACTER VARYING(2500)
CHARACTER VARYING(254)
CHARACTER VARYING(255)
CHARACTER VARYING(256)
CHARACTER VARYING(26)
CHARACTER VARYING(27)
CHARACTER VARYING(28)
CHARACTER VARYING(3)
CHARACTER VARYING(30)
CHARACTER VARYING(300)
CHARACTER VARYING(31)
CHARACTER VARYING(32)
CHARACTER VARYING(33)
CHARACTER VARYING(35)
CHARACTER VARYING(350)
CHARACTER VARYING(37)
CHARACTER VARYING(38)
CHARACTER VARYING(4)
CHARACTER VARYING(40)
CHARACTER VARYING(400)
CHARACTER VARYING(4000)
CHARACTER VARYING(401)
CHARACTER VARYING(428)
CHARACTER VARYING(4282)
CHARACTER VARYING(450)
CHARACTER VARYING(46)
CHARACTER VARYING(5)
CHARACTER VARYING(50)
CHARACTER VARYING(500)
CHARACTER VARYING(5000)
CHARACTER VARYING(508)
CHARACTER VARYING(51)
CHARACTER VARYING(510)
CHARACTER VARYING(512)
CHARACTER VARYING(55)
CHARACTER VARYING(6)
CHARACTER VARYING(60)
CHARACTER VARYING(600)
CHARACTER VARYING(62)
CHARACTER VARYING(64)
CHARACTER VARYING(66)
CHARACTER VARYING(66046)
CHARACTER VARYING(7)
CHARACTER VARYING(70)
CHARACTER VARYING(700)
CHARACTER VARYING(75)
CHARACTER VARYING(77)
CHARACTER VARYING(79)
CHARACTER VARYING(8)
CHARACTER VARYING(80)
CHARACTER VARYING(800)
CHARACTER VARYING(8190)
CHARACTER VARYING(84)
CHARACTER VARYING(88)
CHARACTER VARYING(9)
CHARACTER VARYING(90)
CHARACTER VARYING(91)
CHARACTER VARYING(999)
CHARACTER(1)
CHARACTER(10)
CHARACTER(15)
CHARACTER(2)
CHARACTER(25)
CHARACTER(3)
CHARACTER(4)
CHARACTER(5)
CHARACTER(6)
CHARACTER(7)
CHARACTER(8)
DATE
DOUBLE PRECISION
INT2VECTOR
INTEGER
INTERVAL
NAME
NATIONAL CHARACTER VARYING(1)
NATIONAL CHARACTER VARYING(10)
NATIONAL CHARACTER VARYING(1024)
NATIONAL CHARACTER VARYING(16)
NATIONAL CHARACTER VARYING(16000)
NATIONAL CHARACTER VARYING(188)
NATIONAL CHARACTER VARYING(195)
NATIONAL CHARACTER VARYING(20)
NATIONAL CHARACTER VARYING(200)
NATIONAL CHARACTER VARYING(255)
NATIONAL CHARACTER VARYING(256)
NATIONAL CHARACTER VARYING(3)
NATIONAL CHARACTER VARYING(31)
NATIONAL CHARACTER VARYING(5)
NATIONAL CHARACTER VARYING(50)
NATIONAL CHARACTER VARYING(600)
NATIONAL CHARACTER VARYING(7)
NATIONAL CHARACTER VARYING(8)
NATIONAL CHARACTER VARYING(8192)
NUMERIC(1,0)
NUMERIC(10,0)
NUMERIC(10,2)
NUMERIC(10,3)
NUMERIC(10,4)
NUMERIC(11,0)
NUMERIC(12,0)
NUMERIC(12,2)
NUMERIC(12,3)
NUMERIC(12,8)
NUMERIC(13,3)
NUMERIC(14,0)
NUMERIC(15,0)
NUMERIC(16,15)
NUMERIC(17,2)
NUMERIC(18,0)
NUMERIC(18,1)
NUMERIC(18,10)
NUMERIC(18,2)
NUMERIC(18,3)
NUMERIC(18,4)
NUMERIC(18,5)
NUMERIC(18,6)
NUMERIC(2,0)
NUMERIC(2,1)
NUMERIC(20,0)
NUMERIC(20,10)
NUMERIC(20,8)
NUMERIC(25,24)
NUMERIC(28,0)
NUMERIC(28,2)
NUMERIC(3,0)
NUMERIC(3,1)
NUMERIC(34,6)
NUMERIC(38,0)
NUMERIC(38,10)
NUMERIC(38,2)
NUMERIC(38,20)
NUMERIC(38,4)
NUMERIC(38,6)
NUMERIC(38,8)
NUMERIC(4,0)
NUMERIC(5,0)
NUMERIC(5,2)
NUMERIC(6,2)
NUMERIC(7,2)
NUMERIC(7,3)
NUMERIC(8,0)
NUMERIC(8,2)
NUMERIC(9,3)
NUMERIC(9,4)
NUMERIC(9,6)
OID
OIDVECTOR
REAL
REGPROC
SMALLINT
TEXT
TIME
TIME WITH TIME ZONE
TIMESTAMP
share|improve this question
add comment

1 Answer 1

up vote 2 down vote accepted

I found this guide which is for Netezza version 5, so that should be close. Documentation for that system is rather difficult to find, or at least it doesn't readily show up on Google. For SQL Server 2008, the MSDN page is here.

ABSTIME --> ??
BIGINT --> bigint
BOOLEAN --> bit
BYTEA --> ?? tinyint?
BYTEINT --> smallint (tinyint is positive values only)
CHAR --> char(1)
CHARACTER VARYING(1..8000) --> varchar(1..8000)
CHARACTER VARYING(>8000) --> varchar(MAX)
CHARACTER(1..8000) --> char(1..8000)
DATE --> date
DOUBLE PRECISION --> double precision or float(53)
INT2VECTOR --> ??
INTEGER --> int
INTERVAL --> No equivalent
NAME --> ?? sysname?
NATIONAL CHARACTER VARYING(1..4000) --> nvarchar(1..4000)
NATIONAL CHARACTER VARYING(>4000) --> nvarchar(MAX)
NUMERIC(p,s) --> numeric(p,s)
OID --> ??
OIDVECTOR --> ??
REAL --> real
REGPROC --> ??
SMALLINT --> smallint
TEXT --> ?? Probably either varchar(MAX) or nvarchar(MAX)
TIME --> time(6)
TIME WITH TIME ZONE --> datetimeoffset(6)
TIMESTAMP --> datetime2(6)
share|improve this answer
    
I'll be testing these tomorrow and will let you know how it goes –  MacGyver Oct 18 '12 at 3:52
    
this worked perfectly! –  MacGyver Oct 18 '12 at 15:18
    
@MacGyver: Great! Glad to hear it. –  Jon Seigel Oct 18 '12 at 15:47
    
DOUBLE PRECISION is equivalent to float(15) - REAL is equivalent to float(6). –  cairnz Oct 27 '12 at 17:56
    
@cairnz: Yes, but that's Netezza's float data type, which has a different range of precision argument than SQL Server. –  Jon Seigel Oct 28 '12 at 14:37
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.