All Forums Third Party Software
puneetkhanduja 1 post Joined 01/15
15 Jan 2015
sql server to teradata datatype conversion

Can some please throw some light on sql server to teradata datatype conversion.
We have a requirement to convert Sql server tables to Teradata but for certain 
datatypes like geography ,hierarchyid, image in sql server , we are not able to map them in teradata.
 
If possible, please provide some link or doc where datatype conversion from sql server to teradata is available.
 
Thanks,
Puneet

dnoeth 4628 posts Joined 11/04
15 Jan 2015

Hi Puneet,
geography: probably ST_GEOMETRY (before TD15 only 2 dimensional data)
http://www.info.teradata.com/templates/eSrchResults.cfm?prodline=&txtpid=&txtrelno=&txtttlkywrd=GEOTYPE&rdsort=Title&srtord=Asc&nm=Geospatial+Types
 
hierarchyid: doesn't exist
 
image: BLOB (BINARY LARGE OBEJCT, up to 2GB)
 

Dieter

You must sign in to leave a comment.