Comments
Sort by recent activity
Support for SCA build artifacts was built recently so you may not be on the latest version. However I'd still suggest you use the Use-DatabaseReleaseArtifact cmdlet instead of Sync-DatabaseSchema https://documentation.red-gate.com/display/SCA3/Use-DatabaseReleaseArtifact / comments
Support for SCA build artifacts was built recently so you may not be on the latest version.However I'd still suggest you use the Use-DatabaseReleaseArtifact cmdlet instead of Sync-DatabaseSchemahtt...
I don't think that functionality is available. There's just an option to control how many commits are displayed. https://documentation.red-gate.com/soc6/configuring/change-how-many-revisions-are-shown-in-the-history-dialog-box / comments
I don't think that functionality is available. There's just an option to control how many commits are displayed.https://documentation.red-gate.com/soc6/configuring/change-how-many-revisions-are-sho...
mmousheimish when are you getting this error? Is it when starting Visual Studio, opening a project or trying to do any other action? Are you uninstalling SQL Change Automation through the Visual Studio installer? / comments
mmousheimish when are you getting this error? Is it when starting Visual Studio, opening a project or trying to do any other action?Are you uninstalling SQL Change Automation through the Visual Stu...
Regarding Q1 you're correct. The baseline should be made from the production database which is set as the deployment target. I don't think I understood the final part of your question. Regarding Q2 the migration control table will get created on the first deployment and the baseline will only be executed if you have an empty database. So if your databases for the different environments already have some objects in them then you sholdn't need to do anything else. / comments
Regarding Q1 you're correct. The baseline should be made from the production database which is set as the deployment target. I don't think I understood the final part of your question.Regarding Q2 ...
My suggestion for the sql proj was based on the cmdlet reference. https://documentation.red-gate.com/display/SCA3/Invoke-DatabaseBuild Notice that when we pass in a folder we're referring to a SQL Source Control project not a SCA project which I think is what you are using. / comments
My suggestion for the sql proj was based on the cmdlet reference. https://documentation.red-gate.com/display/SCA3/Invoke-DatabaseBuildNotice that when we pass in a folder we're referring to a SQL S...
Hi @CopperStarSystems, I think you should using the path to your SCA project file (a .sqlproj file) on your project variable. Does that make a difference? / comments
Hi @CopperStarSystems,I think you should using the path to your SCA project file (a .sqlproj file) on your project variable. Does that make a difference?
Could you please show us the create table scripts for the 3 tables? / comments
Could you please show us the create table scripts for the 3 tables?
I don't think so. You can install our Powershell component through the link below. https://documentation.red-gate.com/sca3/about-sql-change-automation/installation/installing-powershell-components The next link also has some examples of how to use cmdlets. https://documentation.red-gate.com/display/SCA3/Getting+started+with+the+SQL+Change+Automation+PowerShell+components What is your Continuous Integration system? Currently we have support for SCA projects in our VSTS and TeamCity plugins. / comments
I don't think so. You can install our Powershell component through the link below.https://documentation.red-gate.com/sca3/about-sql-change-automation/installation/installing-powershell-components T...
We only allow the last migration to be deleted because they will will depend on each other, so deleting other migrations could cause problems. If you're interested in knowing a bit more, I'd recommend our documentation page. https://documentation.red-gate.com/soc6/common-tasks/working-with-migration-scripts/how-migration-scripts-work / comments
We only allow the last migration to be deleted because they will will depend on each other, so deleting other migrations could cause problems.If you're interested in knowing a bit more, I'd recomme...
Hi @jdms754 I'm afraid SQLCMD variables are not yet supported on the SQL Change Automation VSTS extension. We are aware of this and it is a priority so we expect a fix in the near future. At present, if you're using SQLCMD variables, we recommend that you continue to use the old ReadyRoll VSTS extension. With regards to your second question, you are correct that the database connection needs to be specified in both tasks. / comments
Hi @jdms754 I'm afraid SQLCMD variables are not yet supported on the SQL Change Automation VSTS extension. We are aware of this and it is a priority so we expect a fix in the near future. At presen...