April 4, 2011 at 7:38 am
I am really outside my realm on this on so please bare with me. I am not even sure if this belongs in this forum. I was looking for an database architect forum but did not see any.
My problem is this...
We have a lot of data that currently resides in an old IBM..now Rocket UniVerse Database (Multi Value database)
I am currently working on getting an ODBC connection to this database however I have never set up an ODBC connection before and don't know exactly what that will allow me to do in this regard.
1. Is there anyway I can convert this database to a SQL Server database (and would I have to manually build the architecture/table/relations if I were to do this or could this be done on the fly)
2. Is there anyway SQL server would be able to generate a database diagram for this database so I can see the relationships
3. Could I export all the data with the relationships in tact?
If I can't do any of the above what is the best approach to do this besides exporting each table and then mapping the fields to the new database and importing? I have a lot of data clean up to do before I can import this data into the new system.
Thanks!!
April 5, 2011 at 6:12 am
I am currently working on getting an ODBC connection to this database however I have never set up an ODBC connection before and don't know exactly what that will allow me to do in this regard.
You will need the UniVerse install CD. On it, you will find installers for the UV ODBC (UniODBC) driver.
1. Is there anyway I can convert this database to a SQL Server database (and would I have to manually build the architecture/table/relations if I were to do this or could this be done on the fly).
It is possible to build an ODBC schema over top the UniVerse tables and query it from SQL Server.
2. Is there anyway SQL server would be able to generate a database diagram for this database so I can see the relationships ).
No. You need to get into the UniVerse console and query the data structures using their native command syntax (very similar to T-SQL).
3. Could I export all the data with the relationships in tact? ).
It depends on how well the original database was designed. If they make extensive use of multi-values , you will have repeating groups - that's ok - just be aware. If they use sub-values - it will be very difficult. Most of the work involves mapping the UniVerse tables into an ODBC schema and testing - this work is done within the character based UniVerse environment. Check out I-descriptors - they will be your friend.
I suggest you join the U2-Users group mailing list There are lot of knowledgeable people over there who can help you and offer advice. There is pretty good documentation also on the Rocket site.
Good Luck!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply