ApexSQL Diff can compare full and differential database backups

Yes. ApexSQL Diff supports the decryption of encrypted objects

The synchronization script will only contain compatible objects. Incompatible code (script-based objects) has to be fixed manually

To execute the synchronization script, the user must be a member of the db_owner database role. For comparison, the user needs both CONNECT and VIEW DEFINITION permissions

No. ApexSQL snapshots can only be used with ApexSQL Diff and other ApexSQL products

No

DROP/CREATE, rather than ALTER, will be used for the following scenarios:

1. There are differences in the file groups
2. ANSI options specified on object creation are different
3. After removing/adding of columns from/to a destination object, the object result with no data
4. Incompatible data types in source/destination columns with same names
5. There are differences in the identity columns
6. The column order in source/destination objects is different
7. There are differences in the XML columns of XML schema collections

The Synchronization Wizard Warnings tab will show the possible reasons for such cases

Yes, if the user wants to

The following prompt will be displayed:

After clicking Yes the file will be updated, or it will be left unchanged when choosing No