Open Visual studio
Tools-->SQL Server-->New Schema Comparison..
You will see a page, where you can select source database using option "Select Source..."
New window will open -->Select "Database"
Click on Select Connection..
Enter Server: SQLLocalhost
Enter Authentication, user name, password
Select "Database Name" Ex: DB1
Click Ok
In the Visual studio page, select target database using option "Select Target..."
New window will open -->Select "Database"
Click on Select Connection..
Enter Server: SQLLocalhost
Enter Authentication, user name, password
Select "Database Name" Ex: DB2
Click Ok
Click on "Compare"
Tools-->SQL Server-->New Schema Comparison..
You will see a page, where you can select source database using option "Select Source..."
New window will open -->Select "Database"
Click on Select Connection..
Enter Server: SQLLocalhost
Enter Authentication, user name, password
Select "Database Name" Ex: DB1
Click Ok
In the Visual studio page, select target database using option "Select Target..."
New window will open -->Select "Database"
Click on Select Connection..
Enter Server: SQLLocalhost
Enter Authentication, user name, password
Select "Database Name" Ex: DB2
Click Ok
Click on "Compare"
