Migration Errors

Hi all,
i am trying to make a migration to a database in Turso using drizzle.
However i am blocked in two issues.
- The first is because when i do some changes on the schema the major of the times the migration presents the following message: " SQLite does not support xxxx out of the box, we do not generate automatic migration for that, so it has to be done manually"
- The second one is when i try to apply the migration i got stuck in these errors: SQL_MANY_STATEMENTS or SQL_EMPTY_STATEMENTS

this is my drizzle.config.ts

import { defineConfig } from 'drizzle-kit'

export default defineConfig({
    schema: './src/admin/index.ts'
    out: './drizzle/admin'
    dialect: 'sqlite',
    driver: 'turso',
    dbCredentials: {
        url: process.env.TURSO_URL
        authToken: process.env.TURSO_GROUP_DB_KEY,
    },
})

import { defineConfig } from 'drizzle-kit'

export default defineConfig({
    schema: './src/admin/index.ts'
    out: './drizzle/admin'
    dialect: 'sqlite',
    driver: 'turso',
    dbCredentials: {
        url: process.env.TURSO_URL
        authToken: process.env.TURSO_GROUP_DB_KEY,
    },
})

Thanks in advance for your help.

Drizzle Team•2y ago

sergiompc12

Migration Errors

import { defineConfig } from 'drizzle-kit'

export default defineConfig({
    schema: './src/admin/index.ts'
    out: './drizzle/admin'
    dialect: 'sqlite',
    driver: 'turso',
    dbCredentials: {
        url: process.env.TURSO_URL
        authToken: process.env.TURSO_GROUP_DB_KEY,
    },
})

import { defineConfig } from 'drizzle-kit'

export default defineConfig({
    schema: './src/admin/index.ts'
    out: './drizzle/admin'
    dialect: 'sqlite',
    driver: 'turso',
    dbCredentials: {
        url: process.env.TURSO_URL
        authToken: process.env.TURSO_GROUP_DB_KEY,
    },
})

Thanks in advance for your help.

Migration Errors

Similar Threads

Migration Errors

Similar Threads

Similar Threads

Similar Threads