How can we help you today? How can we help you today?
saulcruz
Activity overview Badges (0) Posts (4) Comments (15)

Comments

Sort by recent activity
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
  1. Community
  2. DLM Automation
  3. Error during Invoke-DlmDatabaseSchemaValidation EXEC sp_refreshview Could not find object '[dbo].[vw
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...
0 votes
How did you fix this problem?  / comments
  1. Community
  2. SQL Compare
  3. Problems after upgrading to SQL Compare 13 from 10.
How did you fix this problem? 
0 votes
Any thoughts? / comments
  1. Community
  2. DLM Automation
  3. Error during Invoke-DlmDatabaseSchemaValidation EXEC sp_refreshview Could not find object '[dbo].[vw
Any thoughts?
0 votes
Rick, any ideas on what fixes this? / comments
  1. Community
  2. DLM Automation
  3. SQLCompare.exe ended with exit code 79
Rick, any ideas on what fixes this?
0 votes
Same here, while migration scripts have been very useful to protect our data in our target environments when making structural changes, they're causing way more issues in our jenkins build schema validation, for some reason schema validation fails when looking at old migration scripts, and while I know I can Ignore Migration Scripts, I would really would like to validate the schema of the migration scripts that have not been deployed yet. So far I don't know how to do this when using: Invoke-DlmDatabaseSchemaValidation Any ideas or thoughts? / comments
  1. Community
  2. SQL Source Control
  3. Abandon using migration scripts
Same here, while migration scripts have been very useful to protect our data in our target environments when making structural changes, they're causing way more issues in our jenkins build schema v...
0 votes
Can you modify this file? I noticed that for us, one of them is causing the schema validation to fail. / comments
  1. Community
  2. SQL Source Control
  3. What is the purpose of AutomaticSchemaChange.patch in migration script?
Can you modify this file? I noticed that for us, one of them is causing the schema validation to fail.
0 votes
Does this mean that if we ever use synonyms in either views or user defined functions we won't be able to use LocalDB as our schema validation database? for example: $validatedScriptsFolder = $scriptsFolder | Invoke-DlmDatabaseSchemaValidation -SQLCompareOptions $options instead of  $validatedScriptsFolder = $scriptsFolder | Invoke-DlmDatabaseSchemaValidation -SQLCompareOptions $options -TemporaryDatabaseServer $buildDb / comments
  1. Community
  2. DLM Automation
  3. TeamCity and Redgate (DLM Automation) Failure
Does this mean that if we ever use synonyms in either views or user defined functions we won't be able to use LocalDB as our schema validation database?for example:$validatedScriptsFolder = $script...
0 votes
this is still happening, since 2010 , are there any red gate recommended workarounds? / comments
  1. Community
  2. SQL Source Control Previous Versions
  3. Will SQL Source Control identify a case change?
this is still happening, since 2010 , are there any red gate recommended workarounds?
0 votes
swinghouse, any resolution on this? / comments
  1. Community
  2. DLM Automation
  3. Post-update schema check failed
swinghouse, any resolution on this?
0 votes
same problem here, did you guys figure this out? / comments
  1. Community
  2. DLM Automation
  3. Visual Studio Team Services + DLM Automation Build - Synonyms do not seem to work in Views?
same problem here, did you guys figure this out?
0 votes
Total activity
31
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
12