Thanks for your help.

I'm sure the schema's are going to be the majority of the task.

No I don't have to come up with a concrete plan very soon, we've kludged...

There is not a lot of commonality between the forms. So far, I've got a master table called WCB_Info that contains the common things like the claim number, employee...

I think we're on a different page.

I want to send my client a .zip file that contains my script and files. The client can then use some program which...

Thanks for the info on improving our change script efficiency. However, I'm more looking for something to automate the deployment and/or running of the scripts

Due to foreign key constraints, we don't go the renaming route.

So generally, we do stuff like this to change the structure:

ALTER TABLE dbo.Foo

ADD Column FooBar INT NULL

Sometimes we add tables,...