migrate universe of Informix to SQL Server

building semantic layer
1

I need some information about universe migration, specially from Informix to SQL Server

Thanks

Lili

Lili (BOB member since 2002-09-15)

2

What are you looking for? There are not utilities to do this.

You have to change the connection to a SQL Server one and then start parsing and repairing objects.

Fortunately, Informix has a very limited set of functions, so most of your objects will still work. Objects that do Date calculations will certainly need to be changed.

The bottom line is that you need to change the connection and then test each object manually.

Outer joins also need to be looked at. There have been lots of threads regarding how to do outer joins in SQL Server. Search for Outer and From and you should see what you need.

Steve Krandel :us: (BOB member since 2002-06-25)

3

If you have already created tables in SQL Server(the best way is to reverse enginner informix database using any Data modeling tool), then change the connection of the universe to new server and run check integrity.This will point you to the errors due to this change.That will be a good place to start with…If you need help with specific syntax, post your questions.

dcdas :us: (BOB member since 2002-06-17)

4

If you have the license for ERWIN data modeler tool, it will reduce your burden.

Cheers,
Arun.

nellaiarun :india: (BOB member since 2003-01-15)