What are the challenges you face when working across database platforms? Take the survey

Invoke-DlmDatabaseSchemaValidation - External References

We are trying to use a Jenkins/DLM Automation solution to implement CI for our databases. Many of our database objects reference objects in other databases (either on the same server or on a linked server) and nvoke-DlmDatabaseSchemaValidation is failing in this situation (which I suppose makes some sense).

In response to a previous question, Rob C posted the following:

Ah, this explains things and I'll try to explain what is going on. We are trying to build a series of scripts. Script files don't really have a concept of database name as they are just flat files representing individual objects. When you use three part naming, the parser assumes you are referring to an external dependency that doesn't need to be built and this can result in an incorrect deployment order.

To fix this, you'll need to adjust these references to remove the database name.

This would seem to be a deal-breaker for any databases that use external references. Is there a workaround? Any suggestions? Should we skip the folder-based schema validation?

Best Answer

Sign In or Register to comment.