Thanks for your interest.
1. Yes, this is possible. In fact, if you read the "Updating a customer database schema example" blog at http://labs.red-gate.com/index.php/SQL_Comparison_SDK
, you will be able to download an example of this very use case.
2 & 3. The license agreement is linked off the main product page: http://www.red-gate.com/products/SQL_Co ... /index.htm
. In summary, it is royalty-free, but if you need to distribute it beyond 100 copies you will need to contact firstname.lastname@example.org
to purchase an increased entitlement.
Red Gate Software