I want to build a dacpac of a sql server database . I used ssdt to import the database objects into a project. The build succeeded without any errors but has lots of warnings(more than 100) related to unsolved references.
The unsolved references point are due to the following:
- Objects from other databases in the same server.(Warning SQL71562)
-Objects from other databases from other sql server instances(Warning SQL71562)
-Objects referencing the same database itself where a 3-part naming convention was used [DatabaseName].[SchemaName].[ObjectName] (Warning SQL71562)
-contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects. (Warning SQL71562)
-The object definition [xxx].[#xyz] differs only by case from the object definition [xxx].[#xyz] (SQL Warning: SQL71558)
-Warning SQL71562: Computed Column: [#abc].[def] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects:
I have tried deploying the build which has only warnings but the deplyment didn;t succeed.
I am pretty new to SSDT and would very much appreciate any help.
Thanks in advance. :)
