Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SSMA could not retrieve the extension pack version number

145 views
Skip to first unread message

Todd_Plettell

unread,
Nov 30, 2009, 3:05:01 PM11/30/09
to
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?

dwilliams

unread,
Dec 3, 2009, 11:02:39 AM12/3/09
to
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/aspnet/bf10c5a6-0c8e-4ba9-934d-edb57ab852e3/aspnet-hamburger-yes.aspx

0 new messages