Follow

Tag: Migration

FluentMigrator for Database Migration

Posted on June 15, 2018 by in Database

Introduction

In this blog, we’ll be looking at FluentMigrator, a database migration framework provided by .NET. FluentMigrator is a C# based framework which can be used to migrate databases, be it, creating or updating or dropping database tables OR creating stored procedures, triggers, functions OR inserting data into tables.

It can be set up in a project by installing the framework in IDE. Migration files have to be created which holds the schema for database migration.

Schema Migration in CakePHP 3.x

Posted on April 17, 2017 by in PHP Solutions

Introduction

In this blog, we’re going to look at the purpose of the schema migration tool provided by CakePHP and the benefits of using it in our project(s).

What does it do

CakePHP provides a plugin called migration which is supported by the core team. This plugin is a wrapper for the database migrations library Phinx.

Using a migration file we can create or drop tables, add or remove columns, create indexes and even insert data into our database. A migration file contains PHP script which handles our schema.