I set up my first migration script in SQL Source Control, but need some help determining why SQL Compare won't detect the script. Thank you in advance for any advice you can provide.
SQL Compare version: 10.3.1.140
SQL Source Control version: 18.104.22.168
SQL Server 2008 R2
Example I'm following: Worked Example
+ I have checked in the migration script to source control (TFS).
+ The only difference between what I did and the example is that I created the migration script against "Specific Changes", not "Uncommitted Changes", which means I could not select a specific table like they did in the example. Is that the problem?
+ The script is set to transition the DB from revision 10392 to 10459
+ I have verified that the Target DB in SQL Compare is on revision 10392
using the "SQLSourceControl Database Revision" extended property on the target DB.
+ In the example above, SQL Compare shows a "Revision: 64" under the "Database" drop-down when setting up the source and target. Mine does not show any "Revision" label at all. What does that mean?