1
Vote

Could not load file or assembly

description

I get this error right after I select Analyze / Migrate "SQL Database" and hit the next button.

file attachments

comments

ghuey wrote Mar 7, 2012 at 8:57 PM

Hi,

Do you have SQL Server 2008 R2 SP1 installed on the machine you are running SQLAzureMW from? It looks like it can't find the SQL assemblies.

Regards,
George

fdbaird wrote Mar 8, 2012 at 12:54 PM

I am using SQL 2005. Do I have to upgrade to 2008 R2 SP1 and then migrate?

Thanks,

Doug

ghuey wrote Mar 8, 2012 at 1:53 PM

You don't need to upgrade your production machine. If you have a dev machine, then install SQL Server 2008 R2 SP1 on it with SQLAzureMW. When you run the wizard on your dev machine, you then point to your production machine and go through the migration process. Also note that you can have both SQL Server 2005 and SQL Server 2008 R2 SP1 on the same machine without breaking SQL Server 2005. Key thing is that what ever machine you run SQLAzureMW on, that machine will have to have SQL Server 2008 R2 SP1 bits installed to work.

Regards,
George