[v5] Can't change migration table location on MSSQL. It is always under master

[guntribam]

When running node ace migration:run i am getting this error:

CREATE TABLE [CONTAS].[dbo].[MIGRATION_VERSION_CONTROL] ([id] int identity(1,1) not null primary key, [name] nvarchar(255) not null, [batch] int not null, [migration_time] datetime2 CONSTRAINT [contas].[dbo].[migration_version_control_migration_time_default] DEFAULT CURRENT_TIMESTAMP) - Incorrect syntax near '.'.

this is my migration config:

migrations: {
        naturalSort: true,
        tableName: 'CONTAS.dbo.MIGRATION_VERSION_CONTROL',
        paths: Env.get('RUN_LOCALHOST_MIGRATIONS')
          ? ['./database/migrations/localhost', './database/migrations/production']
          : ['./database/migrations/production'],
        disableRollbacksInProduction: true
      }

If i remove CONTAS.dbo. it will create under master db, when i need under CONTAS db.

Any clues?

[guntribam]

you just need to specify you database

connection: {
        ...(Env.get("MSSQL_DOMAIN") && {type: "ntlm", domain: Env.get("MSSQL_DOMAIN")}),
        server: Env.get("MSSQL_SERVER") ,
        port: Env.get("MSSQL_PORT"),
        database: Env.get("MSSQL_APP_DB_NAME") ,  //this was missing, so it connected to MASTER all the time
        user: Env.get("MSSQL_APP_DB_USER"),
        password: Env.get("MSSQL_APP_DB_PASSWORD"),
        options: {
            ...(Env.get("MSSQL_INSTANCE") && {instanceName: Env.get("MSSQL_INSTANCE")}),        
            trustServerCertificate: true
        }