Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
faq:migration-toolkit:convert-database-objects-to-java [2019/07/19 10:29] darya.prikhodkina [Using Ispirer Migration Commander] |
— (current) | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== How to Сonvert SQL Database Objects to Java Using Ispirer Migration and Modernization Toolkit ====== | ||
| - | |||
| - | For certain migration directions | ||
| - | you may need to convert database objects into Java syntax. For this purpose we included a special set of options into our tools. | ||
| - | |||
| - | |||
| - | ===== Using Ispirer SQLWays Wizard ===== | ||
| - | |||
| - | To convert SQL Database Objects to Java, first of all in the tool you need to specify the same target database as the source one. For example, if you need to migrate from Oracle to Java, please select Oracle on the "Choose a Target Database" page: | ||
| - | |||
| - | {{:faq:migration-toolkit/ora_trg.png?800|}} | ||
| - | |||
| - | |||
| - | |||
| - | After that you need to select objects that should be converted to Java. On the next "Specify DDL and Data Options" page of Ispirer SQLWays Wizard, please set "Convert Business Logic" option to "Java", as shown below: | ||
| - | |||
| - | |||
| - | |||
| - | {{:faq:migration-toolkit/to_java.png?800|}} | ||
| - | |||
| - | |||
| - | ===== Using Ispirer Migration Studio ===== | ||
| - | |||
| - | In order to convert from Oracle to Java in Ispirer Migration Studio you need to specify the Source as Oracle and Target as Java as shown on the screenshot: | ||
| - | |||
| - | {{:faq:migration-toolkit/studio1.png?800|}} | ||
| - | |||
| - | After that you need to specify the Output Directory where converted results (Java file with converted procedure) will be placed. To specify this directory please click "Options" --> "Migration...", set "Output Directory" and click OK. | ||
| - | |||
| - | {{:faq:migration-toolkit/studio2.png?800|}} | ||
| - | |||
| - | When the output directory is set you can run the conversion. After the conversion process is finished, you will see the source code of the procedure in the target pane, while the converted results will be placed in the output directory. As you can see there is .java file with the same name as the procedure specified for the conversion: | ||
| - | |||
| - | {{:faq:migration-toolkit/studio3.png?800|}} | ||
| - | |||
| - | |||
| - | ===== Using Ispirer Migration Commander ===== | ||
| - | |||
| - | To convert from Oracle to Java in Ispirer Migration Commander you need to specify the Source as Oracle and Target as Java, choose a file for conversion and click "Run" button as shown on the screenshot: | ||
| - | |||
| - | {{:faq:migration-toolkit/commander1.png?800|}} | ||
| - | |||
| - | After that you need to specify the target folder using the "Convert to" option, where converted results (Java file with converted procedure) will be placed and click OK. | ||
| - | |||
| - | {{:faq:migration-toolkit/commander2.png?800|}} | ||
| - | |||
| - | After that Ispirer Migration Commander will generate the target folder and place the converted results there. As you can see on the screenshot below, there is .java file with the same name as the procedure specified for the conversion: | ||
| - | |||
| - | {{:faq:migration-toolkit/commander3.png?800|}} | ||
| - | \\ | ||
| - | |||
| - | \\ | ||
| - | |||
| - | |||
| - | If you have any additional questions, please contact our support team: **__[[[email protected]]]__** \\ | ||
| - | |||
| - | |||
| - | \\ | ||
| - | ---- | ||
| - | === More about Ispirer Systems === | ||
| - | [[https://www.ispirer.com|Ispirer Home Page]] | ||
| - | [[https://www.ispirer.com/products/database-migration|Database Migration]] | ||
| - | [[https://www.ispirer.com/application-conversion|Application Conversion]] | ||
| - | [[https://www.ispirer.com/download|Downloads]] | ||