Joe, SQL Server 2003 is not an option to us at this point. Thanks. Don
>> I would imagine that exporting the data to a Native XML Database would >> be one way to go since MVDB data can easily be represented by XML. > >Both UniVerse v10 and UniData v6(not sure) is "Supposed* to support creating >XML Docs >from the DB. I did some testing in UniVerse Enviroment with "TOXML" Syntax. >It didnt really work as per the docs. > >"select field1, field2, field3 from TableName TOXML; > >Was supposed to return an XML Doc...instead it returned a Query Object. > >Yes, if the XML is returned correctly from MVDB, i think SQL Server 2003 is >supposed >to support XML Data and XML Search/XPath functions. This might work. > >Joe Eugene > > >----- Original Message ----- >From: "Matt Liotta" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Monday, September 08, 2003 10:03 AM >Subject: Re: MVDB > > >> I would imagine that exporting the data to a Native XML Database would >> be one way to go since MVDB data can easily be represented by XML. >> Further, XML databases can be easy to work with from CF. >> >> -Matt >> >> On Monday, September 8, 2003, at 10:00 AM, Chunshen (Don) Li wrote: >> >> >>> 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm