Dropping Version 6.0/6.1 Directory Tables

After an Optim™ Directory in an SQL Server database has been converted, you can drop the version 6.0/6.1 Directory tables. To drop the 6.0/6.1 Directory tables, select Drop DB Alias or Optim Tables from the Configuration program Tasks menu.

Specify Optim Directory

Use the Specify Optim Directory dialog to select the name of the version 6.0/6.1 Optim Directory you want to drop. Click Proceed to continue.

Connect to Database

The Configuration program must connect to the database to drop the Optim Directory tables. Use the Connect to Database dialog to provide the connection information. Click Proceed to continue.

Create/Select DB Alias

In the Create/Select DB Alias dialog, click Skip to continue the process of dropping the version 6.0/6.1 tables. Do not click Proceed, or the Configuration program will drop the DB Alias for your new Optim Directory.

Drop the 6.0/6.1 Optim Directory Tables?

In the Drop the 6.0/6.1 Optim Directory Tables? dialog, select Drop the 6.0/6.1 Optim Directory Tables to make the Directory unavailable to the Optim products version 6.0/6.1. Click Proceed to continue.

Drop DB Alias/Optim Tables - Drop the 6.0/6.1 Optim Directory Tables? dialog

Connect to Database

The Configuration program must reconnect to the database to drop the Optim Directory tables. Use the Connect to Database dialog to provide the connection information. Click Proceed to continue.

Drop Optim Directory Tables

Before you drop an Optim Directory (and Optim Directory tables), the Configuration program displays the table identifier and prompts you to review the generated SQL, using the Drop Directory Tables dialog. Click Proceed to drop the 6.0/6.1 Directory tables and continue.

Create/Drop Stored Procedures

Use the Create/Drop Stored Procedures dialog to drop the stored procedures SQL Server uses to access tables in the 6.0/6.1 Directory. Click Proceed to continue.

Drop the Current Directory?

In the Drop the Current Directory? dialog, select Drop Current Directory to drop all DB Aliases and object definitions in the 6.0/6.1 Directory. Click Proceed to continue.

Drop DB Alias/Optim Tables - Drop the current Optim Directory? dialog

Connect to Database

The Configuration program must connect to the database in order to drop the DB Aliases, object definitions, and stored procedures. Use the Connect to Database dialog to provide the connection information for the Directory. Click Proceed to continue.



Feedback