Hey,
Due to a number of mishaps i shan't go into we are in the following situation.

We have a current up to date database on our development server. We have a number of clients with outdated databases based on previous iterations of our current DB with mostly the same table structure but with different fields and options and a few tables missing. No update scripts were generated during development and as mentioned the clients are all on different versions,

Is there a way to produce an update script based on our Current DB that can be used to update ALL our clients DBs on mass through an automated update system. Or will we have to compare each DB individually and make the alterations ourselves.... (a few hundred DB's)

I know it should have been done differently, however hindsight is 20/20 and i need a solution for the situation as it stands.... any help is appreciated.

We (and our clients) are running MS SQL express 2005.