CODEWITHSUNDEEP
sql-server-2005visual-studio-2010
DenaliHardtail
DenaliHardtail

Reputation: 28336

How do I deploy a database project?

My project is near completion, about to be rolled out into production. To get the production database into source control before we start SP prep and additional phases, I created a database project (SQL DB 2005). No problems and I think I get everything with the db proj. When I tested the database project by deploying to my local .\SQLEXPRESS I was deluged with warnings similiar to the following:

SQL04151: Procedure: [dbo].[spGetSalesData] has an unresolved reference to object [sys].[objects].

How do I resolve this? This is my first time using a database project so it could be something minor.

Upvotes: 1

Views: 329

Answers (2)

suhprano
suhprano

Reputation: 1733

sys.objects can be anything from tables, to stored procedures, to primary keys, to views, and triggers.

It appears that it's referencing some object in the spGetSalesData stored procedure that your local db doesn't contain.

Upvotes: 0

DenaliHardtail
DenaliHardtail

Reputation: 28336

Found a solution here.

Upvotes: 1

Related Questions