Comparing databases

Is there a quick and easy way to compare MS SQL Server databases? ie., structure NOT data.
bringuetAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mitekConnect With a Mentor Commented:
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
 
bringuetAuthor Commented:
Pretty much what I expected without resorting to 3rd party utils like dbdiff. A little bit time consuming but do-able.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.