We are migrating the database from SQL Server 2008 R2 to SQL Server 2012. The database name is the same. Only the server name has changed. I have LLBL project created from LLBL Gen 5. I went to Sync Relational Model Data and click Perform Task. Then I changed the server name in Relational Model Data Retrieval Wizard and perform the sync. The error below shown in the result dialog box. I have checked the permission on the database. I am db_owner role in this database so I have full control. I can't work it out what would be the cause of this issue.

Results of synchronization of relational model elements with database elements from database of type 'SQL Server'
Actions taken for catalog 'CDS_AppAdmin_3_5'
Error: 'Exception caught while instantiating UDT type 'Microsoft.SqlServer.Types.SqlHierarchyId' from assembly 'Microsoft.SqlServer.Types.SqlHierarchyId, Microsoft.SqlServer.Types, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91': Couldn't find type: 'Microsoft.SqlServer.Types.SqlHierarchyId' using type description: 'Microsoft.SqlServer.Types.SqlHierarchyId, Microsoft.SqlServer.Types, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'. Type skipped.'
Error: 'Exception caught while instantiating UDT type 'Microsoft.SqlServer.Types.SqlGeometry' from assembly 'Microsoft.SqlServer.Types.SqlGeometry, Microsoft.SqlServer.Types, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91': Couldn't find type: 'Microsoft.SqlServer.Types.SqlGeometry' using type description: 'Microsoft.SqlServer.Types.SqlGeometry, Microsoft.SqlServer.Types, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'. Type skipped.'
Error: 'Exception caught while instantiating UDT type 'Microsoft.SqlServer.Types.SqlGeography' from assembly 'Microsoft.SqlServer.Types.SqlGeography, Microsoft.SqlServer.Types, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91': Couldn't find type: 'Microsoft.SqlServer.Types.SqlGeography' using type description: 'Microsoft.SqlServer.Types.SqlGeography, Microsoft.SqlServer.Types, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'. Type skipped.'
Actions taken for schema 'dbo'

If you're not using geometry/geography types in your database, you can safely ignore these. It's caused by the following: inside sql server geometry/geography types are implemented as .net types in the assembly Microsoft.SqlServer.Types: https://www.nuget.org/packages/Microsoft.SqlServer.Types/ . When the driver is determining UDT types, it sees these types and tries to create an instance of these types. However your machine apparently doesn't have the assembly in the GAC so the assembly isn't found.

If you do use geometry/geography types, then make sure the assembly Microsoft.SqlServer.Types is in the GAC. See: http://www.llblgen.com/Documentation/5.0/Designer/How%20To/WorkWithSpatialTypes.htm

This thread has more info about it too: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=23953&StartAtMessage=0