[DUG] Migration from IBX to Interbase to SQL-Server 2005

[Karl at Work]

I migrated from IBX to DBExpress with nary a hitch.  They're similar in the
extent that their core datasets are unidirectional.  It is easier when
you're already using ClientDataSets.  Can't speak for ADO.

Whichever way you go, the IB optimisation issues will still be there.  It
helps to know that FB/IB handles composite indices very badly: if you're
having trouble with the engine not choosing your composite index in plans
when it ought to, try replacing the offending index with a bunch of
single-column indices instead.  Seems to work more often than not.  Beats
having to write your own plans.

Cheers,
Carl

> -----Original Message-----
> From: delphi-bounces at ns3.123.co.nz
> [mailto:delphi-bounces at ns3.123.co.nz]On Behalf Of Paul McKenzie
> Sent: Sunday, May 28, 2006 7:37 PM
> To: NZ Borland Developers Group - Delphi List
> Subject: Re: [DUG] Migration from IBX to Interbase to SQL-Server 2005
>
>
> The Conversion from InterBase to SQL-Server is not the
> problem. We have tools and experts to do that.
> The issue we have is that we need to migrate our 3-Tier App
> from IBX components to DBExpress or
> ADOExpress - We are investigating which is best...
> The appear to be fairly equal!
> I was wondering if anyone had done the conversion (or similar
> investigation) and found it easy to go
> to one but not the other. Or found one cannot do something vital etc.
> One big issue is that we would like to migrate to SQL-Server
> 2005 and will probable move to D2006
> for this but are having to investigate this as well.
>
> One big issue we had (this is very legacy code) is that the
> IB optimiser was killing our SQL in many
> heavy-duty frequently used cases... we had to re-write our
> SQL just to force InterBase to not
> optimise and thus run much faster (in most cases speed
> reduced from many minutes to a few seconds)
>
> Everything I have read so far (ok 0.5 a day) indicates that
> DBExpress vs ADOExpress is just preference!
>
> Hoping someone has had experience...
>
> The only indicator is from the Newsgroup "SQL Servers - May
> 2006" Bill Todd (TeamB) recommends ADO
> over DBExpress for Win32!
>
> Regards
> Paul McKenzie
> Wellington
> New Zealand