# IT:AD:SQL Compare #



<callout type="Navigation" class="small">

* [[../|(UP)]]
{{indexmenu>.#2|nsort tsort}}


</callout>


<panel title="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.


</panel>


## 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.