0

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)

Thanks.

Senior Systems Engineer
  • 1,275
  • 2
  • 33
  • 62

3 Answers3

4

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

mrdenny
  • 27,174
  • 4
  • 41
  • 69
1

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

Milica Medic Kiralj
  • 226
  • 1
  • 6
0

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.

Senior Systems Engineer
  • 1,275
  • 2
  • 33
  • 62