I have a saved project that when I deploy through the GUI, migration scripts are included in the deployment. ![]() I don't know if this is related to this issue or not. 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?įor 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. 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. That's correct, because I don't have SQL Source Control installed on the Build Agent. Using source controlled databases requires SQL Source Control to be installed. I use the SQL Automation Pack to get the SQLCompare CLI. SQLCompare.exe /sourcecontrol1 /db2:Application_2030 /sf:"D:\Upgrade - 02 - Model.sql" /s2:databaseServer\Development /f /r1:5000 /r2:HEAD I currently got the following command line: 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 am working on automatic making of sql scripts with TFS Build workflow for our installation packages.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |