Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. You cannot use Convert Schema or Migrate data options for objects created in System schema in SSMA

You cannot use Convert Schema or Migrate data options for objects created in System schema in SSMA

Symptoms

If you create tables and other objects under Oracle's System schema, you are not able to migrate these objects to SQL Server using either Convert Schema or Migrate Data options in SQL Server Migration Assistant for Oracle. These two options are grayed out for System schema.

↑ Back to the top

Cause

This behavior is by design. SSMA considers all the objects in SYS and SYSTEM schemas as system objects. SSMA does not migrate any objects that are considered as System objects.

↑ Back to the top

Resolution

Create objects in another schema and the use SSMA to migrate those objects to SQL Server.

↑ Back to the top

Keywords: vkball, kb

↑ Back to the top

Article Info
Article ID : 2020714
Revision : 1
Created on : 1/8/2017
Published on : 10/4/2010
Exists online : False
Views : 102