Settings and activity
6 results found
-
29 votesnycdotnet supported this idea ·
-
7 votesnycdotnet shared this idea ·
-
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…
nycdotnet supported this idea · -
1 votenycdotnet shared this idea ·
-
27 votes
An error occurred while saving the comment nycdotnet supported this idea · -
9 votes
An error occurred while saving the comment nycdotnet commentedIf the "Filters" option shows up on the "Get Latest" tab, please consider putting some sort of warning on checking in items on the "Commit Changes" tab that would no longer be in scope if the latest filter were applied. Thank you!
I commonly have a local SQL DB and a DB on my dev SQL server with the same name - it would be great if the gray text in the upper-right of the Commit Changes, Get Latest, and Setup windows would show the servername of the database that I am currently examining.