Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!news.musoftware.de!wum.musoftware.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: "Wolfgang Riedmann" Newsgroups: comp.lang.clipper.visual-objects Subject: Re: Access MDB or Microsoft SQL Date: 7 Oct 2012 13:25:26 GMT Lines: 24 Message-ID: References: <5071261d$0$6819$5fc30a8@news.tiscali.it> X-Trace: individual.net X4F0dPLZ3wop9wN/l4HJIwZL5pvD5YaR80/74UsOUN+domsiA= Cancel-Lock: sha1:2gkZObdnUflMSBARpK7cvjQPQeo= User-Agent: XanaNews/1.18.1.6 Xref: csiph.com comp.lang.clipper.visual-objects:4227 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.