Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .