Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I've recently installed SSMA on my computer and after connecting to both the Oracle instance (which holds the database to be converted) and the SQL Server. I've mapped the needed schemas from oracle to mssql. The problem is that when i click on the report button for the assessment report there's an error popping up:

Assesment Error : Nothing to Process

The output window states:

Starting conversion... Analyzing metadata... Conversion finished with 0 errors, 0 warnings, and 0 informational messages. There is nothing to process.

Has anyone got experience with SSMA. I can't figure out what I am doing wrong.

Thank you.

share|improve this question
add comment

3 Answers

I would recommend you to use SQL Profiler (there should be such tools for Oracle too, we used Toad for Oracle) and see what queries SSMA executes to Oracle and MS SQL databases and what exceptions happen there ...

There are number of reasons why a tool can fail - in the past we used 3rd party migration tool that could fail if databases have different encodings (collations) especially when master SQL database was made CASE sensitive ... Though, I have no experience with SSMA, I would suggest that SQL profiling could give you a clue.

share|improve this answer
    
Thanks for the answer. As a last resort, i'll use SQL Profiler to see what exactly is SSMA executing. –  Paul Jun 23 '09 at 6:09
add comment

Just guessing here.... what user are you logging into Oracle with? Sounds a bit like there could be some permissions issues.

You are trying to convert to SS 2005, right?

share|improve this answer
    
system - isn't this user the equivalent of "sa" on SQL ? –  Paul Jun 22 '09 at 14:32
    
system should work. told you it was just a guess ;-) –  DCookie Jun 22 '09 at 16:15
add comment

You have to synchronize your SqlServer Db (to persist new schema etc). Right click on your db in "Sql Server Metadata Explorer", from context menu click synchronize with database. Tool has a convention that requires same db name on your actual sql server. This is the situation in version 4.2. I hope it helps.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.