What are the challenges you face when working across database platforms? Take the survey
Options

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.

Comments

  • Options
    Eddie DEddie D Posts: 1,792 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
Sign In or Register to comment.