Informix to Sql server 2008 migration

Question

Hello Experts,  I'm try to migrate data from Informix to Sql server 2008. Are there any tools which would help me script out the tables/views etc. I use server studio to generate the table creation/views scripts for me. I need to convert these scripts to as format that sql server understand. i have close to 400 + tables/views to migrate.  Also, I did try to manually create a table after reading the documents available online( http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=c7933d3e-b7b9-43a6-ade3-f8e37c8cb046(MigrateInformixtoSQLServer2008.docx) )   . I have been having problems with the scripts below.  **alter table caa**** add constraint primary key  (coa01, coa72) constraint u753_3106; How do create this constraint in sql server. ** create table caa**** ( startdatetime DATETIME YEAR TO FRACTION(4) default CURRENT YEAR TO FRACTION(4)); What is the Sql server equivalent of the above scripts. Please advise. Thanks Leo

Answer 1

Hi Leo,

I think there’s no such tool available from Microsoft, maybe you could get some third-party tools to achieve.

And it’s a good way to follow the document which you mentioned to migrate Informix to SQL Server.

Please try the below code:

Alter table caa
Add constraint u753_3106 primary key (coa01, coa72)
Go
Create table caa (startdatetime datetime2(4) default (getdate()))
Go

Best Regards,
Ray Chen

Answer 2

There is a tool available called SQLWays from a company called ispirer - it is licensed on a per-project basis I believe.

They also assist in migrations and modifications to the tool.

I'm not affiliated or associated with the company, but have downloaded and used a trial of their product.