Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 2020715 - Last Review: October 4, 2010 - Revision: 1.0
You are not able to migrate your Oracle or Sybase databases to a case-sensitive SQL Server database using SSMA
When you try to migrate your Oracle or a Sybase database to a case-sensitive database on SQL Server using either SQL Server Migration Assistant for Oracle or SQL Server Migration Assistant for Sybase you may run into various error messages.
SSMA does not fully support the migration of source databases to a case-sensitive database on SQL Server.1 Failures originating from case-sensitivity issues need to addressed manually. For example, if the schema contains two names with the same name but only differs in casing, SSMA results in errors that can be addressed manually by making the object names unique. Though full support of case-sensitive database does not exist in SSMA, users can still benefit from using the tool when there are no conflicts. Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See
Terms of Use
(http://go.microsoft.com/fwlink/?LinkId=151500)
for other considerations.
APPLIES TO
- Microsoft SQL Server 2005 Developer Edition
- Microsoft SQL Server Migration Assistant 2005 for Sybase ASE v4.0
- Microsoft SQL Server Migration Assistant 2005 for Oracle v4.0
- Microsoft SQL Server Migration Assistant 2008 for Oracle v4.0
- Microsoft SQL Server Migration Assistant 2008 for Sybase ASE v4.0
- Microsoft SQL Server 2008 Developer
- Microsoft SQL Server 2008 R2 Developer
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate