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


Groups > comp.lang.clipper.visual-objects > #4225 > unrolled thread

Access MDB or Microsoft SQL

Started by"Perfect Solution Software" <infoNOSPAM1DELETE@magicorg.com>
First post2012-10-07 08:50 +0200
Last post2012-10-10 13:09 +0000
Articles 11 — 8 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  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

#4225 — Access MDB or Microsoft SQL

From"Perfect Solution Software" <infoNOSPAM1DELETE@magicorg.com>
Date2012-10-07 08:50 +0200
SubjectAccess 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]


#4226

FromSherlock <sherlock@sherlock.com.au>
Date2012-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]


#4227

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2012-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]


#4228

From"Gerhard Bunzel" <g.bunzel@domonet.de>
Date2012-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]


#4229

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2012-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]


#4234

FromMassimo Bighelli <info@arcasistemi.it>
Date2012-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]


#4255

FromMartin <spam@spam.spam>
Date2012-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]


#4240

FromWillie Moore <williem@wmconsulting.com>
Date2012-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]


#4244

From"Ginny Caughey" <gcaughey@online.hotmail.com>
Date2012-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]


#4254

FromMartin <spam@spam.spam>
Date2012-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]


#4258

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2012-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