NodeJS application database versioning and data migration

Question

I am planning to use Postgres as my database and sequelize as my ORM framework one of my NodeJS project. I need your suggestion on how to accomplish database table changes in production enviroment.

For example , we deployed our version-1 application with some database schema. Later , there is a change in my schema in Version-2. Say one of the table is altered and few columns are dropped and few columns are added. Also one of the table itself is not required in Version-2.

In my production , I have some database with data. When I install Version-2 of my NodeJS application , I need to keep the old data as it is and apply the new database schema of Version-2.

How to achieve this , Let me point out some reference to this.

Thanks

Callum · Accepted Answer · 2018-07-30 07:27:55Z

1

Sequelize (or rather, sequelize-cli) has built in support for migrations.

You can write migrations using the Sequelize js api (e.g. queryInterface.dropColumn('users', 'address')) or write raw SQL and pass it to sequelize.query()

edited Jul 30, 2018 at 7:27

Callum

1,0142 gold badges12 silver badges18 bronze badges

answered Oct 20, 2016 at 17:57

Tom Jardine-McNamara

2,61816 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

JavaUser Over a year ago

Do I need to write my own script file to handle this case . "Sequelize" won't do it automatically?

Tom Jardine-McNamara Over a year ago

If you have sequelize-cli installed you can have it generate migration skeletons for you (run sequelize db:migration:create) which you then modify to make the required database changes - is that what you're looking for?

JavaUser Over a year ago

Yes I want a kind of solution which auto generate migration script using the sequelize data model. Can you point me some reference page or suggest some solution?

Tom Jardine-McNamara Over a year ago

I see what you mean now. I would also like to generate migrations from model definitions, but unfortunately it's not possible! Take a look at stackoverflow.com/questions/27835801/… for some workarounds and advice

Collectives™ on Stack Overflow

NodeJS application database versioning and data migration

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related