Question ID : 168
Created on 2011-03-25 at 12:10 PM
Author : Veryant Support [support@veryant.com]
Online URL : http://support.veryant.com/support/phpkb/question.php?ID=168
The answer is yes.
isCOBOL provides a utility named ISMIGRATE which can migrate data between supported ISAM indexed file systems and relational databases. Veryant supports access to Vision files through an interface which uses a licensed copy of ACUCOBOL-GT. And the Database Bridge (Veryant's ESQL Generator product) supports all databases which supply an ODBC or JDBC driver including but not limited to MS-SQL, PostgreSQL, MySQL, Oracle, and DB2.
So as long as you have licensed copies of ACUCOBOL-GT, isCOBOL and Database Bridge, you can migrate between Vision and MS-SQL or PostgreSQL.
Note that the data will appear in the database using a similar naming and formatting to that specified in the file's FD. This naming and formatting can be adjusted through EFD directives (or Acu4GL XFD directives) inserted into the FD as comments. For more information, see the EFD directives, and Database Bridge documentation in the isCOBOL documentation set.