Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need to compare if two developers did the job correctly and created identical tables.

The problem is more complex, but I will try to solve it somehow if I solve the problem of comparing two tables (let them be in different SQL Server 2008 databases) and their properties. No data needs to be compared.

share|improve this question
If you're actually wondering about a solution to a different issue, feel free to ask a question about that specific issue instead of asking a question about a solving attempt ;) – Oliver Salzburg Aug 15 '12 at 17:18

According to

In SQL Server Management Studio, right click on your database and choose 'Tasks' -> 'Generate Scripts'. You will be asked to choose which DDL objects to include in your script.

I would guess you can then diff the DDL.

share|improve this answer
There is a number of comparison tools as well, some of which come with a trial period, so can be used for free. I'm disinclined to suggest specific software titles though :-) – user3463 Aug 15 '12 at 19:17
but I have plenty of columns (that's why I wrote 'huge' tables) ... I don't want to manualy compare. – Robert Jung Aug 16 '12 at 13:08
@Robert: when I wrote "diff", I meant something like diff joe.ddl jim.ddl - an automated comparison. See and – RedGrittyBrick Aug 16 '12 at 13:12

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.