Transcript Document
Project Files2Sql Cobol Files to SQL Databases About Files2Sql • Files2sql is a unique software program that can migrate Cobol Files (Index, Relative, Sequential) and record to Databases (SQL-Server, MS-Access, Oracle, DB2, Sybase, MySql, Informix) in minutes.. • Connect and test databases • Fast real-time migration in 5 easy steps • Minimal performance impact the system • Windows GUI interface • All developed under Microfocus Cobol (nothing other languajes) • Files2sql.exe are Builded under Microfocos Cobol 5.x (Static Build) • You can generate source, compile and run, for your Cobol Instaled • SKIP and CONTINUE Insert (COMMIT records OK) • Log with Records with Errors, Key Error, Alternate-Key Error • Change Datatype (Cobol type X DataBase DataType) • Run Option Migrate by Batch/Lote, to reduce time operation. About Files2Sql ... • Convert Cobol Files to SQL Database Read native Cobol files and import to database, currently available: Microfocus Cobol to: Acucobol to: · MS-Access · MS-Access · Sql-Server · Sql-Server · Oracle · MySql · DB2 · Sybase · Informix · In the future, more Cobol dialects and more databases are available for conversion of data. Tutorial Files2Sql • In this Tutorial you know: - To Download To Install and Run How to Use Login Data Base Tables Import To Migrate Setup Verify DB to DB - User Manual | F1 Adicional Informations Files2Sql = To Download • Download the tool, the latest release from the page • http://www.cobol.com.ar/Files2sql/downloads.html • * Trial / Beta / Commercial – versions, depending on register Files2Sql = To Install and Run • • - Execute the downloaded file, - Descompress in the path if you want, example C:\FILES2SQL\ … • • Warning: - If you a have old version of Files2Sql, you need to do backup of the folder \DIC. Yf you don’t do this backup, you will lost informations about tab “To Migrate” field “Select table”. • - * Run Files2Sql.exe in the folder descompressed. • * You need NetExpress, 5.1 or other version installed. Files2Sql = How to Use | Login If you dont´t have a Licence Key, click ‘Get (From Internet)’. Files2Sql = How to Use | Data Base - Select Use this screen to select data base, connect (many options) and disconnect. Files2Sql = How to Use | Data Base - Connection Use this screen to select data base, connect (many options) and disconnect. Files2Sql = How to Use | Tables Use this screen to view informations about tables and columns of the data base. Files2Sql = How to Use | Import Use this screen to information about yours Files Cobol, select, fds, rec structures and tests. Change Datatype (Cobol type X DB DataType) Files2Sql = How to Use | Import = “Compile and Run” After you “Compile and Run”, Files2Sql show details about your Cobol File. Files2Sql = How to Use | Import DATATYPE In this Windows, change Datatype imported and default by Cobol Types. Files2Sql = How to Use | To Migrate In this screen you select the imported structurs of file Cobol (Step Before), and generate source, compile and run convertion of Cobol files to data base. Files2Sql = How to Use | To Migrate - Results In this screen you view results about your migrate cobol files to database. Files2Sql = How to Use | To Migrate By Batch/Lote In This Window, select many options cobol files to migrate in automatic sequence. Files2Sql = How to Use | Setup In this screen do you know to configure and test your Cobol instaled in PC (Cobol Files Origim Base). Files2Sql = How to Use | Verify In this screen you can verify and set values of the Cobol environments Files2Sql = How to Use | DB to DB In this screen, you want convert migrate databases to databases. Files2Sql = How to Use | User Manual | F1 • Files2Sql F1 • In Screens, press F1 to view HELP informations. • Files2Sql User Manual • User Manual Document, is a easy Help content informations about all field of the Screens. • Informations Of Options Disables • This software will are a many functions, so existing options disables that will be created and enabled. Files2Sql = How to Use | Adicional Informations • • • • • • • • • • Contact: Arq. Agustin Zabala [email protected] [email protected] http://www.COBOL.com.ar http://www.cobol.com.ar/Files2sql/ Buenos Aires - Argentina Telefono: 0054 11 4735-1222 Celular (movil) 011 - 15-5413-1943 From other countries: 0054-9-11-5413-1943