views:

16

answers:

1

how can we migrate from u2 to sql server.tell me the sites where i can find the pdf on migration from u2

A: 

The Universe data model doesn't match SQL very well. This is likely to be a tough migration. THe first thing you need is some abstract model of your database; it is likely hiding in how the code accesses the data, and is pretty difficult to extract by hand.

With a data model, you have some hope of understanding how to map that data onto a relational model. Then you have to convert the code, changing every data access to match the new SQL model. You also have to convert the libraries and screen accesses.

Not a task for faint of heart.

How big is the application? The data?

Ira Baxter