Can Sql data compare synchronize missing and modified indexes between two different databases?

Answers

• Options

  BrainDonor Friend of Redgate › Posts: 55 Silver 2

  February 1, 2021 9:26AM

  SQL Compare (as oppose to SQL Data Compare) - compares schemas and generates scripts for any modifications.
  It is available for a free trial period and worth a look.

  0 · Share on Twitter
• Options

  Dan_J Redgate › Posts: 449 Silver 2

  February 2, 2021 12:33PM

  Hi @OffByOne
  

  
  

  Thanks for reaching out to us regarding this.

  
  

  @BrainDonor is correct, you can use SQL Compare to achieve what you're asking. To clarify, SQL Data Compare synchronizes the data, whereas SQL Compare synchronizes the schema.

  
  

  SQL Compare can be downloaded here: https://www.red-gate.com/products/sql-development/sql-compare/ . Your license should cover you to use this.
  

  
  
  

  Kind regards
  
  Dan Jary | Redgate Software
  Have you visited our Help Center?
  

  0 · Share on Twitter