Hello,

From a non-development machine, I'm running a customized/compiled version of the SF Database Installer sample app and am getting the following error when the DDT metadata is deployed:

The SQLSMOMergeModulel.msm was installed on the workstation along with the SF DLL's.

Any ideas?

• 12/03/2014 2:10:53 PM -> Deploying meta-data for database 'DDTdeploymentTest'
X 12/03/2014 2:10:53 PM -> An error occurred while deploying the meta-data to the server.
X 12/03/2014 2:10:53 PM -> IndexOutOfRangeException       
X 12/03/2014 2:10:53 PM ->   Index was outside the bounds of the array.       
X 12/03/2014 2:10:53 PM ->        
X 12/03/2014 2:10:53 PM -> Source     : Microsoft.SqlServer.Smo       
X 12/03/2014 2:10:53 PM ->        
X 12/03/2014 2:10:53 PM -> Stack Trace:        
X 12/03/2014 2:10:53 PM ->        
X 12/03/2014 2:10:53 PM ->    at Microsoft.SqlServer.Management.Smo.SqlPropertyMetadataProvider.PropertyNameToIDLookupWithException(String propertyName, PropertyAccessPurpose pap)       
X 12/03/2014 2:10:53 PM ->    at Microsoft.SqlServer.Management.Smo.PropertyCollection.GetProperty(String name)       
X 12/03/2014 2:10:53 PM ->    at Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetDbComparer(Boolean inServer)       
X 12/03/2014 2:10:53 PM ->    at Microsoft.SqlServer.Management.Smo.SqlSmoObject.InitializeStringComparer()       
X 12/03/2014 2:10:53 PM ->    at Microsoft.SqlServer.Management.Smo.SqlSmoObject.get_StringComparer()       
X 12/03/2014 2:10:53 PM ->    at Microsoft.SqlServer.Management.Smo.SimpleObjectCollectionBase.InitInnerCollection()       
X 12/03/2014 2:10:53 PM ->    at Microsoft.SqlServer.Management.Smo.SmoCollectionBase.GetObjectByKey(ObjectKeyBase key)       
X 12/03/2014 2:10:53 PM ->    at Microsoft.SqlServer.Management.Smo.SmoCollectionBase.Contains(ObjectKeyBase key)       
X 12/03/2014 2:10:53 PM ->    at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.FindDatabase(Int32 DatabasePK)       
X 12/03/2014 2:10:53 PM ->    at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.EnsureDatabases()       
X 12/03/2014 2:10:53 PM ->    at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.DeployMetaDataThread()       
X 12/03/2014 2:10:53 PM ->  

Thanks for the information Edhy!

I did run into problems installing the 2012 versions of the CLR/SMO packages on Windows v8.1 and posted it to the SQL Server forums.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/c55d8104-79aa-44d1-9df1-05416a4ad7ae/sharedmanagementobjectsmsi-wont-install?forum=sqldatabaseengine

The response was the 2012 packages are not Win8.1 compatible. I ran into the same error when attempting to install the 2014 versions too.

Anyhow, the SSMS install is a good work around until the StrataFrame SQLSMOMergeModulel.msm is updated to work w/ SQL 2012.

Bill