Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #4227

Re: Access MDB or Microsoft SQL

From "Wolfgang Riedmann" <wriedmann@gmail.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Access MDB or Microsoft SQL
Date 2012-10-07 13:25 +0000
Message-ID <adde66F1kq0U1@mid.individual.net> (permalink)
References <5071261d$0$6819$5fc30a8@news.tiscali.it>

Show all headers | View raw


Hi Paolo,

> I would like to migrate from DBF files to SQL.
> Do not know what to use. MDB or MSSQL?

please let alone MDB. DBFs are more stable as MDBs - MDBs will become
unstable near to 1 GB of total size.

Every SQL database is far more stable than MDB.

If you are in search of a good and affordable SQL database, you can use
MySQL, PostGres or Firebird.
If you can spend some money, Oracle can be an option: rock solid even
with large databases (several GBs), but demanding in hardware.

Or, if you have an installed base that you would migrate to DBF-like
database, ADS would be another option.

Only with MsSQL I'm not so happy. 

Wolfgang

P.S. most of my apps are using DBFs, but I'm also using ADS, MySQL, MS
SQL, MDB and Oracle regularly.

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

Access MDB or Microsoft SQL "Perfect Solution Software" <infoNOSPAM1DELETE@magicorg.com> - 2012-10-07 08:50 +0200
  Re: Access MDB or Microsoft SQL Sherlock <sherlock@sherlock.com.au> - 2012-10-07 00:07 -0700
  Re: Access MDB or Microsoft SQL "Wolfgang Riedmann" <wriedmann@gmail.com> - 2012-10-07 13:25 +0000
    Re: Access MDB or Microsoft SQL "Gerhard Bunzel" <g.bunzel@domonet.de> - 2012-10-07 23:04 +0200
      Re: Access MDB or Microsoft SQL "Wolfgang Riedmann" <wriedmann@gmail.com> - 2012-10-08 06:12 +0000
        Re: Access MDB or Microsoft SQL Massimo Bighelli <info@arcasistemi.it> - 2012-10-08 21:12 +0200
    Re: Access MDB or Microsoft SQL Martin <spam@spam.spam> - 2012-10-10 10:22 +0100
  Re: Access MDB or Microsoft SQL Willie Moore <williem@wmconsulting.com> - 2012-10-08 23:31 +0000
    Re: Access MDB or Microsoft SQL "Ginny Caughey" <gcaughey@online.hotmail.com> - 2012-10-09 08:46 -0400
  Re: Access MDB or Microsoft SQL Martin <spam@spam.spam> - 2012-10-10 10:19 +0100
    Re: Access MDB or Microsoft SQL "Wolfgang Riedmann" <wriedmann@gmail.com> - 2012-10-10 13:09 +0000

csiph-web