The Drops Generation Wizard will generate a drop <object> script for un-referenced objects that are not being used by other objects anymore and therefore can be safely removed from the database.
|
FAQ: Why would I use the Drops Generation Wizard?
It will generate a drop <object> script for un-referenced objects that are not being used by other objects anymore and therefore can safely be removed from the database. You don't need to create such a script yourself and in this respect the drop generation wizard adds greatly to your safety.
|
|
FAQ: ApexSQL Clean identified un-referenced objects in my database. How can I safely remove these objects?
ApexSQL Clean contains a quick and powerful Drops Generation Wizard that will help you clean your database fast, efficient and completely free of error while doing that.
|
Include Transaction Handling in Drop Script option will include Error handling statements with Rollback/Commit statements depending on the success or failure of the Drop. Any error in the Drop script will cause the resulting statements to be parsed only and the executed statements to be rolled back.
Backup Original Database will include SQL statements in the beginning to create a back-up of the Destination database immediately prior to statements that would make changes. If errors occurred the database will be restored to its state prior to executing the drop script.
Don't Create - backup statements won't be included in the drop script.
Use Default Backup Directory - use the default backup directory generally associated with SQL Server.
Use this Directory - opens a dialog to allow specification of a user defined directory to write the backup to.
|
FAQ: Is there a backup if something goes wrong?
ApexSQL Clean is designed with the safety of your databases in mind. As such, it includes the option in the drop generation wizard script to add a backup command which will backup the database immediately before the drop statements are executed. This ensures, that in any case of disaster you are able to restore to the databases' most recent state. We strongly recommend that you have such a most recent backup of a database before changing anything in a production database. No matter if these changes are suggested by ApexSQL Clean or not.
|
|
Button |
Description |
|
|
Opens the ApexSQL Clean help. |
|
|
|
|
|
Discards any changes and restores the defaults. |
|
|
|
|
|
Saves the current project. |
|
|
|
|
|
Saves the current project with a new name. |
|
|
|
|
|
Steps back to the previous wizard page. |
|
|
|
|
|
Steps forward to the next wizard page. |
|
|
|
|
|
Generates the Drop script. |
|
|
|
|
|
Exits the Drop Generation Wizard. |
|
|
|
Copyright © 2008 ApexSQL LLC. All Rights Reserved.
