T-SQL Interface to schema compare
ozyjumpin
Posts: 2
Im new to Toolbelt
I can see both a GUI Interface as well Command Line interface to the Schema comparison capability, but is a SQL script interface also available
I want to run a schema comparison from within a runnning T-SQL script.
For example, are there storeprocedure equivalents to the command line interface commands
Could you provide pointers to documentation if so
Ozy
I can see both a GUI Interface as well Command Line interface to the Schema comparison capability, but is a SQL script interface also available
I want to run a schema comparison from within a runnning T-SQL script.
For example, are there storeprocedure equivalents to the command line interface commands
Could you provide pointers to documentation if so
Ozy
Comments
Unfortunately the answer to your question, there is not a SQL Script Interface for performing the comparison.
Along with the GUI and Command Line Inteface that you have already found, there is the Comparison SDK where you can create your own application that references the SQL Compare (also SQL Data Compare & SQL Packager) dll files.
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com