R
Razoramon
Guest
Dear All,
I am trying to create two separate visual studio solutions for the same SQL Azure Database.
Solution files have two separate SQL DB Projects pointing to separate Azure Git Repos but same SQL Database.
when I try to create procedure or view referencing the tables created in the other project I am getting error :
Severity Code Description Project File Line Suppression State
Error SQL71501: View: [dbo].[test] has an unresolved reference to object [dbo].[test_pop]. C:\Users\a\b\repos\sqldb\pqr\xyz.sql 4
Is there any way we can refer other DB schema in the first DB ?
Also, this will be part of Azure DevOps so it should work in the Build and release pipelines to deploy the SQL code.
Thanks
Continue reading...
I am trying to create two separate visual studio solutions for the same SQL Azure Database.
Solution files have two separate SQL DB Projects pointing to separate Azure Git Repos but same SQL Database.
when I try to create procedure or view referencing the tables created in the other project I am getting error :
Severity Code Description Project File Line Suppression State
Error SQL71501: View: [dbo].[test] has an unresolved reference to object [dbo].[test_pop]. C:\Users\a\b\repos\sqldb\pqr\xyz.sql 4
Is there any way we can refer other DB schema in the first DB ?
Also, this will be part of Azure DevOps so it should work in the Build and release pipelines to deploy the SQL code.
Thanks
Continue reading...