Search code examples
c#web-servicesvisual-studio-2015sql-server-data-toolssqlclr

vs2015 schema compare not deploying auto generated xmlserializer assembly

I have a sql database project in visual studio 2015, that includes a clr stored procedure that calls a webservice. I have configured the projects to auto generate the serialization assembly. This means in de output folder I get both a projectname.dll and a projectname.XmlSerializers.dll.

I use the visual studio schema compare function and that works fine in comparing and updating projectname.dll but it does not show projectname.XmlSerializers.dll which I have to update by hand every time.

How do I get the schema compare to recognize and update the projectname.XmlSerializers.dll file?

Solution

  • In order to get SSDT to load a DLL that is not being created directly from your project into SQL Server, you need to do the following two steps:

    1. Add the DLL to the Project (Add Existing Item)

    2. For the properties of the newly included DLL, make sure that "Model Aware" is set to "true".