Though I've not spent enough time and effort on Oracle DBMS I would agree Oracle has more capabilities than MS SQL Server. However, I would bet Oracle would be a big, heavy gorilla (so easy to spell it as guerilla for non-native tongue speakers :) vs. MS SQL Server, cost and management wise among others.
My client definitely would not go for Oracle at this point, as a matter of fact, they are still using Access for their substantial business.
I hope, as I get to know UniData (beast) a bit more in the next few days, this particular problem would flush itself out.
Regards,
Don
>Don,
>
>RedBack is a Business Object Server. You can write Business Objects/Rules in
>RedBack
>that talks to U2 Database. Basically, you can consider RedBack as an
>Advanced Level
>of SQL Server Stored Procedure Programming, a little object oriented...takes
>care of
>connection pooling and all that stuff. Well MS-SQL Server T-SQL is not all
>that great
>compared to capabilities of Oracle PL/SQL Or Java Procedure capabilities
>Joe Eugene
>
> -----Original Message-----
> From: Chunshen (Don) Li [mailto:[EMAIL PROTECTED]
> Sent: Monday, November 03, 2003 2:46 PM
> To: CF-Talk
> Subject: Re:Might be OT: MVDB -- UniData etc.
>
>
> Joe,
>
> My client uses UniData (Pick type of people say not much different from
>Unverse), they'd like to export their UniData data to SQL Server or the like
>for easy view etc. I've set up an ODBC connection to the UniData server,
>then used VSG (Visual Schema Generators) to map UniData mv data into
>relational data set, then DTS it to SQL Server. All works, almost beautiful
>except that, by default, VSG makes all columns nullable. Well, in my data
>transformation process, I can take care of that, but I thought it would be a
>better way/more efficient way to be able to configure column nullability
>from VSG, it looks like it can't but that's OK.
>
> Thanks though. BTW, what does RedBack do? schema translation?
>
> Regards,
>
> Don Li
>
> >We run U2(Universe) MVDB. I dont understand your question though.
> >Our Configurations are (U2 + RedBack + CF5.0 and U2 + JDBC + CFMX)
> >
> >What are you trying to accomplish?
> >
> >Joe Eugene
>
> >----- Original Message -----
>
> >From: Chunshen (Don) Li
>
> >To: CF-Talk
>
> >Sent: Sunday, November 02, 2003 5:24 PM
>
> >Subject: Might be OT: MVDB -- UniData etc.
> >
> >
>
> >Hi,
> >
>
> >I hope this is not OT since it is really another type of database that
> >required CF as a middleperson. Something weird. I couldn't find two
> >postings and others' followups on this subject posted a few weeks ago.
> >Try do a key word search of "MVDB" or "UniData", it won't find
> >anything while my previous postings has included them in the subject
> >line.
> >
>
> >Related question for those who followed up on the topic, I'd
> >appreciate your thought/input. VSG v3.1, for any view created, each
> >column is set to NULLABLE, well, my requirement is such that I want
> >the [ID] column to be NONNULLABLE or NULLABLE value set to N | 0.
> >This version of VSG does not seem to have the feature of resetting
> >NULLABLE value. Is this understanding correct?
> >
>
> >If so, how could I achieve the same thing from UDT? VOC file? Help
> >me to beat this "beast" :)
> >
>
> >Thanks.
> >
>
> >Don Li
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
