CODEWITHSUNDEEP
sqlsql-server-2005
Leandro Bardelli
Leandro Bardelli

Reputation: 11578

Making a diff on SQL Server 2005

How can I do a diff between two databases on SQL Server 2005, without a third-party software? Only sqlcmd or SQL Management Studio.

The diff must be only on the structure: tables, store procedures (usp), views, etc.

Thanks.

Note: No, I can not install anything, is for stage environment.

Upvotes: 1

Views: 130

Answers (1)

Andomar
Andomar

Reputation: 238048

Use All Tasks -> Generate Script, and save the result for the two servers in a different file.

Now you can use standard diff tools like windiff to compare the two. Because you're comparing files on your workstation, you do not have to install anything on the DB servers.

Upvotes: 2

Related Questions