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

[Paul McKenzie]

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


Neven MacEwan wrote:
> Paul
> 
> I haven't done this but you may be able to use xCase  (www.xcase.com) to 
> rev engineer your existing database and then set it up on SQL-Server 
> 2005. As for the 'best components' for SQL It would depend on how you 
> are using your existing db? Tables, queries, stored procs from your 
> statement "We know we will have to re-visit all the SQL for syntax and 
> probably for performance" in theory not but the devil is in the details
> 
> Are you using RI? is so how? The biggest issue is in the functions 
> /stored procs/trigger code ie the specific scripting code for the db
> 
> HTH
> Neven
> 
> 
> 
> 
> 
> Paul McKenzie wrote:
> 
>> We are considering migrating several Win32 (D7) 3-Tier apps from 
>> IBX/Interbase to SQL-Server 2005.
>>
>> The Apps all access the same large Database - The apps range from 
>> small to very large.
>>
>> What are the best components to use for SQL Server ?
>> What are the difficulties/gotchas in migrating ?
>> Any good links and/or best practices for migration ?
>> We know we will have to re-visit all the SQL for syntax and probably 
>> for performance.
>> Are there any issues, we would probably not see until the end, that we 
>> need to look out for ?
>>
>> Any Help much appreciated...
>>
>>
> 
> _______________________________________________
> Delphi mailing list
> Delphi at ns3.123.co.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi