Schema Comparison

OjayOjay Posts: 2
edited June 27, 2011 6:51AM in SQL Compare Previous Versions
Hi. Is there any way to automate a comparison of object structures (e.g. field types/lengths) between a source and a target database? I need to know if any field lengths have changed in the source system.
· Share on Twitter

Comments

  • Eddie DEddie D Posts: 1,803 Rose Gold 5
    Thank you for your post.

    Uisng SQL Compare professional and the Command Line Interface (CLI), you can create a batch file with the required CLI commnads and perfrom an automatic comparison.

    Further advice on the CLI can be found in the SQL Compare help information available HERE and locate the topic "The command line Interface".

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
    · Share on Twitter
Sign In or Register to comment.