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

[Paul McKenzie]

Thanks - did you go to SQL-Server after moving to DBExpress or are you still using FB/IB ?

Regards
Paul McKenzie
Wellington
New Zealand


Karl @ Work wrote:
> 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
> 
> 
> _______________________________________________
> Delphi mailing list
> Delphi at ns3.123.co.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi
> 
>