Save off differences between databases using command line getting NothingToCompareException

AndrewVaheyAndrewVahey Posts: 2 New member
edited September 16, 2020 9:22PM in SQL Data Compare
I'm trying to write a powershell script that compares the data in a list  of tables between our master database and our production databases. I keep getting an error saying "Nothing to compare. Either there are no tables/views that can be compared, or everything has been filtered out". I know that some of the tables are absolutely not the exact same. I'm not really sure what I'm missing. I've read through the documents and I thought I had the table list formatted correctly but I'm still running into issues getting any output. 

$TablesToCheckDefaultData = "\[HierType\]^|\[Hier\]" 

sqldatacompare /server1:PC-ANDREWVAHEY /database1:Tworks_master /server2:DRHSQL2014B /database2:AllStarLabor 



  • Eddie DEddie D Posts: 1,779 Rose Gold 5
    Hi, thank you for your forum post.

    Do you experience an Exit Code 63 along with the "Nothing to compare" message?

    If yes, can you please add the /Include:Identical switch to your syntax which will suppress the 63 exist code.

    Otherwise, can you add the /LogLevel:Verbose switch to your syntax?  This switch will generate a log file of comparison which may aid fault finding.  You will find the log file in this path:
    C:\Users\<user name>\AppData\Local\Red Gate\Logs\SQL Data Compare

    Many Thanks
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
Sign In or Register to comment.