How do you make a copy of the database and objects?
Features under Tools | Export has options for making copies of the database and objects.
- Generate DDL script give the option of select what/all objects of a database and creates the scripts for these.
- Export Wizard gives the option to select some objects for export in different formats.
Backups of a database can also be made by using the right click menu. In the Object Explorer, list the databases and right click on the database you'd like. Choose to Backup. There are also other script options available here too.
Similar menu options and script options accessible through the right click menu for individual objects through the Object Explorer.
Applies to various version of Toad for SQL Server. Location of features may have slight changes between versions.