Monday, August 3, 2009

Unable to migrate Oracle to case sensitive SQL Server 2005

Symptom

User may face problems when using SSMA to convert Oracle to case-sensitive SQL Server

Cause

SSMA does not support migration to case-sensitive SQL Server instance.

Resolution

Even though SSMA does not support migration to case-sensitive SQL Server, it may be used during migration though. Using SSMA is highly recommended because this way amount of manual work will be reduced significantly comparing it to migration without usage of SSMA.

More Information

Article Id: KBO2SS1005

Applies to

SSMA 2005 for Oracle

SSMA 2008 for Oracle

No comments:

Post a Comment