visual studio 2013 - how to resolve dependency when comparing schema in TFS for SQL Server project or when creating .DACPAC files in SSMS? -

i have sql server project setup in tfs. when trying compare schema source control project target project, getting error on unresolved reference. tried add database reference using "add database reference" dialog box , asking me add .dacpac file.

to create .dacpac file went in ssms , right clicked on db , selected tasks->extract data-tier application option. getting failed because can not resolve dependency of database objects (which uses linked server connection). question how can resolve dependency can add .dacpac file in tfs compare schema , generate scripts deployment tfs. using visual studio 2013.

thanks help.

the correct way handle create dacpac database other end of linked server , add database reference "other server, other database".

instead of ssms create new ssdt project in ssdt , import each database more reliable ssms extract.

ed