SSMA Console — Migração de Oracle para SQL Server

Gere configurações XML e invoque SSMAforOracleConsole.exe diretamente — sem scripts ou wrappers externos.

Operações (execute em ordem para "migração completa"):

1. create-project — conecte origem e destino, mapeie o esquema
2. generate-report — relatório de avaliação
3. migrate-schema — converta e implante o esquema
4. migrate-data — converta, implante, migre dados de ponta a ponta

Coletar Entradas

Peça por parâmetros ausentes. Padrões entre parênteses.

Oracle: Host (localhost), Porta (1521), Instância (obrigatório, nome do serviço), Usuário, Senha, Esquema SQL Server: Servidor, Banco de Dados, Usuário, Senha, Criptografar (true), Confiar Certificado do Servidor (true), Esquema de Destino (dbo) Projeto: Nome (ssma-migration), Pasta (.), Tipo (sql-server-2022 — também 2016/2017/2019/2025/sql-azure), Caminho SSMA (C:\Program Files\Microsoft SQL Server Migration Assistant for Oracle\bin\SSMAforOracleConsole.exe)

Gerar Arquivos XML

Resolva TODOS os tokens {PLACEHOLDER} antes de escrever. Gere 3 arquivos:

ssma-variables.xml

<?xml version="1.0" encoding="utf-8"?>
<variables>
  <variable name="$WorkingFolder$" value="{PROJECT_FOLDER}" />
  <variable name="$ProjectType$" value="{PROJECT_TYPE}" />
  <variable name="$ProjectName$" value="{PROJECT_NAME}" />
  <variable-group name="OracleConnection">
    <variable name="$OracleHostName$" value="{ORACLE_HOST}" />
    <variable name="$OracleInstance$" value="{ORACLE_INSTANCE}" />
    <variable name="$OraclePort$" value="{ORACLE_PORT}" />
    <variable name="$OracleUserName$" value="{ORACLE_USER}" />
    <variable name="$OraclePassword$" value="{ORACLE_PASSWORD}" />
    <variable name="$OracleSchemaName$" value="{ORACLE_SCHEMA}" />
  </variable-group>
  <variable-group name="SQLServerConnection">
    <variable name="$SQLServerName$" value="{SQL_SERVER}" />
    <variable name="$SQLServerDb$" value="{SQL_DATABASE}" />
    <variable name="$SQLServerUsrID$" value="{SQL_USER}" />
    <variable name="$SQLServerPwd$" value="{SQL_PASSWORD}" />
  </variable-group>
  <variable-group name="ReportSettings">
    <variable name="$SummaryReportFile$" value="Reports\Assessment\AssessmentReport.xml" />
    <variable name="$ConversionReportFile$" value="Reports\Conversion\ConversionReport.xml" />
    <variable name="$ConversionReportFolder$" value="Reports\Conversion" />
    <variable name="$DataMigrationReportFile$" value="Reports\Migration\DataMigrationReport.xml" />
    <variable name="$SynchronizationReportFolder$" value="Reports\Synchronization" />
  </variable-group>
</variables>

ssma-servers.xml

CRÍTICO: Use tns-name-mode — standard-mode trata a instância como SID e falha com ORA-12505.

<?xml version="1.0" encoding="utf-8"?>
<servers>
  <oracle name="source_oracle">
    <tns-name-mode>
      <connection-provider value="OracleClient" />
      <service-name value="(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = $OracleHostName$)(PORT = $OraclePort$)))(CONNECT_DATA =(SERVICE_NAME = $OracleInstance$)))" />
      <user-id value="$OracleUserName$" />
      <password value="$OraclePassword$" />
    </tns-name-mode>
  </oracle>
  <sql-server name="target_sqlserver">
    <sql-server-authentication>
      <server value="$SQLServerName$" />
      <database value="$SQLServerDb$" />
      <user-id value="$SQLServerUsrID$" />
      <password value="$SQLServerPwd$" />
      <encrypt value="{ENCRYPT}" />
      <trust-server-certificate value="{TRUST_CERT}" />
    </sql-server-authentication>
  </sql-server>
</servers>

XML do Script de Operação

Gere um script por operação. Todos os scripts compartilham este bloco <config> comum (adicione <object-overwrite action="overwrite" /> para migrate-schema/migrate-data, adicione <data-migration-connection source-use-last-used="true" target-server="target_sqlserver" /> para migrate-data, use o progresso every-5% para operações de esquema/dados):

<config>
  <output-providers>
    <output-window suppress-messages="false" destination="stdout" />
    <upgrade-project action="yes" />
    <user-input-popup mode="continue" />
    <progress-reporting enable="true" report-messages="true" report-progress="every-10%" />
    <log-verbosity level="info" />
  </output-providers>
</config>

Todos os scripts começam com este preâmbulo em <script-commands>:

<create-new-project project-folder="$WorkingFolder$" project-name="$ProjectName$"

…