Migrating Oracle 10g to SQLServer 2016 by SSMA for Oracle

・ sql-server-2016.pdf?8618

Situation

  • Oracle 10.2.0.3 32bit
  • SQLServer 2016

Migrate database

  1. Download and install SSMA for Oracle.
  2. Create report.
  3. Validate data types.
  4. Convert schema.
  5. Synchronize with Database.
  6. Migrate Data.

Errors

SSMA 连接 Oracle 10.2.0.3 数据库时出现如下报错：

ORA-01017 Invalid Username/Password; Logon Denied

ssma-ora-01017

Workaround:

采用连接串方式，可正常连接。

Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.3.7)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=IPMSPROD)));User Id=SYSTEM;Password=oracle;

ssma-csmode