Subject MIGRATION TO INTERBASE
Author aman
Hi
We as a Project  are in the process of moving from existing MS SQL Server 6.5  on Windows NT to Interbase on lynux due to non existence of support of SQL Server on non windows  platform...and we are very much naive on Interbase.
 
the biggest concern is in terms of:-
(1)existing data migration
(2) existing partial schema migration
     including Stored Procedures
(3) not clear if the Stored Procedures created in Interbase can be called up directly by JDBC APIs( like ASP server objects directly allowing SP to be called )
(4) Any other issues related to migration
(5) Can we use multi sql to program for Interbase due to its portability across different databases?
 
An advise on this would be greatly helpful for this major Business decision. Also a Case Study would be highly appreciated.
 
Best Regards
Aman Jyot
Project Manager-Application Systems