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

[Paul McKenzie]

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...


-- 
Regards
Paul McKenzie
Wellington
New Zealand