Solved

Comparing databases

Posted on 1998-08-06
2
179 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

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…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

691 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