When opening the SQL Server Migration Assistant for Oracle SQL Server
instance for conversion it gives me the following error: "SSMA could not
retrieve the extension pack SSMA4OracleSQLServerExtensions.dll version.
Reinstall the extension pack on the target database server."

It is odd that it is asked for this since it is installed. Re-installing the
extension pack doesn't do anything. I have tried restarting SQL Server and
rebooting the box for that matter to no avail.

I believe this is an error, not a warning since it says a required
prerequisite has failed.

Has anyone seen this before and/or know how to work around it?

Todd,

I'm getting the exact same error, can't seem to find a work-around. Any chance you solved this since your post?

I'm Running SQL Server 2005 on Windows Server 2008 (x64) in case you have the same environment and that's the problem. I did make sure the referenced .dll is there and even put it in the Windows system32 folder so it would be found, to no avail.

Thanks,
D.





Todd_Plettell wrote:

SSMA could not retrieve the extension pack version number
30-Nov-09

When opening the SQL Server Migration Assistant for Oracle SQL Server
instance for conversion it gives me the following error: "SSMA could not
retrieve the extension pack SSMA4OracleSQLServerExtensions.dll version.
Reinstall the extension pack on the target database server."

It is odd that it is asked for this since it is installed. Re-installing the
extension pack does not do anything. I have tried restarting SQL Server and
rebooting the box for that matter to no avail.

I believe this is an error, not a warning since it says a required
prerequisite has failed.

Has anyone seen this before and/or know how to work around it?

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
ASP.NET: Hamburger, Yes! AJAX, "NOT!", Redux!
http://www.eggheadcafe.com/tutorials...urger-yes.aspx