Skip to Content.
Sympa Menu

freetds - Re: SQL Server Emulation

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Geoff Winkless" <geoff AT farmline.com>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: SQL Server Emulation
  • Date: Wed, 20 Jun 2001 16:26:48 +0100


"Lowden, James K" <LowdenJK AT bernstein.com> wrote:
: Of course, if you build a layer in your system and call it a "middle tier"
: that provides data services to the application and speaks SQL to the
server,
: you can say your application is portable. But that "middle tier" just
: isn't, stored procedures or no.

What??? A true "middle tier" means that neither side cares (or knows!) about
the structures or communications layer used by the other side. As such, if
you change the database, the majority of the code will not need to be
changed, merely the middle tier.

A well written middle tier should be reasonably portable. A middle tier that
relies on implementation-specific SQL will (of course) present the same
problems.

Geoff





Archive powered by MHonArc 2.6.24.

Top of Page