#SQL Parser
SQL is not SQL! Nearly vendor has it's own little dialect. I had a lot of problems migrating from MS Access to SQL Server.
This tool reads a SQL-File parses it and writes a file in a specified SQL format.
gem install sql_parser
parsesql -i access -o sqlserver in.sql out.sql
This will do the work
Supported formats:
- MS Access (not done yet)
- Ms SQL Server
- Postgresql