Thursday, November 8, 2012

SSDT Script not found and update button disabled

SSTD is an awesome tool for comparing databases and updating them. Allthough it has some performance problems with the Object Definitions window open, it is still cool.

Yesterday I had some annoying problems with it. The first one I encountered was a message called 'Script not found':

It was caused by the .refactorlog in the project. After deleting the file the errormessage was gone.

But now what... the update and script buttons are disabled... lets click compare again and again. Nothing enables it. After some testing it was caused by a compile error which was solved with the compare window open. Lesson learned: After solving the compile error, you'll have to close the schema compare window and open a fresh one. Now they are enabled again.