49 results found
-
Allow artifact names to be modified in OctopusDeploy step template via new parameter
In the "RedGate - Create Database Release" step template for OctopusDeploy, the powershell script contains logic for uploading Change.html, Warning.xml and Update.sql files (among others) as artifacts on the current Release. The only text added to the resulting artifact file name besides these keywords is the name of the database. In our environment, every single release produces each of the above artifacts, and if you view a Release that has been promoted through multiple environments the Artifact listing just shows the exact same artifact names repeated over and over with no indication of the environment in which they were produced.…
3 votes -
Way to Subscribe to Updates/Release Notes for SCA PowerShell & Other Products
Given the latest release of SCA contains breaking changes due to Microsoft.Data.SqlClient version updates, it would be nice to have an RSS feed for updates to RedGate products, particularly those used in CI/CD pipelines like SQL Change Automation PowerShell commandlets.
This isn't possible to do through PowerShell gallery (e.g. https://www.powershellgallery.com/packages/SqlChangeAutomation/4.5.22279.31986) and changes are buried away in the Package Details section, nor through the release notes on RedGate's site (e.g. https://documentation.red-gate.com/sca/release-notes-and-other-versions/powershell-module-release-notes/sql-change-automation-powershell-4-5-release-notes). Some sort of heads up about changes would be nice rather than just finding broken pipelines.
3 votes -
Improve Performance - Invoke-DatabaseBuild - By removing powershell progressbar
I have discovered that too much information is being processed to simply display a percentage completed with the Invoke-DatabaseBuild command. I suspect other SQL Change Automation powershell commands are also utilizating the same behavior.
By turning the powershell progressbar off via the ps setting.
$ProgressPreference = "SilentlyContinue"
I improved a single database build performance:
From: 4 minutes -> To: 37 seconds.I suspect there's alot of data serialization and deserialization taking place within SQL Change Automation update progressbar code to do a simple progressbar reporting update.
This code within sql change automation needs to be looked at more closely to…
7 votes -
Add an option to filters.scpf to ignore filestream properties
In our development databases we never set the filestream property on any column.
On some production servers, our DBA turns filestream on for specific customers that store large blobs.
When we deploy a new version the filestream property gets removed.It would be great if an option could be added to the .scpf filters format to ignore the filestream property.
Currently we need to exclude tables that have columns with potential filestream properties as a workaround.
3 votes -
Add support for command line switches to the TeamCity plugin
The current TeamCity SQL Change Automation Sync plugin supports SQL Compare and SQL Data Compare options, which is great. What it does not support are SQL Compare and SQL Data Compare command line switches such as /exclude:table<tablename> or any of these switches listed in this documentation https://documentation.red-gate.com/sc/using-the-command-line/switches-used-in-the-command-line
So, if I have a requirement to exclude certain objects for certain environments then my only option currently is to run the actual commandline.exe instead of the using the plugin.
Please add two new fields to the TemCity plugin so I can enter the command line switches for my SQL Compare and SQL…
3 votes -
Add an option to exclude stub check scripts from the package script
We have to manually remove our stub check scripts from our package scripts on every build. Can you please add an option to automatically exclude stub check scripts?
6 votes -
SQL Change Automation (VS plugin): Select All/Deselect All object
I very often find myself making partial releases of the DB, and therefore most of my time I waste it selecting and deselecting the objects that I don't want to release.
Would it be possible to put a "Select All" / "Deselect All" in the migration objects windows?For me it would be a really necessary feature :-)
1 vote -
Change behaviur for $(DefaultDataPath) or add new SQLCMD variable that reflects the location of the primary ile group
The default script options for creating additional files and filegroups relies on the $(DefaultDataPath) variable. This value is given by the server.
But: if you are using SQL Clone, using this value, you get orphaned files when the clone is either dropped or reset.
If you place the files within the vhd of the clone however, reset and dropping the clone works as expected.
4 votes -
VS Code project
Hi,
I would like to see a VS Code project option, with a much easier to maintain project file, potentially even splitting configurations into separate settings files using yml or similar.
1 vote -
Produce code coverage from Azure Devops pipeline
When using the Redgate Change automation plugin for Azure DevOps pipelines, I wish to be able to run the tests AND produce the code coverage.
We can create the code coverage from SSMS, and it would seem to be available from Powershell, but it's not available from the Plugin.
We wish to expose this so that we can add a code coverage quality gate on Pull requests.
8 votes
Kendra
responded
The sqlcodeguard.exe command line may help with this request. The command line is in ‘preview’ mode and we value your further/continued feedback if you like the feature.
-
SQL Clone: Add a 2nd extended property to the clone databases with the image name
Currently when deploying clones from SQL Clone images, the database level extended property IsSQLCloneDatabase gets set to 1. It would be helpful to be able to see the image name the clone is created from.
This would allow for handling "sliding window" scenarios in terms of phasing out out-of-date images when you have a weekly image created in a graceful/programmatic way).
2 votes -
New SCA cmdlets to quickly provision new Projects
We have a very modular structure, with multiple SCA projects all targeting the same database. Each module can (and are) be independently releases. Each module in turn actually consists of 3 SCA projects, the Database Module Project, the Tsqlt Unit Test Project, and the Tsqlt Release Test project (smoke/regression/reconciliation tests).
it would be ideal to have cmdlets that lets us quickly create, in a programmatic way, projects with the settings we have for each of these (references, clone image baseline provisioning, semantic versioning, dataspace, migration log schema etc, filter file etc).
Include tsqlt files in test projects would be a…
1 vote -
Handle system named column default constraints when importing and generating scripts
When maintaining a database, like to assign names to unnamed default constraints. However, generated script only works if the target database has identically named "unamed" default constraints.
To add robustness to the script, I modify these to a short snippet that works on the schema+table+column. (Using a snippet in SQL Prompt to speed the process :)
But why do I need to do this - after all it is replacing machine generated code?
Here is the SQL Prompt snippet I use:1 vote -
add generate migrations automation commands/options in SCA VS plugin
when working on a VS project that includes a SCA project it would be useful to allow the developer to "automate" the capturing of changes in their development database (e.g. connection string that is defined in the sqlproj.user file) through some form of automation either as:
- part of a local build step (for example where a EF Core project has created and applied database a migration to a development database) that automatically generates and adds the new migration script to the SCA project; or
- is triggered as part of a git pre-check-in command (e.g. SCA PowerShell?)It would…
1 vote -
Enhance Hybrid Model to support automatic creation of static data migration scriptsts
When the Hybrid Model is used (where state-based changes are managed using SQL Source Control) and SQL Change Automation draws from SSC as its Development Source, it would be great if SQL Change Automation could detect changes to static data scripts in SSC and automatically create migrations for them. As it stands, the SCA user must manually code those migration scripts. Not a huge deal, but it would seem like a natural capability to add to the Hybrid Model given the way it already nicely handles structural (aka DDL) changes made in SSC.
1 voteWhile this item isn’t specifically on our roadmap at this time, we have plans to improve and evolve the hybrid model in our offerings in 2021, and this will be a good candidate for consideration.
-
Create a branch based on one of the available annotated tags
Our Create a hot fix procedure is:
- Create and get a bug fix into master using the procedures for making changes
- Create a local hot fix branch from current/test or current/production annotated tag
- Cherry pick bug fix commit(s) from master to the local hot fix branch
- Run a full build, all automated tests, and all migrations
- Push the local hot fix branch to the remote repository
- Build & release pipelines are triggered
This procedure will help prevent regressions due to developers forgetting to merge hot fixes to master.
This feature request relates to step 2. The CI/CD release pipeline will…
1 vote -
new-databaseDocumentation: add filetype parameter
The sqldoc executable has a filetype parameter that allows you to change the generated documentation's file type. Could you add the filetype parameter to the new-databaseDocumentation cmdlet to enable flexibility on the documentation type that is inside the build artifact? I realize that I could probably build the documentation on my own via the sqldoc command line, but I feel like if I'm going to just use the individual command lines it defeats the purpose of the module! Based on the initial pass I took through the schemaDocumentation object structure - I am optimistic that this is a reasonable ask.…
10 votes -
Consider using shorter names for localdb name
The name for localdb appears to be sqlchangeautomation_ + a guid. I'm using Azure Devops deployment using sql change automation, when I use an agent name that is longer than 4 characters and use localdb in the build, I get an error message that states there is a path error. The generated localdb name is in the pattern sqlchangeautomation_ + a guid. This causes by builds to fail because part of the path is longer than 256 characters when the product is putting the necessary object into the user temp directory. if the pattern for generating…
3 votes -
SSMS Plugin should warn if user clicks push before committing any changes.
Using the SCA SSMS plugin, the Version Control tab makes it very clear that you need to click "Push", but not so clear that you should commit changes before pushing. It would be helpful if it warned that you haven't commiited anything rather than just quietly saying "Push Successful".
1 vote -
Flag to Force a deployment
Occasionally the only changes in a specific build is the addition to the PostScript post-deployment script. Since there are no schema changes, the PostScript change is not executed.
Faking a schema change by adding a comment or something is a poor workaround in an automated CI process.
A simple flag -AlwaysRunUpgrade to always run the PreScript and PostScript as part of the deployment would be ideal.
17 votesFor clarification for readers, this request is specific to SQL Source Control projects which are deployed by SQL Change Automation. Comments in the item give more detail.
- Don't see your idea?