Add option for a dry run

[sankethkatta]

Some other migration frameworks such as node-db-migrate offer a --dry-run option. This simply prints out all the SQL statements that would be run, but does not actually touch the database.

This can be a very useful check prior to running a migration on a database with real data. It also can be a bit of a sanity checker, unlike normal database queries, migrations are difficult to write tests for. So this would also allow developers to actually verify that their migration file runs, without running it.

I'd be happy to work on a PR with some direction on where to get started, would this involve changes in Sequelize?

[larslbert]

+1

[shamoons]

+1

[rayder441]

+1

[w43l]

+1

[andrew-makarenko]

+1

[iagomls]

+1

[vmadman]

+1

There has to be a way to do this, now, I'd think. Even if it's not officially supported, it would seem as though you could call a few private methods or, something, to get the query generation without the execution. Either way, I'll look into it, but wanted to register my +1 anyway.

[vadivelselvaraj]

+1

[damianobarbati]

+1

[madshell]

+1

[webjaros]

+1

[webjaros]

+1

[mk7upurz87]

+1

[miahorg]

+1

[robert-krikey]

+1,000

[letsspeak]

+1

[smddzcy]

+1

This is definitely a necessary feature.

[vbabak]

And put db:sync --dry-run into sequelize-cli as option!

[mrdulin]

Also need option for sync() API like this: sequelize.sync({ dry: true, force: true });

[frederikhors]

Please some workaround for this?

[ZQ-jhon]

Is there any latest news?

[ghyath5]

What is the status here ???? From 2015 until noooww !

[20kaushik02]

Bumping for more attention!!!