How can I find a project that compares schema of 2 SQL server databases

Question

0.00/5 (No votes)

See more:

I need to compare my test MS SQL Server database schema to the "Live" database. I have made major changes to a small part of my program, and I don't remember if I added changed any Stored Procedures or Table definitions.

What I have tried:

I downloaded one project from Code Project, but it was done in 2008, and I was unable to get it to run in VS2015 or VS2017.

Posted 10-Dec-21 5:49am

Slow Eddie

Updated 10-Dec-21 6:03am

Add a Solution

Comments

Slow Eddie 11-Dec-21 17:47pm

Richard, Thank you. This was just what I needed. Also check out my post in the Lounge

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Accepted Answer · 2021-12-10T06:03:00

Solution 1

Visual Studio already has built-in tools to do this.

Tools ⇒ SQL Server ⇒ New Schema Comparison

Posted 10-Dec-21 6:03am

Richard Deeming

How can I find a project that compares schema of 2 SQL server databases

1 solution

Solution 1

Add your solution here

Preview 0

How can I find a project that compares schema of 2 SQL server databases

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us