Comments
Sort by recent activity
Thanks for answering on a Saturday!. No, unfortunately, that's not my issue. When I execute the sqlcompare with the target as the git repo it will not create the files. However, I've tried a workaround where I make the target a /Script aimed at the same directory as the git repo, and that does create the expected .sql files in the repo. Now that they are created, I will be able to git add and git commit them. So to summarize the switches that worked vs not, these switches did not create sql files in the repo... /sourcecontrol2 /revision2:HEAD /ScriptsFolderXML:D:\DatabaseRepositories\ADB_DEV-SourceLib.xml /Synchronize /force ... and these switches did ... /Scripts2:D:\DatabaseRepositories\adb-dev-db /Synchronize /force I don't think that this workaround was necessary with svn, but it does seem to be needed for Git. Are you able to confirm that? / comments
Thanks for answering on a Saturday!.No, unfortunately, that's not my issue. When I execute the sqlcompare with the target as the git repo it will not create the files. However, I've tried a worka...
@AlexYates I think a Ps/cli for SQL Source Control would be a clever idea! I'm not going to debate a the merits and shortcomings of a "typical" CI process, but suffice it to say in my experience, the "typical" process does not fit the clients that I've worked with very well. I find the RedGate tools to be excellent tools, but the typical approach to deployment does not serve everyone equally well. Thank you for taking the time to assist, and answer! / comments
@AlexYates I think a Ps/cli for SQL Source Control would be a clever idea!I'm not going to debate a the merits and shortcomings of a "typical" CI process, but suffice it to say in my experience, th...
Hey @Alex B, and @AlexYates. Now that I have an answer on the commit question, and I'm running this cli to try and create new files in my repository, but the new files are not being created. For instance I create a new view in the db, I compare the db to the git repo files with a /sync. I am expecting a new .sql file to be created in the repo directory for views but it is not. I get a report that correctly identifies it as new, but no .sql file in my repo directory. Is there a switch in the cli in addtion to sync that I need to use in order to get those files created? In this case I have a table that already exists and is being update, and 3 new objects, My Cli is... "D:\RedGate\SQL Compare 13\sqlcompare.exe" /server1:ASERVER1 /database1:ADB_DEV /sourcecontrol2 /revision2:HEAD /ScriptsFolderXML:D:\DatabaseRepositories\ADB-DEV_SourceLib.xml /Synchronize /force /Report:d:\temp\ADB-DEMO_CommitReport.html /ReportType:Classic /Include:table:\[dbo\].\[DeployVersionControlTest\] /Include:view:\[dbo\].\[DeployVersionControlTestView\] /Include:function:\[dbo\].\[DeployVersionControlTestFunc\] /Include:storedprocedure:\[dbo\].\[DeployVersionControlTestProc\] /LogLevel:Verbose I get exactly the comparison results that I expect, and the html report is perfect, but no files are getting updated or created in the git repo. Can anyone spot what I'm missing here to get the files created in the fit repo directory? / comments
Hey @Alex B, and @AlexYates. Now that I have an answer on the commit question, and I'm running this cli to try and create new files in my repository, but the new files are not being created. For ...
@AlexYates , Yes, SQL Source Control is clever, does it have a powershell or cli interface that can be used by a Ci/Cd process to utilize it programatically, or is it only usable via gui in ssms? @Alex B , you and Alex Yates have different answers regarding whether a commit is made to Git. Updating files and committing to git are two different things. Can I get a definitive answer on which it is? / comments
@AlexYates , Yes, SQL Source Control is clever, does it have a powershell or cli interface that can be used by a Ci/Cd process to utilize it programatically, or is it only usable via gui in ssms?@A...
Thanks for the clarification. Knowing that, I should be able to "save the changes" and then perform my own commit and push with comments as this cli is being called and executed in a shell script where I can execute git commands after the SqlCompare runs. / comments
Thanks for the clarification. Knowing that, I should be able to "save the changes" and then perform my own commit and push with comments as this cli is being called and executed in a shell script ...
Thank you Alex, that is a much better answer and resolution than the first! I have tested this solution, and it works great! Thank you for the quick resolution! / comments
Thank you Alex, that is a much better answer and resolution than the first!I have tested this solution, and it works great!Thank you for the quick resolution!
I have tried the cli using a straight db to db compare, and it completes successfully... SQLCompare.exe /server1:SERVERNAME1 /database1:DBNAME_DEV /server2:SERVERNAME2 /database2:DBNAME_TEST /Report:d:\Temp\MarkitDEMO_CompareTest_DbToDb.html /ReportType:Classic /Include:table /Include:table:\[dbo\]\.\[DeployVersionControlTest\] /LogLevel:Verbose /ScriptFile:d:\Temp\MarkitDemo_CompareTest_DbToDb.sql SQL Compare Command Line V13.7.7.10021 ===================================================================================================================================================================================== Copyright Copyright c Red Gate Software Ltd 2019 SQL Compare: activated, edition professional, serial number: Registering data sources Creating mappings Comparing Applying Command Line Items Retrieving migration scripts Generating report Checking for identical databases Creating SQL Saving SQL Summary Information ====================================================================================================================================================================================== DB1 = SERVERNAME1.DBNAME_DEV DB2 = SERVERNAME2.DBNAME_TEST Object type Name DB1 DB2 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Table [dbo].[DeployVersionControlTest] >> -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- / comments
I have tried the cli using a straight db to db compare, and it completes successfully... SQLCompare.exe /server1:SERVERNAME1 /database1:DBNAME_DEV /server2:SERVERNAME2 /database2:DBNAME_TEST /Repor...
I am aware that SVN works fine, I am disappointed that this was released without git being fully functional, it almost seems untested. / comments
I am aware that SVN works fine, I am disappointed that this was released without git being fully functional, it almost seems untested.