Database Migration from Informix to SQL Server 2008

Are you running your application against an Informix 11+
database?  Have you ever wondered what it would take to move your
database to SQL Server?   If so, now there is help with identifying the issues
associated with migrating from Informix to SQL Server 2008.

The migration process is not that hard.  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.   With SQL Server comes a tool known as SQL Server Integration Services,
more commonly called SSIS.  SSIS can be used to perform the actual migration of
the data from your legacy Informix database into a fresh SQL Server database.

In this white paper, all the issues are identified to
help jump start your migration planning.  After reading this paper, you will
have an excellent understanding not only of how to move your data, but also how
to transform your code, using SQL Server coding syntax and techniques.  If you
are just contemplating a migration of your Informix database to SQL Server, or
are in the middle of your migration planning, then you should make reading this
white paper a priority.  Make sure you  understand all of the issues to ensure your
migration goes as smooth as possible.

Latest Articles