Comments
Sort by recent activity
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...
Assuming you are using shared model and that you are looking at the objects listed in the commit tab. If that assumption is incorrect please disregard the rest of this answer an clarify.
Short answer: No. This list is calculated by comparing dev database to source control and the info about who committed what is pulled from he default trace.
Longer answer: You could set up an automated SQL Compare job using SQL Compare command line to create a report of the differences between source control and dev database, but this will not have info about who made what changes unless you also cross-reference with default trace, which sounds hard.
My recommendation: Switch to the dedicated model. Then this problem probably mostly goes away. / comments
Assuming you are using shared model and that you are looking at the objects listed in the commit tab. If that assumption is incorrect please disregard the rest of this answer an clarify.
Short answ...