Comments
Sort by recent activity
You need to save the package that you created in your build plan as an artifact.
Then you need to create a deployment plan to deploy the package to the other environments.
I can't find a SQL Server or plug-in walk through - but I wrote this blog post (first of a 2 parter) which talks you through a similar process for Oracle databases using command lines and powershell scripts etc.
The Bamboo bits are mostly the same. http://workingwithdevs.com/continuous-delivery-oracle-databases-bamboo-redgate-1/ / comments
You need to save the package that you created in your build plan as an artifact.
Then you need to create a deployment plan to deploy the package to the other environments.
I can't find a SQL Server...
By default DLM Automation will try to create a database on localDB on the Bamboo agent (whether this is an on prem or cloud agent). https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/sql-server-2016-express-localdb
If local DB is not installed on your build agent you should provide details for your own SQL instance where DLM Automation will build the database. / comments
By default DLM Automation will try to create a database on localDB on the Bamboo agent (whether this is an on prem or cloud agent).https://docs.microsoft.com/en-us/sql/database-engine/configure-win...
I'm afraid there isn't. Not without unlinking and relinking anyway.
Can you tell me a little bit more about your custom objects? Are these for different versions of production (e.g. for different customers) or for dev/test databases? Are we talking about schema or static data differences? What sorts of objects? Tables, sprocs etc? Do you have handy naming conventions?
There are clever things you can do with filters and post deploy scripts etc. For example: https://www.red-gate.com/hub/product-learning/sql-compare/how-to-build-multiple-database-versions-from-the-same-source-using-sql-compare-filters / comments
I'm afraid there isn't. Not without unlinking and relinking anyway.
Can you tell me a little bit more about your custom objects? Are these for different versions of production (e.g. for different c...
I'm afraid not: https://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/1267757-allow-me-to-specify-a-subset-of-columns-for-static / comments
I'm afraid not:https://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/1267757-allow-me-to-specify-a-subset-of-columns-for-static
I'm trying to think of a good way to do this but can't think of anything better than move the static data and "not static data" into different tables.
Is there any reason why you can't do that? (Other than the fact that this sounds like a complicated data migration). / comments
I'm trying to think of a good way to do this but can't think of anything better than move the static data and "not static data" into different tables.
Is there any reason why you can't do that? (Ot...
I'm having the same issue. I have reproduced it on a VM on my laptop and I have a snapshot you can play with when I'm next in Cambridge. Works in SSMS 2014 but not 2017.
Guess I'll have to use old SSMS for my demo today. as don't have time to follow all steps above. :-( / comments
I'm having the same issue. I have reproduced it on a VM on my laptop and I have a snapshot you can play with when I'm next in Cambridge. Works in SSMS 2014 but not 2017.
Guess I'll have to use old ...
Command line.
> git push
I know. / comments
Command line.
> git push
I know.
Apologies, just saw the notification.
Well you could write your own PowerShell to call the SQL Compare command line to do all the things, and then wrap that into some higher level orchestrated process using Octopus or similar.
Or you could buy a licence. No point reinventing the wheel. SQL Compare does not have email functionality because that's not how it's designed to be used.
If you want a full pipeline orchestration solution with email notifications the tool Redgate provides is DLM Automation, which plugs into the likes of Jenkins, Octopus, VSTS etc and should give you what you need. / comments
Apologies, just saw the notification.
Well you could write your own PowerShell to call the SQL Compare command line to do all the things, and then wrap that into some higher level orchestrated proc...
(But you cannot trigger emails directly from SQL Compare.) / comments
(But you cannot trigger emails directly from SQL Compare.)
I recommend using something like Octopus Deploy to orchestrate your deployments. You can add steps to call Redgate to generate diff reports/upgrade scripts, trigger emails pre/post deployment, carry out a manual review of diff reports, and execute scripts as required.
Octopus Deploy: https://octopus.com/
Integrating Octopus and Redgate DLM Automation (a PowerShell interface for SQL Compare and other RG tools): https://documentation.red-gate.com/display/DLMA2/Octopus+Deploy+step+templates+reference / comments
I recommend using something like Octopus Deploy to orchestrate your deployments. You can add steps to call Redgate to generate diff reports/upgrade scripts, trigger emails pre/post deployment, carr...