My Oracle Support Banner

MS SQL Server 2012 Migration To Oracle Database 12c Using Sql Developer (Doc ID 2289564.1)

Last updated on MAY 11, 2022

Applies to:

Oracle SQL Developer - Version 4.2.0 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Attempting to migrating MS SQL Server 2012 (hosted on MS Windows 2012 64-bit) server to Oracle database 12c (hosted on  Linux 6.4 x86-64 Bit) using Oracle SQL developer (Version 4.2.0.17.089 + JDK 1.8.0_121) and following steps from link "http://www.oracle.com/technetwork/database/migration/sqlserver-095136.html".

You have installed/attached a sample database (Adventureworks2012) in MS-SQL server 2012 and created a migration repository user in Oracle for this migration.
All the steps/phases for migration run well and you don't see any data getting populated/inserted into Oracle database respective .



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.