Thursday, July 17, 2014

Old Fashioned SQL scripts

The tools gdx2sqlserver has an option to generate SQL scripts to populate a SQL Server database from GAMS data. (It has many other ETL facilities including bulk operations for high performance). Sometimes old fashioned SQL scripts are useful: we can zip and email such a file and a database person can look at it and design SQL code for further processing.