All you have to do is sit and wait. If you have any questions or suggestions, please feel free to contact us. Download Now » email facebook twitter linkedin tumblr print. Oracle 11g or higher. MS Access 97 or higher. Introduction: 1. In "Choose a Data Source" dialog, choose "Oracle"; Input the server name default: localhost and port default. Input the username default is "system" and its password. Input the schema name or let it empty default is same as username, you can press "Refresh" button to list all schemas.
MDB or. ACCDB file. If there is a workgroup system database , press "Lock" button to set it. Click " If you know a relationship exists between two tables, you should create a foreign key. UI Defaults - Indicates if user interface defaults are set for the table. User interface defaults are used by Oracle Application Express to populate initial values for region and item properties.
Using user interface defaults provides consistency across multiple applications or across multiple pages in an application. The Table Dictionary page appears. Note that you are now working within SQL Workshop. SQL Workshop is a component of Oracle Application Express with utilities to load and unload data from an Oracle database, generate DDL, view object reports, and restore dropped database objects.
The Table and Column Properties page appears, listing column information as it will appear in forms and reports. The Column Defaults page appears. You can update the column label, change the sequence of how the columns appear by default, and so on. Next, review the queries retrieved from the Microsoft Access export. Application Migration identifies invalid queries and those without user interface defaults, which you can set before migration. After you update the views, select the ones you want to include in the migration.
If you do not include a query, any forms or reports based on the query are excluded from the migration. Oracle View - Indicates the corresponding Oracle view, which defaults to the Microsoft Access query name in all capital letters. If the Microsoft Access object was not successfully migrated to Oracle, then this field will not have a corresponding Oracle view name. Instead, it will contain a link to a page where you can create a corresponding Oracle view.
Status - Query status is either Valid or Invalid. To run a bulk process that attempts to compile all invalid queries, click Attempt to compile invalid queries.
Using this option can validate some queries that show a status of invalid when initially migrated. The Oracle View appears. The editor is populated with the syntax of the original Microsoft Access query. You may need to edit the syntax to ensure it is valid Oracle syntax before compiling. The Microsoft Access Query syntax appears in the edit window. It may require some modification to make it valid Oracle syntax.
Click Access Query to review the initial query and compare it to the converted query. To include this validated query, select it in the left column on the Queries page and click Apply Changes. To include queries in the migration, select the Include check box in the left column on the Queries page. Next, review the forms retrieved from the Microsoft Access export.
Application Migration identifies invalid forms and lists additional information, such as the form's source type and source name. For valid forms with a source type of table, you can select the type of object you want the form to become within Oracle Application Express: form default , report and form, or tabular form.
Microsoft Access forms based on a query are migrated to Oracle Application Express forms. Note that this query has not been parsed. Therefore, you must edit it to make it valid Oracle SQL syntax. Status - Form status as Valid or Invalid. The source of the form must have a status of Valid before you can select it for migration. A form's status is based on two factors: status of its underlying source object and inclusion of the source object in the migration.
Specifically, a form has a status of valid if either one of these situations exists:. Its Source Type object table, query, or SQL query is valid, and it has been included in the migration.
Its check box is enabled and can be selected. Its Source type object has a status of valid, but the source object was not included in the migration. Its check box is disabled. Parent form - Indicates the form and subform relationship that exists in your Microsoft Access database. To run a bulk process that attempts to compile all invalid SQL queries, click Attempt to compile invalid SQL queries at the bottom of the page. Using this option can validate some SQL queries that show a status of invalid.
Note that SQL queries from Microsoft Access forms are not loaded into the Exporter tool, and are therefore not parsed. To include the validated query, click Forms on the project page to go to the Forms page. Then select the newly validated query in the left column and click Apply Changes.
To include forms in the migration, select the Include check box in left column on the Forms page. Next, review the reports retrieved from the Microsoft Access export.
Application Migration identifies invalid reports and lists additional information, such as the report's source type and source name. After you update the reports, select the ones you want to include in the migration. To include a report, the source of the report must have a status of Valid. For each Microsoft Access report, the Reports page shows the following information, if available:. Status of the report: Valid or Invalid.
The source of the report must have a status of Valid before you can select it for migration. A report status is based on two factors: status of its underlying source object and inclusion of the source object in the migration.
Specifically, a report has a status of valid if either one of these situations exists:. To include the validated query, click Reports on the project page to go to the Reports page.
To include reports in the migration, select the Include check box in left column on the Reports page. From the project page, you can drill down to see information about the database, modules, and pages for the migration project.
Database - Displays summary information about the Microsoft Access database, including the full path and size of the. After validating and updating objects, you now must generate the application in Oracle Application Express.
You can create an application based on valid forms and reports, or a maintenance application based on valid tables and views. When creating an application, a home page is defined by default. You have the option to create additional blank pages so that you can introduce further navigation possibilities. You can then choose which user interface theme your application should be based on. By default, the application uses one level of tabs. As a shortcut, you can also set some application defaults.
These defaults are used whenever you create new applications. On the right side of the project page, click Set Application Defaults in the Tasks list. For more information, see item Help. Clicking the item label opens a separate window describing the item and its options. Generate Application - This option generates an application based on the forms and reports you selected to include. Generate Maintenance Application - This option generates an application based on the tables and queries you selected to include.
To rename a page, click the page name link and enter the new name on the New Page Definition page that appears. To select the type of navigation on the application's home page, click the Home Page link. On the New Page Definition page that appears, go to the Page Icon field and select the image you want to appear on that page.
You can either select an image from the select list or click the Find icon flashlight to open a page of options. Repeat this step for each parent page. If you do not explicitly select an image for a page, the default image appears for that page.
Note that for the image to appear in your application, you must have selected either Vertical Images List or Horizontal Images List for the Home page navigation. To add a blank page to the application, scroll down to the Add Page section and click Add Page. A theme is a collection of templates that define the layout and style of an application, including buttons and pages.
To customize your application, scroll down to the Developer toolbar and click Edit Application. You might want to do the following customizations immediately after you generate your application:. Rename the application. Each application has a unique ID, but the migration project name becomes the application name by default. To more easily identify an application, you might want to change its name to something more meaningful by editing the application attributes.
Change the authentication scheme. By default, the authentication scheme is Application Express authentication. You can change this by editing the application attributes. When you delete a migration project, you delete only the metadata associated with the migration project. Deleting a migration project does not delete or impact applications you have generated from the project or any objects, such as tables or views, in the schemas associated with your workspaces.
The export process creates two output files: database. This captures the schema and creates a Captured Model of the Microsoft Access database. On the Login page: In Username, enter admin. Click Login. Click Manage Workspaces. The Manage Developers and Users page appears. Click Create User.
Under User Attributes, enter: Username - Enter the username used to log in to the system. Restrictions include: Maximum length of characters No spaces Only these special characters are permitted: ampersand and period. Email Address - Enter the valid email address for this user. Description - Enter comments about this user optional.
Under Account Privileges: Workspace - Select a workspace in which to create the user. Under Password: Password - Enter a case-sensitive password. Confirm Password - Enter the password again. Click Create. Click the Application Builder icon. Click Migrations on the right side of the page. Enter the project details: Project Name - Enter a unique name. Type - Select Access. Schema - Select the schema. Click Next. Review the project details, and click Finish. The project page appears.
To view project details, click the project name. Available controls on the Search bar include: Select columns to search icon - Resembles a magnifying glass. Go button - Executes a search. Actions menu - Use the Actions menu to customize an interactive report. Tip: Extensive Oracle documentation is available for broadening your knowledge of database concepts and objects.
For example, to learn more about primary keys and constraints, see Oracle Database Concepts. To review retrieved tables: From the project page, click the project name.
The Tables page appears, showing the status of the objects ready for migration. Primary Key - Indicates if a primary key exists for the table. Foreign Key - Indicates if a foreign key exists for the table. Status - Table status as either Valid or Invalid. Only valid tables can be included in the migration. To create a table: On the Tables page, click the link in the Oracle Table column for the table you want to create.
The Object Browser opens. Click the Create button. From the list of object types, select Table. Follow the on-screen instructions. To add a primary key: On the Tables page, click the Oracle table name. From the Tasks list, click Create Primary Key. Tip: To review the list of existing columns or constraints, expand the Existing Columns or Existing Constraints regions.
Tip: To review the list of existing table indexes or columns, click the Table Indexes or Table Columns links. To review retrieved queries: From the project page, click Queries. The Queries page appears, showing the status of the objects ready for migration. Only valid queries can be included in the migration. UI Defaults - Indicates if user interface defaults are defined for the query.
To create a view: On the Queries page, click the link in the Oracle View column for the view you want to create.
0コメント