node-sql-migrate
v1.1.0
Published
An sql migration tool
Downloads
4
Maintainers
Readme
SQL Migrate
This is a very basic migration tool used to sync tables between environments (eg, production, staging, development).
Make sure you set your environment variable (process.env.NODE_ENV.
How to Use
- Install npm package:
npm i node-sql-migrate
- Create a folder
SQL
in the root of your Node.js application. - Create another folder
migrations
. This is where you will store your migration files. - Inside the
migrations
folder, create files1-migrate.sql
,2-migrate.sql
and so on. Do not redo previous migration files.