-
Title
Upgraded to Toad 9.1.0 and above but missing menus under 'Database | Export.' -
Description
Going from Toad 9.0.1 to Toad 9.1.0 and above, there are less menus under the 'Database | Export.' I'm missing the following:
Database | Export | Grants
Database | Export | Sequences
Database | Export | Source Code
Database | Export | Synonyms
Database | Export | Table Data
Database | Export | Table ScriptsWhere did the menus go?
-
Resolution
Database | Export | Grants - In 9.1.0 and above you have go to the Schema Browser and and export it there.
1. To export grants from the Schema Browser
2. In the Schema Browser, select the Users page and then the user that contains the grants.
3. In the right hand side, select the grants you want to export.
4. Right-click and select Create Script. The Export DDL dialog appears with the appropriate options selected.
5. Click OK.
Database | Export | Sequences - In 9.1.0 and above you have go to the Schema Browser and export it there.
1. In the Schema Browser, select the Sequences page.
2. In the left hand side, select the Sequences you want to export.
3. Right-click and select Create Script.
4. The Export DDL dialog appears with the basic options set and the objects selected. Make any changes you desire.
5. Click OK.
Database | Export | Source Code - In 9.1.0 and above it is done using Database | Export | Export DDL.
Database | Export | Synonyms - In 9.1.0 and above it is done using Database | Export | Export DDL.
Database | Export | Table Data - In 9.1.0 and above you have to go to the Schema Browser and select a table. Then right-click and select 'Export Data.'
Database | Export | Table Scripts - In 9.1.0 and above you have to go to the Schema Browser and select a table. Then right-click and select 'Create Script.'