In VS2012 there is a very useful feature "Schema Comparison" if SSDT 2012 is installed, which allows to compare schema between "the DB project in your solution" and the target SQL SERVER 2012 DB schema, unfortunately this only can be done through the vs2012 IDE.
Currently our dev team like to create an automated schema comparison daily for various project(no need to deploy so far), either use free command-line tool or programming by ourselves.
The "sqlpackage.exe" provided by MS SSDT 2012 can generate the deploy sql script(which is good if auto-deployment is needed in future), but seems I can't use this tool for the schema comparison
Another thought is if we can program for schema comparison, "Microsoft.Data.Schema.Tools.Compare" Namespace can be found, but there is not so much programming guide about it.
I would like to ask if anyone have some clues about this scenario?
