SQL Compare 11 can compare all databases schema

Comments

• Options

  sam.blackburn Redgate › Posts: 224 Gold 2

  August 16, 2016 4:59AM

  If you want to compare/deploy many databases together, your best bet is probably to call the command line many times in a loop; SQL Compare compares two databases at a time, deploying changes from one to the other.

  Software Developer
  Redgate Software

  0 · Share on Twitter
• Options

  justinmac88 Posts: 3

  August 16, 2016 10:18PM

  Hi Sam,
  
  your best bet is probably to call the command line many times in a loop > Where I can retrieve the comparison script?
  
  Thank you.

  0 · Share on Twitter
• Options

  sam.blackburn Redgate › Posts: 224 Gold 2

  August 17, 2016 11:33AM

  The best implementation depends on your choice of language and what you want to do. For example if you wanted to use Powershell this method might be handy:

  function Get-DBList ($server)
  {
      $srv = New-Object 'Microsoft.SqlServer.Management.Smo.Server' $server
      $srv.Databases | Select name, RecoveryModel, 
          @{Label="CompatibilityLevel";Expression={($_.CompatibilityLevel).ToString().Replace("Version", "")}}
  } #end Get-DBList
  

  From http://dba.stackexchange.com/questions/ ... -databases
  
  And you could loop through the resulting collection calling SQLCompare.exe with arguments for whatever you wanted to do. The script shouldn't be too hard to write, but it won't produce an interactive experience like the SQL Compare UI.
  
  I hope this helps.

  Software Developer
  Redgate Software

  0 · Share on Twitter