sql server to teradata datatype conversion

Third Party Software
Not applicable

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

1 REPLY
Junior Contributor

Re: sql server to teradata datatype conversion

Hi Puneet,

geography: probably ST_GEOMETRY (before TD15 only 2 dimensional data)

http://www.info.teradata.com/templates/eSrchResults.cfm?prodline=&txtpid=&txtrelno=&txtttlkywrd=GEOT...

hierarchyid: doesn't exist

image: BLOB (BINARY LARGE OBEJCT, up to 2GB)