I have a database that has been updated, many columns have been added. Currently the only way of returning the differences between the two databases is by going through the database.cs class that is autogenerated and comparing it with the old database.cs file. I have both database on Sql Server Management Studio (the new structure, and the old structure of the databsae) and want to see all the differences. How can I return the differences between the databases and tables.
OLD Db New Db TabA TabA Col1 Col1 Col2 Col2 Col3 Col3 Col4 Output Col4 int not null