SQL Server DBA Tutorial 182-How to Compare Two Databases of SQL Server

In this video you will learn how to compare two databases of SQL Server using Visual Studio. It demonstrates how to connect to SQL Server databases using Visual Studio, how to create database project in Visual studio, how to import databases into Visual studio Database project, how to script out databases and compare databases scripts and some recommended third party software if you don't have Visual studio installed. It walks you through different settings and options of comparing databases in visual studio and shows you how to sync once you are ready to sync source and destination databases in visual studio.

Blog post link for the video with script

Visit our website to check out SQL Server DBA Tutorial Step by Step

[rishiyogil.n.]

big thanks for this video and explaining different options too... thanks for clear explanations

[secretdba]

Hi Tech Brother, thanks for video, can we also update data in target server from source server .in this video you showed us to to compare schema. could you please do video how to update target data so that both database are updated. thanks

[arunavsen]

Hello, this is something great. But I am ow facing an issue. One database is on a different server, and another database is on another server. I can not compare this. But when I test this on my local server, then it works. What is the solution for this?

[meghamisra]

I am running one VB script. it is running fine with my test database but when i am connecting to the production database it runs successfully but won't give any result. I did compare both the databases but could not found any difference. Can you please let me know if I am doing any thing wrong. My test database is copy of my production database and this problem started after the copy.