Sync-DLMDatabaseSchema Question

• 
  Hi Annette,
  
  Off the top of my head, try:
  
  $project = "C:\Work\scripts"
  $targetDb = New-DatabaseConnection -ServerInstance "test01\sql2014" -Database "Test"
  $options = "ignoreadditional"
  
  Sync-DatabaseSchema -Source $project -Target $targetDb -SQLCompareOptions $options
  
  See example 6 here:
  https://documentation.red-gate.com/sca3/reference/powershell-cmdlets/sync-databaseschema
  
  And further docs here:
  https://documentation.red-gate.com/sca3/automating-database-changes/automated-deployments/using-sql-compare-options-with-sql-change-automation-powershell-module
  

  AlexYates October 31, 2018 15:43

  - 0 +
• 
  Hi Alex, many thanks for this, however it's errored with "Invalid compare option specified".  Have you got any other ideas please?

  MrsFatherjack October 31, 2018 16:43

  - 0 +
• 
  Not sure why that's not working, one for support I guess.
  
  In the meantime, reverting to the raw SQL Compare command line is my de facto quick fix where possible.

  AlexYates November 01, 2018 13:04

  - 0 +
• 
  This should work if you script it this way:
  
  $project = "C:\Work\scripts" 
  $targetDb = New-DatabaseConnection -ServerInstance "test01\sql2014" -Database "Test"
  
  Sync-DatabaseSchema -Source $project -Target $targetDb -IgnoreAdditional
  

  Sergio R November 01, 2018 17:04

  - 0 +

Add comment

Please sign in to leave a comment.