SQL Server Data Tools for Visual Studio 2013 -Run as Administrator
TOOLS-->SQL Server-->New Data Comparison...
Click on New Connection..under Source Database
Select SQL Server Name and DB Name
Click on New Connection..under Target Database
Select SQL Server Name and DB Name
Click Next
Select Tables which you want to compare
Finish
You will see data difference b/w 2 DBs
Disconnect all users from the database --Change the database connection string in the
InnovatorServerConfig.xml from “<DB-Connection…” to <xDB-Connection” and
restart the w3svc service(IIS).This
expires all sessions and prevents all new connections to the Aras Innovator
database through the existing instance