DT
Drizzle Team•4d ago
Cole

Seed local SQLite database from Remote D1 data?

Hi Drizzle team, I've been doing some basic testing of D1 with Drizzle and I've added some data to my remote D1 instance with Drizzle Studio. I see that the updated data is in my remote D1. However, when I migrate and run wrangler dev, I don't see my data in local. What am I missing?
1 Reply
dax70
dax70•4d ago
I had a similar issue and solved it by updating both npm scripts and drizzle-dev.config.ts Here is the code relevant code. 
"db:seed": "LOCAL_DB_PATH=$(find .wrangler/state/v3/d1/miniflare-D1DatabaseObject -type f -name '*.sqlite' -print -quit) tsx -r dotenv/config ./drizzle/seed.ts",
"db:seed": "LOCAL_DB_PATH=$(find .wrangler/state/v3/d1/miniflare-D1DatabaseObject -type f -name '*.sqlite' -print -quit) tsx -r dotenv/config ./drizzle/seed.ts",
import type { Config } from "drizzle-kit";

// Example of a local database path

const LOCAL_DB_PATH = process.env.LOCAL_DB_PATH;

export default LOCAL_DB_PATH
  ? ({
      out: "./drizzle",
      schema: "./database/schema.ts",
      dialect: "sqlite",
      dbCredentials: {
        url: LOCAL_DB_PATH,
      },
    } satisfies Config)
  : ({
      out: "./drizzle",
      schema: "./database/schema.ts",
      dialect: "sqlite",
      driver: "d1-http",
      dbCredentials: {
        databaseId: "YOUR_DB_ID,
        accountId: process.env.CLOUDFLARE_ACCOUNT_ID!,
        token: process.env.CLOUDFLARE_TOKEN!,
      },
    } satisfies Config);
import type { Config } from "drizzle-kit";

// Example of a local database path

const LOCAL_DB_PATH = process.env.LOCAL_DB_PATH;

export default LOCAL_DB_PATH
  ? ({
      out: "./drizzle",
      schema: "./database/schema.ts",
      dialect: "sqlite",
      dbCredentials: {
        url: LOCAL_DB_PATH,
      },
    } satisfies Config)
  : ({
      out: "./drizzle",
      schema: "./database/schema.ts",
      dialect: "sqlite",
      driver: "d1-http",
      dbCredentials: {
        databaseId: "YOUR_DB_ID,
        accountId: process.env.CLOUDFLARE_ACCOUNT_ID!,
        token: process.env.CLOUDFLARE_TOKEN!,
      },
    } satisfies Config);

Did you find this page helpful?