sql server to teradata datatype conversion

Third Party Software

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
Senior Apprentice

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)