Hi, using SSMS, I right-click on my DB and use Schema compare\\deploy and choose as Source.
Then on my Target I choose New Database but the Dropdown for Create on: box is blank. I cannot select any server that I am connected with SSMS. When I try to click on the compare/deploy with SQL compare button it says I must select a server and to select servers I must be connected to them in SSMS which I am.
Is this a bug or what am I doing wrong?