Design patterns to ease migration of SQL code between vendors

Question

I am looking at ways which a developer can take advantage of implementation specific advanced features(T-SQL, PL-SQL etc) and at the same time makes it easy to migrate the ANSI compliant SQL code to a new database. By that I mean, how to efficiently abstract the ANSI compliant SQL code and move it across different databases?

Answer 1

I use the Mimer SQL-92 Validator:

Check Your SQL Against the SQL-92 Standard. Mimer SQL-92 Validator recognizes the standards Entry, Transitional, Intermediate and Full SQL-92, Persistent Stored Modules (PSM) SQL-99 and Database Triggers

Copy and poaste SQL text into the webpage and hit the 'Test SQL' button.

..though I'm not sure that is the kind of "efficient" process you are looking for, it may a some use.