In this IBM® Redbooks® publication  we discuss considerations  and describe a methodology  for transitioning from Microsoft® SQL Server 2008 to the Informix® Dynamic Server We focus on the topic areas of data  applications  and administration  providing information about the differences in features and functionality  including the data types  data manipulation language  data definition language  and stored procedures