Comments
Sort by recent activity
Quite a bit here to discuss. I'm not sure what the errors are, so it's hard to know what to do here. I assume you build a scpf file and set that up in the project configuration? I'm not sure the order of import, though it would require a filter file to import the objects by type. You'd include only tables in the filter file, then edit it to include views, import, then edit, etc. Can you include a zip file of the schema and I can run a test to try and understand the errors or include a screenshot of some of the errors you're getting? / comments
Quite a bit here to discuss. I'm not sure what the errors are, so it's hard to know what to do here. I assume you build a scpf file and set that up in the project configuration?I'm not sure the ord...
I see this in the release notes as an experimental feature, using the option: UseCreateOrAlterForRerunnableScripts https://documentation.red-gate.com/sca/release-notes-and-other-versions/sql-server-management-studio-add-in-release-notes/sql-change-automation-ssms-4-2-release-notes I haven't used this, but it was a subject of debate recently. I'm guessing this is one of the Compare engine options you add to a project. It is in the Comparison options. If you set up a project, the middle step is the options: [image] Click the Edit Comparison Options button. This gives you options, which are shown here. This in the middle. [image] / comments
I see this in the release notes as an experimental feature, using the option: UseCreateOrAlterForRerunnableScriptshttps://documentation.red-gate.com/sca/release-notes-and-other-versions/sql-server-...
I didn't see a great image, but this post from Donovan might help: https://www.donovanbrown.com/post/clean-solution-vs-clean-repository-in-visual-studio-online-build
This isn't checked by default, but I check clean, usually to ensure I don't have too much stuff hanging around over time.
/ comments
I didn't see a great image, but this post from Donovan might help: https://www.donovanbrown.com/post/clean-solution-vs-clean-repository-in-visual-studio-online-build
This isn't checked by default, ...
You might try this in SQL Compare and look for an issue with the objects. / comments
You might try this in SQL Compare and look for an issue with the objects.
Use filters to remove some of the complexity for things you don't deal with.
https://documentation.red-gate.com/sca3/automating-database-changes/automated-deployment-with-sql-source-control-projects/using-sql-compare-filters-with-sql-change-automation-powershell-module?_ga=2.180461031.1773567949.1585151048-1603661970.1473869934
A few articles on xdb stuff. It's both common, but not too common and it's a very complex issue. We are working on what to do here. https://www.red-gate.com/hub/product-learning/sql-change-automation/database-build-blockers-cross-server-database-dependencies?product=sql-change-automation
https://www.red-gate.com/hub/product-learning/sql-change-automation/resolving-cross-database-dependencies-in-sql-change-automation-using-local-databases-or-clones?product=sql-change-automation
https://www.red-gate.com/hub/product-learning/sql-change-automation/database-build-blockers-mutually-dependent-databases?product=sql-change-automation / comments
Use filters to remove some of the complexity for things you don't deal with.
https://documentation.red-gate.com/sca3/automating-database-changes/automated-deployment-with-sql-source-control-project...
We don't really offer support here for Jenkins. The thing to note is that Jenkins does a git clone to get this repo to your build agent spot. The pathing should be relative to the root of your git repo. / comments
We don't really offer support here for Jenkins. The thing to note is that Jenkins does a git clone to get this repo to your build agent spot. The pathing should be relative to the root of your git ...
You have some pathing error here. This isn't the main project folder if there isn't the SCA project inside. If you are using SQL Source control, then you have the step mis-configured. You need the action to be a build for a SQL Source Control project. / comments
You have some pathing error here. This isn't the main project folder if there isn't the SCA project inside. If you are using SQL Source control, then you have the step mis-configured. You need the ...
I have a walkthrough of some of this in Jenkins as well: https://voiceofthedba.com/tag/jenkins/ / comments
I have a walkthrough of some of this in Jenkins as well: https://voiceofthedba.com/tag/jenkins/
You might also consider a snippet in SQL Prompt if you don't want something for every single object. This one will create a stub proc if it doesn't exist and then an ALTER will work. You could also change the logic to handle tables or use DROP IF EXISTS IF NOT EXISTS( SELECT name FROM sys.objects o WHERE o.name = '$myproc$')
CREATE PROCEDURE $myproc$
as begin select 1 end / comments
You might also consider a snippet in SQL Prompt if you don't want something for every single object. This one will create a stub proc if it doesn't exist and then an ALTER will work. You could also...
Kendra has a view on some of this here: https://www.youtube.com/watch?v=20xJTUokUxM&t=1s You can work with the objects, database by database, and certainly commit from each one. The challenge with deployment is understanding where the dependencies exist and which order in which to deploy changes. For builds, you likely want all databases o the build server, and then deploy to a new name for each to test the changes. / comments
Kendra has a view on some of this here: https://www.youtube.com/watch?v=20xJTUokUxM&t=1sYou can work with the objects, database by database, and certainly commit from each one. The challenge with d...