In Step 10, you can control how the Oracle Upsizing Wizard exports your tables. You can also specify the changes you want the Oracle Upsizing Wizard to make to the local database. You can create upsizing reports, redirect views to use remote data, create new remote views on tables that are upsized, and save passwords with views.
By default, the Oracle Upsizing Wizard exports a table's structure and its data. Along with field names and data types, you can also export:
The Oracle Upsizing Wizard can export additional table properties. The Oracle Upsizing Wizard can also modify your Visual FoxPro database so that your queries, forms, and reports use the data in your new Oracle tables, rather than the data in the local Visual FoxPro database.
Visual FoxPro indexes and defaults become Oracle indexes and defaults. If you choose to export validation rules, the Oracle Upsizing Wizard attempts to export field- and table-level validation rules to Oracle, where they become Oracle constraints. Exported table relationships also become part of the constraints.
Tip If you export table relationships, be sure to export indexes as well or you might experience mediocre performance.
Indexes
Select to upsize Visual FoxPro .cdx indexes.
Defaults
Select to upsize default values for table fields.
Relationships
Select to upsize relationships stored in the database you are upsizing.
Use declarative referential integrity
Select to establish relationships to enforce referential integrity.
Validation rules
Select to upsize field and table validation rules.
Structure only, no data
Select to upsize the empty table structure, without copying table data to the Oracle data source.
Create upsizing report
Select to create a series of reports documenting the results of the upsizing process.
Redirect views to remote data
Select to change the definition of views in the database you are upsizing so that your queries, forms, and reports use views on the data in the new Oracle data source rather than the original Visual FoxPro data.
Create remote views on tables
When you upsize a local table, you need a remote view to access the upsized table on the remote server. The Oracle Upsizing Wizard can create new, remote views as you upsize. As the Oracle Server Upsizing Wizard creates new remote views, it renames all local versions of tables by adding the suffix "_local" to the table name.
Note Creating remote views on tables as you upsize is not recommended, because these unoptimized views select all the data in the table rather than selecting only the information your application needs. The preferred method is to create parameterized views. You can either create a local parameterized view, which you then upsize by choosing Redirect views to remote data, or create a new parameterized remote view on the table after you've completed the upsizing process.
Save password with views
By default, you must enter your password and login ID when opening a remote view in a new session with Visual FoxPro. Select this option to store your password locally with the remote view definition in your database.
When you select Create Upsizing Report, Visual FoxPro generates upsizing reports that document the tables, views, fields, indexes, and referential integrity constraints the Oracle Upsizing Wizard creates on Oracle. The Oracle Upsizing Wizard places the reports in a new project, using the following report names:
The upsizing reports include information about any devices and databases that are created, information about any errors encountered during the upsizing process, and a complete explanation of the way in which each Visual FoxPro object is mapped to a Oracle object. You can view or print these reports after upsizing is complete.
If you upsize all the tables in a local view, the local view is renamed by adding the suffix "_local" to the existing local view name. The Oracle Upsizing Wizard creates a new view based on the SQL statement of the local view, substituting the remote table names for the local table names. The KeyField and other update properties of the view are preserved.
If you upsize only some of the tables in a view, the Oracle Upsizing Wizard does not rename the local views. Instead, it renames the Visual FoxPro tables you export with the suffix "_local." For example, if you export a table named "Employees," the table is renamed "Employees_local" in your database. The Oracle Upsizing Wizard then creates a remote view for each of the tables you exported. Each view selects all fields and all records from the remote table.
Note Visual FoxPro handles local and remote data in different ways, which might cause upsized applications to function improperly.