[SOLVED] dacpac - CLR assembly reference path issue

dacpac - CLR assembly reference path issue

Following is the exact scenario in my database project, where I am creating dacpac to deploy databases on target SQL instance:

the database project is having a reference of CLR assembly.
TFS build server is used to build the project
dacpac is getting created during TFS build process

– when i try to run sqlpackage.exe to deploy the dacpac (generated in TFS build process) in my environment, I get an error saying –

*** No file was supplied for reference XXXX.XXXX.XXXX.dll; deployment might fail. When C:\Temp\Dacpac_testing\XXX.XXXXX.XXXX.dacpac was created, the original referenced file was located C:\BUILDS\1\XXXX\XXXX\SRC\XXXXXXXX\ASSEMBLIES\XXXX.XXXX.XXXX.dll

How can I create a dacpac to reference the path of CLR assembly on deployment environment (and not the one that was used at the time of building dacpac)

Any help on this will be much appreciated.

Solution

Sorry I only picked on this thread now, but I had a similar issue. Open the references in the Sql Server project, go to the dll that you are referencing right click and select properties.

Change the following settings: Generate Sql Script: True Model Aware: True

Select the relevant Permission set as required by the clr code.