Enable switching directions in sqlcompare.exe
sqlcompare.exe has a project switch. This allows you to prepare a project to sync selected objects that can be re-run against multiple targets (/server2, /database2). I would like to be able to build rollback scripts using the same project file (in an automated process). However, because there is no /direction switch if you swap /database1 and /database2 the selections are no longer valid. The selections must be tied to the original source database.
If I open the same project file in the SQL Compare GUI I can simply choose switch deployment direction (after running the compare). This provides the rollback that I am looking for but cannot be automated.
I do want to add that I did find a workaround. After diffing the scp files the only difference was actually the <Directory/> value. I was able to read the scp file and write out a new file with Directory = 1. This file works as expected. So, sqlcompare.exe does have the ability to reverse the direction and actually does. But, this functionality can only be accessed using a project. The application is just missing the command line switch. I guess the only time when you would want to reverse the direction is when you have objects selected. Otherwise you could just swap /1 with /2. It would still be nice to be able to set the direction using a switch instead of having a separate scp file just for this 1 character difference.