Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #4225 > unrolled thread
| Started by | "Perfect Solution Software" <infoNOSPAM1DELETE@magicorg.com> |
|---|---|
| First post | 2012-10-07 08:50 +0200 |
| Last post | 2012-10-10 13:09 +0000 |
| Articles | 11 — 8 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
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
| From | "Perfect Solution Software" <infoNOSPAM1DELETE@magicorg.com> |
|---|---|
| Date | 2012-10-07 08:50 +0200 |
| Subject | Access MDB or Microsoft SQL |
| Message-ID | <5071261d$0$6819$5fc30a8@news.tiscali.it> |
I would like to migrate from DBF files to SQL. Do not know what to use. MDB or MSSQL? From what I read on internet it seems that MDB is not very reliable. On the other side in order to use MSSQL you have to install the MSSQL SERVER. MDBs are far more simple and much similar to DBF. Is MDB really so prone to corruption in a let's say 5 PC LAN? Would like to hear your opinion, thanks Paolo Kalc
[toc] | [next] | [standalone]
| From | Sherlock <sherlock@sherlock.com.au> |
|---|---|
| Date | 2012-10-07 00:07 -0700 |
| Message-ID | <72bb5dde-818f-4eba-88e8-be38a8b36417@googlegroups.com> |
| In reply to | #4225 |
Paulo We moved everything to POSTGRES.. This gives you a Cloud solution as well. Our 3 main products will all me cloud solutions for end of 2013. It is do it or die.. as the competition and clients want access for clients online or Phone/Tablet to diaries and data. It is a trend that is going to stop. Not for everybody but for those competiting in commercial markets it is something that cannot be ignored. Phil
[toc] | [prev] | [next] | [standalone]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2012-10-07 13:25 +0000 |
| Message-ID | <adde66F1kq0U1@mid.individual.net> |
| In reply to | #4225 |
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.
[toc] | [prev] | [next] | [standalone]
| From | "Gerhard Bunzel" <g.bunzel@domonet.de> |
|---|---|
| Date | 2012-10-07 23:04 +0200 |
| Message-ID | <k4sqmv$aii$1@news.m-online.net> |
| In reply to | #4227 |
Hi Wolfgang, I also have to migrate from DBF to SQL and will do that with VO2ADO and MsSQL. > Only with MsSQL I'm not so happy. What problems do you have with MsSQL? Thanks in advance. Best regards Gerhard "Wolfgang Riedmann" <wriedmann@gmail.com> schrieb im Newsbeitrag news:adde66F1kq0U1@mid.individual.net... > 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.
[toc] | [prev] | [next] | [standalone]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2012-10-08 06:12 +0000 |
| Message-ID | <adf95gFek25U1@mid.individual.net> |
| In reply to | #4228 |
Hi Gerhard, > I also have to migrate from DBF to SQL and will do that with VO2ADO > and MsSQL. > > > Only with MsSQL I'm not so happy. > What problems do you have with MsSQL? compared with other SQL databases it is not so stable, and several times I had strange problems with the database itself that were only cured after a restart of the server. But I compare MsSQL here with Oracle and ADS - both really stable (in about 10 years of working with the Oracle database I had not one problem cuased by the database itself, working first with Oracle 9i and then with 11g, both on Linux servers). Wolfgang
[toc] | [prev] | [next] | [standalone]
| From | Massimo Bighelli <info@arcasistemi.it> |
|---|---|
| Date | 2012-10-08 21:12 +0200 |
| Message-ID | <k4v8ij$knl$1@speranza.aioe.org> |
| In reply to | #4229 |
Hi Wolfgang different experience here. MSSQL server AND Oracle are the best servers I ever used. I found MSSQLserver2008 stable and reliable, the Express edition (free) too, with the limits of express, obvious. 4 years with 12 DB running (used by a bounch of apps from different developers) without a stop. my2c Regards Massimo Il 08/10/2012 08:12, Wolfgang Riedmann ha scritto: > Hi Gerhard, > >> I also have to migrate from DBF to SQL and will do that with VO2ADO >> and MsSQL. >> >>> Only with MsSQL I'm not so happy. >> What problems do you have with MsSQL? > > compared with other SQL databases it is not so stable, and several > times I had strange problems with the database itself that were only > cured after a restart of the server. > But I compare MsSQL here with Oracle and ADS - both really stable (in > about 10 years of working with the Oracle database I had not one > problem cuased by the database itself, working first with Oracle 9i and > then with 11g, both on Linux servers). > > Wolfgang >
[toc] | [prev] | [next] | [standalone]
| From | Martin <spam@spam.spam> |
|---|---|
| Date | 2012-10-10 10:22 +0100 |
| Message-ID | <_6bds.345479$uJ4.271831@fx18.am4> |
| In reply to | #4227 |
We use ADS exclusively 98% ISAM access with SOME SQL usage On 07/10/2012 14:25, Wolfgang Riedmann wrote: > 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. >
[toc] | [prev] | [next] | [standalone]
| From | Willie Moore <williem@wmconsulting.com> |
|---|---|
| Date | 2012-10-08 23:31 +0000 |
| Message-ID | <1832232158371431682.640937williem-wmconsulting.com@news.aioe.org> |
| In reply to | #4225 |
Hey, I have used both Mdb and SQL in my VO and Vulcan apps. I use vo2ado for both and write fairly generic SQL code so it can be used by either. Have a look at SQL 2012. It has a local install that is much easier to administer. Regards, Willie Vulcan VIP "Perfect Solution Software" <infoNOSPAM1DELETE@magicorg.com> wrote: > I would like to migrate from DBF files to SQL. > Do not know what to use. MDB or MSSQL? > From what I read on internet it seems that MDB is not very reliable. > On the other side in order to use MSSQL you have to install the MSSQL > SERVER. > MDBs are far more simple and much similar to DBF. > Is MDB really so prone to corruption in a let's say 5 PC LAN? > Would like to hear your opinion, thanks > > Paolo Kalc
[toc] | [prev] | [next] | [standalone]
| From | "Ginny Caughey" <gcaughey@online.hotmail.com> |
|---|---|
| Date | 2012-10-09 08:46 -0400 |
| Message-ID | <50741c94$0$45809$c3e8da3$a9097924@news.astraweb.com> |
| In reply to | #4240 |
Hi Willie, Agreed. SQL Server in all the versions I and my clients have tried have been EXTREMELY stable, and the installer just gets better with each release. I can honestly say that without VO2Ado I would have been forced to completely abandon VO years ago. Thanks, Robert! Ginny "Willie Moore" wrote in message news:1832232158371431682.640937williem-wmconsulting.com@news.aioe.org... Hey, I have used both Mdb and SQL in my VO and Vulcan apps. I use vo2ado for both and write fairly generic SQL code so it can be used by either. Have a look at SQL 2012. It has a local install that is much easier to administer. Regards, Willie Vulcan VIP "Perfect Solution Software" <infoNOSPAM1DELETE@magicorg.com> wrote: > I would like to migrate from DBF files to SQL. > Do not know what to use. MDB or MSSQL? > From what I read on internet it seems that MDB is not very reliable. > On the other side in order to use MSSQL you have to install the MSSQL > SERVER. > MDBs are far more simple and much similar to DBF. > Is MDB really so prone to corruption in a let's say 5 PC LAN? > Would like to hear your opinion, thanks > > Paolo Kalc
[toc] | [prev] | [next] | [standalone]
| From | Martin <spam@spam.spam> |
|---|---|
| Date | 2012-10-10 10:19 +0100 |
| Message-ID | <Q4bds.345478$uJ4.171625@fx18.am4> |
| In reply to | #4225 |
One answer ADVANTAGE DATABASE SERVER On 07/10/2012 07:50, Perfect Solution Software wrote: > I would like to migrate from DBF files to SQL. > Do not know what to use. MDB or MSSQL? > From what I read on internet it seems that MDB is not very reliable. > On the other side in order to use MSSQL you have to install the MSSQL > SERVER. > MDBs are far more simple and much similar to DBF. > Is MDB really so prone to corruption in a let's say 5 PC LAN? > Would like to hear your opinion, thanks > > Paolo Kalc > >
[toc] | [prev] | [next] | [standalone]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2012-10-10 13:09 +0000 |
| Message-ID | <adlac8Fe89gU1@mid.individual.net> |
| In reply to | #4254 |
Hi Martin, > One answer > > ADVANTAGE DATABASE SERVER for an existent application: I agree 100% IMHO only for a complete new development SQL may be a choice. Wolfgang
[toc] | [prev] | [standalone]
Back to top | Article view | comp.lang.clipper.visual-objects
csiph-web