4
Vote

Unable to install SQL Database Migration Wizard v3.9.12 & v4.0.15

description

I am having problems installing the SQL Database Migration Wizard v3.9.12 & v4.0.15
I am trying to install it in Windows 2008 R2 server,
I get an error
"Sorry,but dependencies for SQLAzureMW are missing"
Error message = Could not load file or assembly
"Microsoft.ExceptionMessageBox, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified

What am i doing wrong?

Thanks

comments

ghuey wrote Apr 10, 2013 at 1:22 AM

Hi,

SQLAzureMW required SQL Server 2008 R2 SP1 or greater. When SQLAzureMW runs, it looks for the the assemblies that it needs to run. It looks like you are running SQLAzureMW 3.9.12 right? It also looks like you might have part of SQL Server 2008 R2 SP1 installed, but for some reason, Microsoft.ExceptionMessageBox is missing. If you want to try something, edit Dependency.xml and remove this:

<Dependency>
<Assembly>Microsoft.ExceptionMessageBox, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91</Assembly>
<Type>Microsoft.SqlServer.MessageBox.ExceptionMessageBox</Type>
</Dependency>

And try to run. You might be able to get buy without that (I don't really know, but what the heck, it is worth a try) if you don't get any errors, but it is needed to if the program finds a problem it wants to report. If that does not work, then you need to install ... I believe the client tools, but not for sure.

Regards,
George

Duality wrote Apr 26, 2013 at 4:04 PM

If you have SQL Server 2012, as I do, the reference I have is v11.
So I changed the file to:
<Dependency>
<Assembly>Microsoft.ExceptionMessageBox, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91</Assembly>
<Type>Microsoft.SqlServer.MessageBox.ExceptionMessageBox</Type>
</Dependency>
And it works.
So this is a bug.

ghuey wrote Apr 29, 2013 at 3:56 PM

Are you running SQLAzureMW v4.0.15? That version is built for SQL Server 2012 and it has the dependency.xml file setup for version 11 like you posted. If you are running SQLAzureMW v3.9.12, then the dependency.xml file is for SQL Server 2008 R2 SP1.

I am glad you are up and running.

Regards,
George

Duality wrote Apr 30, 2013 at 8:40 AM

Ah, yes, I was using v3.9.12, using v4.0.15 now and it works without any changes required. Thanks.

UncleMike wrote Tue at 5:02 AM

(Sigh.)

Spot on.

Changing the Dependencies.xml file to use v11.0.0.0 solved the issue for me.

<Assembly>Microsoft.ExceptionMessageBox, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91</Assembly>

But seriously, for such an amazing service like Azure, are they really giving us basic issues like this ?!