Originally posted by: BNP

We will be migrating from DB2 to MS SQL and I was wondering if anyone has done this or can at least answer some questions I have.
1. We are WTX 8.1.114 an run our launchers from an AIX 5.3 server. Can we access an MS SQL server DB from AIX. is there something special that is needed?
2. Within our Maps Most reads and writes to the data base are done via a DBLOOKUP using DBTYPE DB2, I assume all I have to do is change the DBTYPE to DBTYPE SQLSVR7. And then make sure that the DB2 SQL syntax is correct for MS SQL.
3.Within our type trees we need to make sure that the DATA TYPE is correct in the new environment.

Also I am looking for an effort about how long this will take, I know all maps and trees are different, but if anyone can relay their effort with this it would be great.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

Yes. that is correct. Additionally you might have to change the other connectivity parameters like the credentials to log into the system apart from the DBTYPE
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: BNP

Thanks, Does anybody have a sample of coding a Select with the DBTYPE SQLSVR7 ? I would like to see the structure of one that works.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender