Settings and activity
6 results found
-
636 votes
Hi everyone. I have merged some User Voice items on this topic of “filtered” static data, as there was significant overlap. I want to share our current guidance on handling scenarios where you need to version a subset of the columns and/or rows in the table.
With SQL Source control, the best option at this point is to use a post-deployment script for this purpose.
SQL Source Control introduced pre- and post- scripts in v6.3.
A post-deployment script gives you a good amount of flexibility over exactly which rows or columns of data you want to include in your project. Example post-deployment scripts for static data are here: https://documentation.red-gate.com/soc7/common-tasks/working-with-pre-post-deployment-scripts/static-data
If you make heavy use of Static Data, we have stronger support for this in SQL Change Automation.
SQL Change Automation:
- Supports column filtered static data tables in the SCA plugin in SSMS
- Supports multiple post-deployment scripts, in case there is…
Chattabaugh supported this idea · -
9 votesChattabaugh shared this idea ·
-
39 votes
An error occurred while saving the comment An error occurred while saving the comment Chattabaugh commentedWe have shared development environments that can be used by multiple projects at the same time. When someone works on more than one project they must unlink and link Source control to the different branches. The Process can take upwards of 20-30 minutes to link some of our databases.
Chattabaugh shared this idea · -
131 votesChattabaugh supported this idea ·
-
89 votes
We’re currently not planning to support this for v1. Would you be ok to remove the $id$ keyword for now?
We’ll have to see how many votes this suggestion gets…
Internal reference number: SOC-113
-
16 votes
Link database to source control takes over 20 minutes of a DB with 3000 objects (mostly SPs)
Clicking on Commit Changes to Source Control can take equally as long or longer