> 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. However, Lastest version of Oracle supports Nested Relational Tables.. you can probably use to this architecture for the export.... 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. 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. SQL only works in the 1NF. There has been some JDBC enhancements to bring back Nested Data in different tables... Or Joins. > 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. 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
