IT:AD:SQL Compare
Summary
- Hellishly expensive for a developer.
- And you have to buy both
SQL CompareandSQL 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.