Solved

Comparing databases

Posted on 1998-08-06
2
178 Views
Last Modified: 2010-03-19
Is there a quick and easy way to compare MS SQL Server databases? ie., structure NOT data.
0
Comment
Question by:bringuet
2 Comments
 
LVL 4

Accepted Solution

by:
mitek earned 20 total points
ID: 1089437
Yeah. One way would be to go to Object=>Generate SQL Scripts in SQL Enterprise Manager, Click "All Objects" (or, whatever types of objects need to be compared, like, tables only, etc.) and generate one script file for each database.

Then, use something like WINDIFF utility to compare them. The only problem here would be comments to each object -- they will generate a lot of unnecessary differences.

of course, there may be lots of other ways to do the same thing ...

0
 

Author Comment

by:bringuet
ID: 1089438
Pretty much what I expected without resorting to 3rd party utils like dbdiff. A little bit time consuming but do-able.
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
T-SQL to copy a database 37 66
SQL Select Query help 1 38
MS SQL Server Management Studio R2 4 32
SQL - Ordering Supervisor Hierarchy 2 14
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question