Server Fault is a question and answer site for system and network administrators. 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

Is it possible to create or do it from SSMS to compare two different schema ?

I need to compare database table in my current production DB to see which one is different in order to generate delta (upgrade script)


share|improve this question

No, SSMS doesn't have a feature to do this. Look at RedGate or Quest for a tool to do this.

share|improve this answer
SQLCompare by RedGate is the way to go (IMO) – Joel Mansford Feb 18 '11 at 0:41
Yes, I'll second the SQL Compare mention. – squillman Feb 18 '11 at 1:28

You can also try ApexSQL Diff - ApexSQL Diff is a SQL Server database comparison and synchronization tool which detects differences between database objects. It compares and synchronizes live databases, native or natively compressed database backups, database snapshots, scripts in source control and script folders

Video - Introduction to ApexSQL Diff

Hope this helps

Disclaimer: I work for ApexSQL as a Support Engineer

share|improve this answer
up vote 0 down vote accepted

but then I found this

select TABLE_SCHEMA,COUNT(*) TableCount from INFORMATION_SCHEMA.TABLES group by TABLE_SCHEMA -- followed by select * from sys.tables order by modify_date desc

but that's just a simple script to list all tables between my prod and dev environment.

share|improve this answer

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.