Save off differences between databases using command line getting NothingToCompareException
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 /export:C:\Users\andrew.vahey\Documents\CompareResults\FastTrackDataCompare.csv /Include:table:$TablesToCheckDefaultData