Compare Database revisions without SQL Sourcecontrol
I am working on automatic making of sql scripts with TFS Build workflow for our installation packages. I can get the comparisation of 2 different databases working, but more preferably I want to compare one database that is under SQL Source control from a specific revision to the HEAD revision. I currently got the following command line:
SQLCompare.exe /sourcecontrol1 /db2:Application_2030 /sf:"D:\Upgrade - 02 - Model.sql" /s2:databaseServer\Development /f /r1:5000 /r2:HEAD
I use the SQL Automation Pack to get the SQLCompare CLI.
But when I try to run it, it returns:
Using source controlled databases requires SQL Source Control to be installed.
That's correct, because I don't have SQL Source Control installed on the Build Agent.
I have complete access to the TFS Server where the database is source-controlled from the executing agent and also got full access to the database server from my build agent.
So my question is, is it possible to create a SQL Script with the SQLCompare tool between two revisions without Sql Source Control installed? Can it also get the revisions from TFS?
For me it sounds strange to install SSMS and SQL Source Control on my build agent while I never open the Program itself on the machine nor do check-ins or database changes.