Title: Does isCOBOL have a utility to migrate Vision files to MS-SQL and PostgreSQL ?

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.

Authored by: Veryant Support on Fri, Mar 25th, 2011 at 7:00 PM
This question has been viewed 8662 times so far.
Online URL: http://support.veryant.com/support/phpkb/question.php?ID=168

Powered by PHPKB Knowledge Base Software