Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

White Papers

Posted May 18, 2010

Database Migration from Informix to SQL Server 2008

By DatabaseJournal.com Staff

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.

View Article

White Papers Archives