Re: BDE vs ADO

From: Bruce (exnihilo_nospam_sys_at_hotmail.com)
Date: 07/14/04 

Date: 14 Jul 2004 09:09:43 -0700

You know more about the specs than I do, of course, but I'd strongly
suggest you consider SQL server for many reasons. We had the same decision
to make (over Oracle) a few years back and wisely chose SQL Server. Oracle
is very costly in more ways than one (upfront, admin costs, etc.)

Bruce

> thanks bruce, actually its not abt cost, we are in a transition stage and
> currently we have to make changes from access 97 to access 2k and in
> later half of the year we have to decide whether to chooose oracle, sql
> or anyother database.
> regards,
> rohit
>
> Bruce wrote:
>
> > If you are worried about cost, you might want to check out SQL Server
> > 2005 Express. It's in beta, but they've done a lot of work to improve
> > it over MSDE. It's also free.
> >
> > Bruce

Relevant Pages

  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... were pretty consistent no matter how big the table (this transaction ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... Oracle provides read consistency and SQL Server ...
    (comp.databases.oracle.misc)
  • Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
    ... "Writers block readers and readers block writers in SQLServer. ... getting around this fundamental issue and because of it SQL Server ... admitted they can happen in Oracle, I guess Oracle should never been used ... isolation level but you will always disagree because you follow doctorine ...
    (comp.databases.oracle.server)
  • Re: BDE vs ADO
    ... Bruce wrote: ... > to make (over Oracle) a few years back and wisely chose SQL Server. ... > is very costly in more ways than one (upfront, admin costs, etc.) ...
    (borland.public.delphi.database.ado)
  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... If it was the update statement that references ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... There are however differences how both products deal with concurrency; in Oracle readers don't get blocked while this may happen in SQL Server. ...
    (comp.databases.oracle.misc)
  • Re: Import problems on Windows Server
    ... XP is fine, so is Vista, like you I use them day in day out, around 12 hours ... a day myself too - laptops and the desktop i'm writing this on. ... I use SQL Server on XP and Vista for writing and demo'ing stuff, ... those are the same problems in the Oracle world. ...
    (comp.databases.oracle.server)