I'm working on a project where we are updating client databases from older version to newer versions of the database and the related schema.
I'm looking for a way do the following for all of the tables in the database that our program uses.
If the table doesn't exist create table else for each column in the table bring the column up to date or create it
I can't seem to find a way to do this through management studio and I haven't turned anything up through Google.
Something that would either give me this option in SQL Management Studio or a program that would generate the scripts for me would be good.