Function tearDownMSSQL

packages/migrate/src/utils/setupMSSQL.ts:53–64

(options: SetupParams, databaseName: string)

}

export async function tearDownMSSQL(options: SetupParams, databaseName: string) {
  const { connectionString } = options
  const config = getMSSQLConfig(connectionString)
  const connectionPool = new mssql.ConnectionPool(config)
  const connection = await connectionPool.connect()

  await connection.query(`
DROP DATABASE IF EXISTS "${databaseName}-shadowdb";
DROP DATABASE IF EXISTS "${databaseName}";
`)
  await connection.close()
}