Tuesday, June 4, 2019

There is some RedGate Comparesque tooling in Visual Studio 2019 for working with SQL Server Database Projects.

  1. Under "Tools" pick "SQL Server" and under "SQL Server" pick "New Schema Comparison..." while you notice that "New Data Comparison..." is a thing too.
  2. Next you may pick a source and a target.
  3. Click the "Compare" button at the upper left to compare. You may compare an actual database to what is in your project to see if anyone manually added anything.
  4. Click the "Update" button at the upper left to push tables or sprocs or whatever from one place to another. You'll be able to check and uncheck checkboxes for what is in scope for a move over.

No comments:

Post a Comment