SQL: Sql2gms

Data may be transferred to SQL compatible databases using Sql2gms - a utility developed by  GAMS Development Corporation.  Sql2gms extracts data from any SQL relational database via use of the Windows ADO or ActiveX Data Objects procedures. In turn it converts the results into a GAMS include file.  Sql2gms is resident in GAMS  and documented through http://www.gams.com/dd/docs/tools/sql2gms.pdf.  Its function is similar to the Mdb2gms procedure discussed above but with a more complex syntax that also identifies the database manager to use.