After specifying different databases on the Source Database and Destination Database tabs, the following error is displayed:
The source and destination database are the same instance. Migration must take place between different databases.
Even though the databases have different Database Names and\or are on different SQL Server Instances, the databaseinstanceid contained in the ChangeAuditor database dbo.SystemProperty table for both databases are the same.
This can occur if the databases used in the Source Database and Destination Database tabs are different copies of the same Change Auditor database.
Migrate the data from the Source Database to a new temporary database and then migrate the data from the temporary database to the Destination database.
Waiting for fix in a future release of Change Auditor.