How to deploy updated database from development environment to live environment?

I have finished a change request from our client. I need to update clients' database with the one in developments.
Here is the changes i made to database:
Added/Changed some tables
Added/Changed some stored procedures
Added data to some dictionary table
The data in clients' current database MUST be kept.
So how can I merge the changed information to clients' database?

Create update script and run it on client database. It is always good to maintain update script.
For example:
If you create a table/SP, use create script
If you change the table structure/SP code, use alter script, so you can retain data
Set of insert and/or update statements to take care of dictionary data.

|||

potturi_rp wrote:

Create update script and run it on client database. It is always good to maintain update script.
For example:
If you change the table structure/SP code, use alter script, so you can retain data

Hi, Sam,

Thank you for your help! I am not very clear about "use alter script, so you can retain data". Could you explain further, or could you send me some documents or hyperlinks about this? My email address ischarles.du@.hotmail.com
Thanks a million!
Regards,
Charles

|||If you are adding a column to a table, user ALTER TABLE to add the column. That way you donot loose data.