SQL Server as Target

SQL Server is a migration target for every supported source (Oracle, PostgreSQL, SQL Server, Netezza). MigratorXpress translates source column types to SQL Server types, creates the target schema, streams data via FastTransfer, and can apply Clustered Columnstore Index (CCI) or archive compression based on row-count thresholds.

For the complete connection reference and troubleshooting, see the canonical SQL Server page.

Target-specific Permissions

-- Grant permissions for schema creation and data loading
GRANT CREATE TABLE TO migratorxpress_user;
GRANT ALTER ON SCHEMA::dbo TO migratorxpress_user;
GRANT INSERT ON SCHEMA::dbo TO migratorxpress_user;
GRANT UPDATE ON SCHEMA::dbo TO migratorxpress_user;
GRANT DELETE ON SCHEMA::dbo TO migratorxpress_user;

Target-specific CLI Options

Option	Purpose
--cci_threshold N	Create a Clustered Columnstore Index when a table has at least N rows (default 1,000,000)
--aci_threshold N	Apply archive compression when a table has at least N rows (default 100,000,000)
--fk_mode {disabled,untrusted,trusted}	Foreign-key enforcement strategy for copy_fk (Oracle, PostgreSQL and SQL Server sources)

Example Auth Entry

{
  "mssql_target": {
    "ds_type": "mssql",
    "auth_mode": "classic",
    "info": {
      "username": "migrator",
      "password": "********",
      "server": "sql-target.company.com",
      "port": 1433,
      "database": "TargetDB"
    }
  }
}

Reference it on the command line with --target_db_auth_id mssql_target. A target entry can also use auth_mode connection_string or trusted, but not odbc (see Authentication modes).

See Also

• SQL Server -- full connection reference
• Database Connections -- auth file format and security