Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
1  
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

1 Answer 1

According to http://stackoverflow.com/a/1930040/477035

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 en.wikipedia.org/wiki/Diff and gnuwin32.sourceforge.net/packages.html –  RedGrittyBrick Aug 16 '12 at 13:12

Your Answer

 
discard

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.