User profile for jschwarz_continuus

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...

0 votes

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 ...

0 votes

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!

0 votes

@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...

0 votes

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 ...

0 votes

@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...

0 votes

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.

0 votes

If I /sync a table from a db to a git repo, is that essentially a "commit" to the repo?

And if so, can I add a commit comment (like I can in the source control gui) when executing the /sync from the cli?

3 followers 13 comments 0 votes

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...

0 votes

How can we help you today?

jschwarz_continuus

Activity overview