Settings and activity
6 results found
-
4 votes
Kieron O'Connor
supported this idea
·
-
11 votes
Kieron O'Connor
supported this idea
·
-
13 votes
Kieron O'Connor
supported this idea
·
-
58 votes
An error occurred while saving the comment
Kieron O'Connor
supported this idea
·
-
10 votes
Thanks for this feedback and for the votes for this suggestion.
For users who need to manage larger volumes of static data, we currently recommend versioning the database with SQL Change Automation. SQL Change Automation has stronger support for static data:
- Supports column filtered static data tables in the SCA plugin in SSMS
- Supports multiple post-deployment scripts, in case there is a preference to manage static data tables in dedicated post-deployment scripts
- Allows approaches like bulk loading larger static data tables by supporting SQLCMD variables in migration and post-deployment scripts
I do understand that you are looking for this feature in SQL Source Control, but wanted to surface this option for other readers who may be interested in either tool.
Kieron O'Connor
supported this idea
·
-
633 votes
Hi,
We just added this capability to Flyway, which is our x-database, x-OS cloud- and Git-first Database DevOps solution for versioning and deploying database changes. You can learn more about this feature in Flyway at https://documentation.red-gate.com/fd/working-with-data-138347109.html#Workingwithdata-Controllingstaticdata.
You can also import your SQL Source Control repos into Flyway while keeping your Git history. Learn more about moving to Flyway and importing your project at https://documentation.red-gate.com/fd/transitioning-from-other-redgate-tools-164167855.html.
If you have any questions, please comment below or reach out to us at DatabaseDevOps@red-gate.com.
Thank you!
Stephanie Herr
Product Manager - Database DevOps
Kieron O'Connor
supported this idea
·
This also causes a problem if you use the gated checkin feature in TFS. When you have to reconcile the changes, it asks you to pick a workspace. This would normally be fine but 12 local databases source controlled.