I would like to know if anyone out in the industry has had experiance in migrating from Interbase to MS Sql Server.
Migrating the tables & data is not a big concern, but triggers & stored procs will not be so easy.
Any advice?
+1
A:
I have had alot of experience in data migrations from Interbase to SQL Server. At my last job I created a replication scenario to do one way replication from Interbase to SQL server. Here is some advice if your trying to move the data do not use the DataDriect ODBC driver or Easysoft ODBC drive dont. These drivers do not handle blob fields very well. I would suggest using IBProvider v2. IBProvider v2 is an OLE DB Provider for Interbase/Firebird database and is much quicker. Note its a little harder to configure but in the end the speed is nice and its functionality is far better than the ODBC Drivers.
John Hartsock
2010-02-13 14:15:53
Thanks for the advice! And in terms of programming your sql server db? Our system is very reliant on stored procs and triggers, this is what scares me about the move.
Crudler
2010-02-15 06:51:54
Our systems was the same, very dependent on stored procedures and triggers. But using the linked server will allow you to leverage the procedures and triggers a little bit.
John Hartsock
2010-02-18 16:58:11