Subject | MSSQL/ADO to Firebird |
---|---|
Author | duncan84uk |
Post date | 2003-08-12T20:57:28Z |
Hello,
I have an Intranet application which runs on IIS/SQlserver - code
written in ASP/jscript so database calls are all ADO. I want to
disentangle myself from SQlserver but have masses of stored
procedures which limits my choice of Open Source DBs. I thought
Firebird looked like a good candidate, until I came across
documentation which suggests the ODBC driver is not too stable.
Any suggestions as to how I could handle database connectivity once I
migrate? Also, is there a best tool for stored procs migration, or
can I look forward to a long process of debugging?
Apologies if some of this is obvious,
Duncan
I have an Intranet application which runs on IIS/SQlserver - code
written in ASP/jscript so database calls are all ADO. I want to
disentangle myself from SQlserver but have masses of stored
procedures which limits my choice of Open Source DBs. I thought
Firebird looked like a good candidate, until I came across
documentation which suggests the ODBC driver is not too stable.
Any suggestions as to how I could handle database connectivity once I
migrate? Also, is there a best tool for stored procs migration, or
can I look forward to a long process of debugging?
Apologies if some of this is obvious,
Duncan