Hi amituofo,
When migrating Informix database to SQL Server database, you need start with mapping out your migration. This mapping process requires you to determine how your Informix database will map to SQL Server databases and schemas, you also need to map your
Informix data types to the appropriate SQL Server data types.
After successful database conversion, you can migrate data from the Informix database to the SQL Server database by using
SQL Server Integration Services (SSIS). For more details about the migration process, please review the similar whitepaper:
Guide to Migrating from Informix to SQL Server 2008 .
In addition, you can consider using third-party tool such as
SQLines to implement migration form Informix to SQL Server. However, please note that Microsoft cannot make any representations regarding the quality, safety, or suitability of the third party tools.
Thanks,
Lydia