Drizzle TeamDT
Drizzle Team2y ago
2 replies
Jarrett

Migrating a local Cloudflare D1 database

I have a Cloudflare Worker with a few environments and databases. I've figured out how to migrate my staging and prod databases via this guide: https://orm.drizzle.team/learn/guides/d1-http-with-drizzle-kit.

What I want to do now, is also run those migrations on my local database. This script allows me to access my local database, for example: yarn run wrangler d1 execute staging_db_1 --env=dev --local --file=./drop_tables.sql.

How can I invoke drizzle-kit commands to run against my local database? I've tried removing the driver and dbCredentials values from the config in drizzle.config.ts, but I get Error Please provide required params: [x] url: undefined. I don't konw what URL I'd be expected to use if I'm drizzle-kit migrating a local database.
Was this page helpful?