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

[Karl at Work]

Still FB.

Cheers,
Carl

> -----Original Message-----
> From: Paul McKenzie [mailto:paul at smss.org.nz]
> Sent: Sunday, May 28, 2006 9:22 PM
> To: karlreynolds at xtra.co.nz; NZ Borland Developers Group - Delphi List
> Subject: Re: [DUG] Migration from IBX to Interbase to SQL-Server 2005
> 
> 
> 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
> > 
> > 
> 
>