🚀 go-pugleaf

On Fri, 27 Dec 2002 12:55:51 +0100, "Ing Giuseppe Monteleone"
<info@ing-monteleone.com> wrote:

>I'm a newbie to MSSQL. I have a good application that run to Access 2000
>throught ADO-Jet 4.0. Now I need to upsize to MSSQL, and i would like some
>suggestion.
>
>In theory i can change connection string and will adapt query to be
>compatible with MSSQL. Theare are other known iusses ?
>
>Thanks a lot for any suggestion
>
>Ing Giuseppe Monteleone
>

Hi Ing., 

    In theory it would suffice (apart some minor differences).  However, MSSQL
is a real RDBMS server, hence - revisiting your design - you could gain much
more efficiency, robustness and stability using some server-side stuffs like
triggers and stored procedures. Even, have a look at the Transact SQL, the
language you can use to build your own stored procedure. Using massively the
stored procedures could very simplify writing your BCB application, while you
gain both robustness and efficiency.

    Also, using a RDBMS, you have *real* control over transactions (respect to
JET-based databases which are controlled by several clients connected to a
file server over the network). Hence you can control with great precision the
isolation level that you need, in order to maximize the concurrency between
users of your application.

Ciao!

Giuliano