DLM build fails for views but not store proc?

• 
  Sprocs are only compiled at run time so dependency issues aren't uncovered simply by building/deploying the DB.

  AlexYates July 17, 2018 18:29

  - 0 +
• 

  Thank you Alex for the response, it clears up the confusion little bit. So does that mean views dependency issues are all covered by building only and if so how can I build views whose scripts has database name reference. They fails in build. Is there any tweak I can do anywhere so that DLM does not see them as an invalid objects.

  For example if I have a view script

  CREATE VIEW sample1 AS SELECT * FROM 
  databasename.schemaname.tablename;

  Then I am getting build error:
  WARNING: The error 'Invalid object name databasename.schemaname.tablename;' occurred when executing
  the following SQL:

  and if I remove the databasename from the above script then it works.

  Please suggest me some idea as we have more than 500 views script with similar problem.

  Thank you for your response again.
  

  10raw July 17, 2018 18:43

  - 0 +
• 
  Don't use 3 part naming? Seems to be unnecessary assuming the table is on the same database. 3 part naming just makes your life harder.
  
  You can work around it if you must. Use the -TargetDatabase switch.
  https://documentation.red-gate.com/sca3/reference/powershell-cmdlets/invoke-databasebuild
  
  Reason for error is SQL Change Automation will create a scratch DB with a guid for a name to test your code. Your 3 part naming obviously cries. If you use -TemporaryDatabaseName it will ensure SQL Change Automation uses your specified DB for the build.
  
  This is a pain though as you can now only run one build at a time.

  AlexYates July 17, 2018 19:19

  - 0 +
• 

  Thank you for the clarifications.  Last but not least, for the main question , Does views get compiled at build/deploy?

  10raw July 17, 2018 19:27

  - 0 +
• 
  Yes - if a view tries to read from a table that doesn't exist the build should fail.

  AlexYates July 17, 2018 19:27

  - 0 +
• 
  Ah - now the order of this thread is messed up and the accepted answer is the answer to the wrong question! (-:

  AlexYates July 17, 2018 19:29

  - 0 +

Add comment

Please sign in to leave a comment.