Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Comparing databases

Posted on 1998-08-06
2
Medium Priority
?
187 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 60 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

578 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