Hi
In my project there's a frequent change in database schema of
production and testing due to the weekly production.
so this talks lot of effort to figure out which is the exact table
which we have made the change
so for the purpose i thought of making an small application which will
list me the tables or columns which are not in sync.
I tried some of the stuff but was not successful in it
i was able to get the database tables but executing the below query.
Select * from sysobjects
where xtype='u
But when i tried to get the column schema to compare it with the table
from another database table, i was unable to do so.
below is my unsuccessful query string which i executed in the
SQLCommand object
Select * from sys.all_columns where object_id= object_id('TableName')
Please help