Our great sponsors
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
Personally I prefer to use FluentMigrator to schema modification data load.
all the update logic executed in UpdateDatabase method, which calls FluentMigrator’s runner which performs all migrations’ Up method. Entire code you can find here.
In contrast to pure SQL scripting popular are migration projects like Liquibase or FlyWay in Java world or Entity Framework Migrations in .NET. It is convenient to define subsequent database changes in XML, YAML or in code and store it in repository, while the migration framework will keep an eye on execution and versioning of appropriate database changes. Also it is handy during CI/CD process configuration.
In contrast to pure SQL scripting popular are migration projects like Liquibase or FlyWay in Java world or Entity Framework Migrations in .NET. It is convenient to define subsequent database changes in XML, YAML or in code and store it in repository, while the migration framework will keep an eye on execution and versioning of appropriate database changes. Also it is handy during CI/CD process configuration.