Options

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

Alexander GofmanAlexander Gofman Posts: 4 New member
in SQL Compare
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.
Tagged:
· Share on Twitter

Answers

  • Options
    sam.blackburnsam.blackburn Posts: 224 Gold 2
    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.
    Software Developer
    Redgate Software
    · Share on Twitter
Sign In or Register to comment.