ApexSQL Knowledgebase: Object-level differences in ApexSQL Diff CLI

LINKS

General

ApexSQL Audit
ApexSQL Clean
ApexSQL Data Diff
ApexSQL Debug
ApexSQL Diff
ApexSQL Diff API
ApexSQL Doc
ApexSQL Edit
ApexSQL Enforce
ApexSQL Log
ApexSQL Log API
ApexSQL Recover
ApexSQL Refactor
ApexSQL Script
ApexSQL Source Ctl
ApexSQL SSIS Compare

Knowledgebase Home

SITE FEED

Site Feed

Support Forum

The fastest and most effective to get answers to your questions quickly.

FAQs

Quick answers to common questions.

Troubleshooting

Known issues and basic troubleshooting techniques for problems or unexpected behaviors.

Knowledgebase

Technical tips, How-to articles, and other tutorials about ApexSQL Tools.

Online Documentation

All of our help files for download or convenient viewing online.

Videos

Watch product demos, training videos, or tutorials of our products' main features.

ApexSQL Knowledgebase

Tips and How-to Articles for ApexSQL Tools

Object-level differences in ApexSQL Diff CLI

Sometimes it is helpful to see objects differences while comparing data sources in CLI mode of ApexSQL Diff application. This feature is available in ApexSQL Diff

Comparison summary.
ApexSQL Diff now shows comparison results in CLI in text mode.

Object level differences.

Object level differences information is displayed in form of table with three columns “Name”, “Owner” and “Result” for each compared object. These tables are grouped by object type that are compared the way objects are grouped in ApexSQL Diff GUI.

Result column can have one of the following values:

1) == - if compared objects are equal;

2) <> - if compared objects differs;

3) >> - if object exists only in source data source and does not exist in target data source;

4) << - if object exists only in target data source and does not exist in source data source;

In case if database objects have different owners and mapped, both owners will be displayed in result objects table.

In this case tables “AWBuildVersion” and “ErrorLog” has “Person” owner in source data source and “dbo” owner in target data source.

Script-level differences.

For each compared object, ApexSQL Diff displays its script. If objects are different, it also shows exact differences on script level (the way similar to ApexSQL Diff GUI).

First two symbols of each line of the script have one of the following values:

1) == - if lines are equal in source and target scripts;

2) >> -displays line from source script (in case lines if source and target scripts are different);

3) << - displayed line from target script (in case lines if source and target scripts are different);

For example, String data type is displayed like:

From this screen you can see that String data type differ in second line of script.

Source script contains FROM [varchar](150) line

Target script contains FROM [varchar](100) line

All other lines are equal for both scripts.

When object exists only in source or in target data source, the whole object script is displayed using “>>” and “<<” prefixes.

The summary and details information are displayed if /v switch is specified for CLI comparison. The information is displayed in standard output stream, so it can be redirected to the file for further analysis and saving.

Get your developers the tools they need to do the job fast and right - ApexSQL Developer Studio is the ultimate combat multiplier for SQL Developers. Best of Class tools - one download, install and discounted price. Click Here for more info.

Labels: ApexSQL Diff

posted by Janice Lee on Tuesday, January 19, 2010

0 Comments: