Product articles Redgate Flyway Static data

  • Flyway
  • Desktop Development
  • Static data

Automatically Tracking and Deploying Static Data in Flyway Enterprise

Static data is often required for the basic functioning of a database and any dependent applications. Therefore, it's vital that we can track this static data to understand how, when, and why it changed, and that we include any static data changes in our database deployments. Flyway Enterprise will now do both tasks automatically. Read more

  • Flyway
  • Static data
  • Database Versioning
  • Cross-RDBMS

Managing Static Data in Flyway Database Development

If your database application requires 'static data' to function, then the best way to manage that data is using a view based on a derived table. This article demonstrates ways to create these views, depending on your RDBMS's capabilities, and how to build and manage them in development work, using Flyway and PowerShell. Read more

Topics

  • Applying hotfixes
  • Audit and Compliance
  • Automated Deployment
  • Automation and workflow
  • CI pipelines
  • CLI basics
  • Callbacks and placeholders
  • Cloud
  • Code quality checks
  • Configuration, Authentication
  • Data privacy and protection
  • Database Branching and Merging
  • Database Build tasks
  • Database Builds and Deployments
  • Database Dependencies
  • Database Deployments
  • Database DevOps
  • Database Documentation
  • Database Testing and Quality
  • Database Versioning
  • Database migrations
  • Deployment checks and safeguards
  • Desktop Development
  • DevOps collaboration
  • Flyway Commands
  • Generating Realistic Test Data
  • Generating migrations
  • Integrating with Flyway
  • Multidatabase management
  • Performance Testing
  • Rollback strategies
  • Source Control
  • Static data
  • Team-based Development
  • Test Data Management
  • Testing migration scripts
  • Tracking development changes
  • Undo migrations
  • Unit and integration testing
  • Variants, Localization

Database types

  • Cross-RDBMS
  • SQL Server

Filter by level

Redgate Hub

  • Product Articles

    Product Articles

    Tips and how-to guides for Redgate products

  • University

    University

    Easy to follow video courses

  • Events

    Events

    Join us online, or get sponsored

  • Forums

    Forums

    Ask, discuss, and solve questions about Redgate's tools

  • Community

    Community

    Develop your skills and meet Redgate Advocates and Friends

  • Simple Talk

    Simple Talk

    In-depth articles and opinion from Redgate's technical journal