One to many database comparison with dynamic script generation

Welcome to the Toad for SQL Server forum.

The typical and most frequent use case for a sync is of the one-way variety... e.g. to make target look like source, especially in the scenario you've mentioned where you have one source (database/schema) and multiple targets.

However, Toad's Schema Compare should allow you to see the CREATE script for any objects on the target that aren't on source. Use the filter pane. See snap, and hope this helps.

1 Like