>> Have you ever exported UniVerse database to RDBMS, say, MS SQL Server or >Oracle platform? > >If you are using MVDB's with nested data (i.e 2NF), you wont really be able >to export the data to MSSQL. This may be bad news, Joe, I have a client who is using UniData v5.2 but I don't know anything about that data structure. Any tool that comes with UniData might be able to give me some high level data schema view?
>However, Lastest version of Oracle supports Nested Relational Tables.. you >can probably use to this >architecture for the export.... Oracle won't be an option at least for now, way too expensive, maintenance etc. >Now the above scenario is only worth looking at, if your company is trying >to Migrate TO RDBMS (NOT For Daily/Simple Export) >IBM DB2 also supports some data types for this purpose. DB2 would be similar category to Oracle for now. > >U2 MV Databases (UniVerse and UniData) both have ODBC and JDBC Interfaces. I >have played around with JDBC and CFMX, >works pretty well... Except this is not very useful in the MV 2NF >Scenario. I have a tool that allows easy data access/view for RMDBS like MS SQL Server, I intend to import the UniData database into MS SQL Server first, then, take a good look at it. One of the goals is to 'consolidate' various data/databases that the company has, for a single view of data (at least read only initially). >SQL only works in the 1NF. There has been >some JDBC enhancements to bring back Nested Data in different tables... Or >Joins. This JDBC enhancement sounds encouraging. >> BTW, what's the main similarity and difference between UniData and >UniVerse, >Unidata and Universe are very similar in Architecture... i dont know of any >big Differences. Good to know. Thanks. Li, Chunshen (Don) > >Joe Eugene > > >----- Original Message ----- >From: "Chunshen (Don) Li" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Friday, September 05, 2003 3:44 PM >Subject: MVDB > > >> Have you ever exported UniVerse database to RDBMS, say, MS SQL Server or >Oracle platform? If so, did you use ODBC driver or ... and what's >experience? Thanks for sharing. >> BTW, what's the main similarity and difference between UniData and >UniVerse, forgive my laziness of not reading documentations. >> >> >Yes, we run UniVerse v.10. ??? >> > >> >Joe Eugene >> >----- Original Message ----- >> >From: "LI, Chunshen (Don)" <[EMAIL PROTECTED]> >> >To: "CF-Talk" <[EMAIL PROTECTED]> >> >Sent: Friday, September 05, 2003 11:57 AM >> >Subject: MVDB >> > >> > >> >> Hello, >> >> >> >> I'm wondering if anyone has ever worked on a >> >> Multi-valued Database system like UniData from ROI. >> >> >> >> Thanks. >> >> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
