I am trying to replicate how the change scripts are created when you make a modification to a table using the management studio. In particular when you add a Identity column etc... You have to drop and recreate the table with all the necessary stuff that goes along with that in a specific order. All I have to do in the studio is click on the "Create Change Script" button and it gives me the script that I would like to run. I would like to do this programmatically.
I am doing this because I am writing a application to go through some 150 tables to add standard columns and make sure that I have a standard ID key and primary key. I am trying to create a upgrade process for a client and I would like to do this in a repeatable manor (So I don' have to look at every table). I am trying to using SMO to do this.
Basically I would like to know if there is a good resource out there that explains the whole SMO API. I would like to know the process of how to create these scripts. Following some flow of you first have to create the drops, create the mods, etc...
Any help would be appreciated.
Create change scripts like Microsoft SQL Server Managment Studio
Brandon R
Craig,
Here's a rather short overview of SMO out on SQL Junkies: http://www.sqlteam.com/item.asp ItemID=23185
You should take a look at the ScriptAlter() method. I believe this will do what you want.
Cheers,
Dan