IT:AD:SQL Compare

(UP)

Summary

Hellishly expensive for a developer.
And you have to buy both SQL Compare and SQL Data Compare, each about $400, or buy a bundle for $1500. Ouch. Alternatives are:
- SQL Examiner.
  - Pros
    - Works on more targets than SQLServer.
    - Cost is only 300.
  - Cons
    - Only Schema compare (no data as far as I can see.

Process

Potentially Create a new Db, and into it run previously deployed schema and data scripts…
Select Current Dv Db on left side (ie dev/latest)
Select Current Prod Db on right side (ie what is already deployed
Let it compare…
Then check the parts you want included in the new script.
- Probably don't want some of the roles/logins created for local dev accounts…
Copy to clipboard.
Now do same for data.