We have a standard application that was made for SQL-server 7 and which we
recently made available for Oracle as well.
We ran into a few problems, but most were due to ODBC-driver-problems (The
customer was running CF 4.5.1 Pro, so native drivers was out of the
question)
>From my mind:
We had to change the insert-queries because Oracle doesn't make unique ID's
automatically, and there is also an issue on "ORDER BY" when doing UNION
selects.
Otherwise everything worked quite nicely.
I am perfectly pleased with SQL-server though, and as the administration of
SQL-server is easier than with Oracle I prefer development using SQL-server.
A lot of the stuff i could do easily and understandably using Enterprise
Manager in SQL Server, i have to call in the Oracle-guru to do now...
The SQL-server has performed very good as well and we see no reason to
transfer to Oracle.
rgds
* Holger Lockertsen, Solutions Developer, Horisont Information Systems AS
* Nedre Slottsgate 5, N-0157 OSLO, Noreg/Norway
* 23 31 03 04 / 91 83 20 51
* [EMAIL PROTECTED] http://www.horisont.no/
NB! Horisont har f�tt nye nummer, og mitt INTERNNUMMER er: 23 31 03 04
> -----Original Message-----
> From: Tom Nunamaker [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 21, 2000 1:19 PM
> To: [EMAIL PROTECTED]
> Subject: Oracle vs SQL server
>
>
> Hi everyone.
>
> We're using SQL server 7.0 and it's working great. The DoD recently
> purchases a site license
> for the entire DoD for Oracle. My question is should I move my
> SQL server
> DB to Oracle?
>
> I tend to say no just because everything is already working,
> including some
> stored procedures
> and triggers. Has anyone had to do this migration path?
>
> What are the Advantages of Oracle over SQL Server? I've read
> some great
> things about SQL
> server 2000 and wonder if any advantages Oracles has at the
> moment will be
> gone with SQL
> Server 2000 is released later this year.
>
> Any other thoughts?
>
> Thanks
>
> Tom Nunamaker, Maj, USAF
> USAFE AMOCC/SC
> Chief, Communications Branch
> Senior Web Developer
> Ramstein AB, Germany
>
>
> ------------------------------------------------------------------
> ------------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
