database updateing

[stephen lowry]

hi guys
i have created a database for a friend which seems to be running ok (for now) my front end im using vb.net . what i need to do is make alterations to the same database which is on my computer ie add fields which i can do then update his database ,my only concern is as i dont have his data i would be afraid of overwriting and he loses his data is there a way if i update his he wont lose data

thank you for your help

[debasisdas]

Instead of doing that from another system and trying to synch the changes on target system. Create the changes as a script and apply the same on target system directly.

[stephen lowry]

thanks not quite sure what you mean however the target system isnt available to me im just going to send him the updated front end and database again i would hate myself if i lost his data hmmmmmm

thank you

[debasisdas]

You need to send a database upgrade script. Your friend must execute that on the target system and then point he application to the database.

[stephen lowry]

ohh ok thanks i will have a look around to see how thats done ,thanks for pointing me in the right direction do u know of any links i can follow to see how its done

thank you again for your assistance

[debasisdas]

You need to prepare a script for creation of all the new objects and the ALTER statements. Also add all the DML scripts if any into the same script.