Function getMSSQLConfig

packages/migrate/src/utils/setupMSSQL.ts:10–26

(url: string)

  dirname: string
}
function getMSSQLConfig(url: string): mssql.config {
  const connectionUrl = new URL(url)
  return {
    user: connectionUrl.username,
    password: connectionUrl.password,
    server: connectionUrl.hostname,
    port: Number(connectionUrl.port),
    database: connectionUrl.pathname.substring(1),
    pool: {
      max: 1,
    },
    options: {
      enableArithAbort: false,
      trustServerCertificate: true, // change to true for local dev / self-signed certs
    },
  }
}

export async function setupMSSQL(options: SetupParams, databaseName: string): Promise<void> {
  const { connectionString } = options