Save the database schema as a snapshot each time you run the project.

How it's Done
Backup
  • Create a new project and change the project to a Schema View Project
  • Select your desired database
  • Go to On Completion Tab
  • Add Save Snapshot and define the snapshot filename
  • Switch On Completion to Active
  • Save the project

Now whenever you run this project it will load the schema and save as a snapshot.

Add a new Windows Task Scheduler command to run SQL Delta and add this project to the command line. Now your schema will be saved on a schedule.

Run a schema compare and automatically email the compare report when finished.

How it's Done
Auto Report
  • Create a new project
  • Select your desired source and target database
  • Go to On Completion Tab
  • Add Generate Compare Report and define the report and filename
  • Add Email File and define the email details.
  • When defining the email details select the attachment file and hit add.
  • Switch On Completion to Active
  • Save the project

Now whenever you run this project it will load generate a compare report and email the report.

Add a new Windows Task Scheduler command to run SQL Delta and add this project to the command line. Now your databases will compared and a report emailed on a schedule.

Go to System Preferences to configure the outbound SMTP email server.