Create a comparison report similar to the one we see directly in SQL compare but for all tables

Alexander Gofman

In SQL Compare we see the SQL code for two tables - in source and destination. How to create the same, but for all tables? Comparison Results Report does not do it.

sam.blackburn

This depends on what you mean by "view the SQL code for all tables."

• If you want some illustrative SQL organized by the structure of your database, you could create a scripts folder for your database.
• However, if you want SQL you can actually run, it would be better to create a deployment with an empty database as the target. If you view the deployment script (no need to run it) you will see that all the objects would be created in the correct order along with their dependencies.