Comments
Sort by recent activity
Can you modify this file? I noticed that for us, one of them is causing the schema validation to fail. / comments
Can you modify this file? I noticed that for us, one of them is causing the schema validation to fail.
So, if we edit this out of the migration script, how do we guarantee that if a table changes, a view that depends on this table will get refreshed during deployment? what would be the best practice here? / comments
So, if we edit this out of the migration script, how do we guarantee that if a table changes, a view that depends on this table will get refreshed during deployment? what would be the best practice...
Any thoughts? / comments
Any thoughts?
Alright, thanks a lot though / comments
Alright, thanks a lot though
interesting, very good point. In my case I'm doing exactly the same, hard-coding the database name, you just saved me a lot of time [image]
I'm also doing the temp db approach, however, what if there are multiple databases and there are dependencies between them, for example I have STORED PROCEDURES that reference tables from another database (staging) ? is there any way we can turn off this check/validation? I guess my question is more related to the use of Invoke-DlmDatabaseSchemaValidation and having cross database joins in my objects / comments
interesting, very good point. In my case I'm doing exactly the same, hard-coding the database name, you just saved me a lot of time
I'm also doing the temp db approach, however, what if there are ...
same error here! / comments
same error here!
For now I manually edited the script to keep moving! / comments
For now I manually edited the script to keep moving!
Rick, any ideas on what fixes this? / comments
Rick, any ideas on what fixes this?
How did you fix this problem? / comments
How did you fix this problem?
same problem here, did you guys figure this out? / comments
same problem here, did you guys figure this out?