Comments
Sort by recent activity
That is a mess, so here's a file / comments
That is a mess, so here's a file
I don't think you can. Clean is clean, remove all objects because users are a part of what we deploy. / comments
I don't think you can. Clean is clean, remove all objects because users are a part of what we deploy.
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/