Drizzle Team•12mo ago

migrate isn't applying the latest migration sql file

Hi, I made some changes to one of our schemas and I ran drizzle-kit generate to create the new migration sql file. However, when I ran the migrate script, it doesn't seem to be applying the migration. Any ideas what could be wrong? Our migrate file looks like this

async function run() {
  const queryClient = postgres(process.env.DATABASE_URL, { max: 1 });

  const db = drizzle(queryClient, { schema });

  await migrate(db, { migrationsFolder: './drizzle' });

  await queryClient.end();
}
run()

async function run() {
  const queryClient = postgres(process.env.DATABASE_URL, { max: 1 });

  const db = drizzle(queryClient, { schema });

  await migrate(db, { migrationsFolder: './drizzle' });

  await queryClient.end();
}
run()

1 Reply

Wendelstein•9mo ago

Hi, did you delete migrations manually at some point? I had a similar issue and for me it helped to also drop the drizzle schema in the database after I have manually deleted everything from my migrations folder.

Gaming

Programming

migrate isn't applying the latest migration sql file