0

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

2
Contributors
5
Replies
6
Views
6 Years
Discussion Span
Last Post by debasisdas
1

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.

0

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

0

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.

0

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

0

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.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.