Need Some Help

This is my favorite kind of thing. Some dufus proposing a complete change
from something that works. (And for the sake of argument, if you had come
in the other direction and asked how to suggest that SQL Server should
replace a perfectly good working system I would say the same thing.) Just
because you have next to no knowledge of Oracle, this is a good argument for
staying just where you are. So take the stance of making this person give a
real reason for the change, not some magical improvement.
As for Oracle Forms, can it be used to build an interface to SQL Server?
Doubt it, but VB can go against either. I know you have the problem that
VB6 is dead, but is there some problem with VB.NET? Is it just one person?
And is this person "charismatic," the most deadly of all personality traits
to have to argue against.
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)
"Si" <anonymous@.devdex.com> wrote in message
news:%23dz5m06GGHA.524@.TK2MSFTNGP09.phx.gbl...
> Hi
> I know this is off-topic, but I'm looking for some
> knowledgeable people...
> The company where I work have an application which
> uses VB6 for the front end and SQL Server for the
> back end. The front end uses the (published) stored
> procedure API to access the database. The business
> logic is implemented in the stored procedures.
> IMHO it works well allowing business logic changes/bug
> fixes to be rolled out relatively easily without
> changing the user interface. However, it has been
> proposed to ditch everything in favour of an Oracle
> Forms front end connected to an Oracle database back end,
> this will improve performance and reliability according
> to our Oracle "Guru". The Oracle "Guru" doesn't want
> to use stored procedures and instead favours putting
> explicit SQL inside the forms. Unfortunately I know
> next to nothing about Oracle Forms so it's difficult
> to argue against it (knowledge is power!).
> When I challenged him about using stored procedures,
> he told me there was simply no point with Oracle Forms.
> Has anyone out there have experience of Oracle in
> comparison to SQL Server, especially when using
> a Forms front end. Will one perform any better than
> the other?
> TIA
>
> *** Sent via Developersdex http://www.examnotes.net ***"Louis Davidson" <dr_dontspamme_sql@.hotmail.com> wrote in message
news:OkLwSr8GGHA.2696@.TK2MSFTNGP14.phx.gbl...
> This is my favorite kind of thing. Some dufus proposing a complete change
> from something that works.
Dufus?In sql?
Tell me it ain't so!
:)|||No matter what the topic you feel strongly about, as many of us here feel
about SQL, or even favorite products, sports teams, etc. there is always
some person who takes things to an extreme that makes wonder (if for just a
moment) if this guy feels this way...then am I sure I am right?
I love SQL Server as much as the next guy (and probably more!) but it is
just a database server product, if a darn good one. Oracle (from what my
zealot friends have told me) is a fine product as well. I think SQL Server
is probably the hands down winner most new systems (cause I am a zealot
to!), but if a shop had already purchased Oracle and had 90% Oracle
developers, not sure that telling them to change to SQL is the best thing.
But with some study and creative use of Excel one might build a case. But
not just for SQL's sake, as I don't think it is a religious type debate
(which a dufus might (or someone who stood to make a kickback or
something!))
--
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)
"Pike" <noname@.noname.com> wrote in message
news:urJS7n%23GGHA.1032@.TK2MSFTNGP15.phx.gbl...
> "Louis Davidson" <dr_dontspamme_sql@.hotmail.com> wrote in message
> news:OkLwSr8GGHA.2696@.TK2MSFTNGP14.phx.gbl...
> Dufus?In sql?
> Tell me it ain't so!
>
>
> :)
>sql