1
Vote

Exception: Microsoft.SqlServer.Management.Smo.UnknownPropertyException

description

Microsoft.SqlServer.Management.Smo.UnknownPropertyException: AssemblyName: unknown property.
at Microsoft.SqlServer.Management.Smo.SqlPropertyMetadataProvider.PropertyNameToIDLookupWithException(String propertyName, PropertyAccessPurpose pap)
at Microsoft.SqlServer.Management.Smo.PropertyCollection.GetValueWithNullReplacement(String propertyName, Boolean throwOnNullValue, Boolean useDefaultOnMissingValue)
at Microsoft.SqlServer.Management.Smo.StoredProcedure.get_AssemblyName()
at SQLAzureMWUtils.SourceProcessor.Process(SqlSmoObject[] objects, Int32 start) in c:\SQLAzureMW 2014\SQLAzureMWUtils\SourceProcessor.cs:line 123
at SQLAzureMW.ScriptWizard.GenerateScriptFromSourceServer() in c:\SQLAzureMW 2014\SQLAzureMW\ScriptWizard.cs:line 1993


This happens on "Results Summary: Scripting Analysis and Summary" page.

comments

ghuey wrote Jul 5, 2016 at 7:22 PM

Hi,

This looks like a version mismatch. What version of SQL Server are you running and what version of SQLAzureMW are you running?

SQLAzureMW v3x runs on SQL Server 2008 R2 SP1 or higher
SQLAzureMW v4.x runs on SQL Server 2012
SQLAzureMW v5.x runs on SQL Server 2014

Regards,
George