DT
Drizzle Team•16mo ago
Avery

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()
No description
1 Reply
Wendelstein
Wendelstein•13mo 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.

Did you find this page helpful?