SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,947 questions
dacpac project .sqlproj creation. errors with multiple schemas
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 7.000000000000001%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERJ%3C/text%3E%3C/svg%3E)
Ramanjaneyulu Jerugula
0
Reputation points
i have SQL Server database, with objects defined under two schemas,
Schema 1 - dbo.
Schema 2 - pr.
Tables - dbo.person, dbo.orders, pr.person , pr.orders, pr.sales
SP= dbo.getpersons, dbo.getdata, pr. salesinfo.
when imported the data into .sqlproj for creation of dacpac and automated deployment.
always get compilation build errors mentioning that .
Error SQL71501: Table: [pr].[person] has an unresolved reference to Schema [pr]
Error SQL71501: Table: [pr].[orders] has an unresolved reference to Schema [pr]
Error SQL71501: Table: [pr].[sales] has an unresolved reference to Schema [pr]
I have tried by importing the database using
schema/Objects, objects only,
and also, included the schema name in filename also project settings..
nothing helped out.. got same problem
tried in SQL server 2016, 2019, 2022 in sqlproject Target platform
and VS2022
Microsoft Visual Studio Enterprise 2022
Version 17.9.6
VisualStudio.17.Release/17.9.6+34728.123
Microsoft Visual Studio Enterprise 2022
Version 17.9.6
VisualStudio.17.Release/17.9.6+34728.123
SQL Server Data Tools 17.9.56.1