Is it possible to identify modifications in a pg db and extract/pull them as a new migration file?
Here is the situation I am referring to:
1. When I run
drizzle-kit introspect:pg for the first time, it generates 0000 migration.
2. A new table called my_new_table is created using native pg (without ORM).
3. (I wish to) When I run drizzle-kit introspect:pg for the second time, it generates a 0001 migration with my_new_table included.1 Reply
It is possible but with 2 steps:
1-
drizzle-kit introspect:pg to update the schema (js/ts, not sql)
2- drizzle-kit generate:pg to generate the migration