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

[Neven MacEwan]

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

-- 
Neven MacEwan (B.E. E&E)
Ph. 09 620 1356 Mob. 027 4749 062

New Address Details
===================
MWK Computer Systems
1 Taumata Rd
Sandringham
Auckland

Ph 620 1356
Fx 620 1336
-------------- next part --------------
A non-text attachment was scrubbed...
Name: neven.vcf
Type: text/x-vcard
Size: 164 bytes
Desc: not available
Url : http://ns3.123.co.nz/pipermail/delphi/attachments/20060529/4a0c17ca/neven.vcf