Updating a database

[abcfantasy]

I've got this application that uses database, and distribute it to the various users.

There are certain tables which each user changes, and other table which only the I can change.

If at a certain point I update the database, how do I update each of the user's databases without overwriting the tables they changed? (ie. without sending and overwriting the .mdf file)

I use Sql Server 2005 if it may be of any help.

Sorry if I wasn't clear enough
Thanks for any help
Andrew

ABC -

http://www.abcfantasy.tk

 

[PGoRule]

...that uses database, and distribute it to the various users.

Distribute means what?
Is the database used by everybody?

Sharing the best from my side...

--Prashant--

 

[abcfantasy]

Each user has his own copy of the database.

ABC -

http://www.abcfantasy.tk

 

[stevexff]

Sounds like you need to send them a database script to make the changes. Back up their database, make structural changes, add new reference data, check it, back it up again. If this is a commercial venture, there are a number of tools on the market (I've used RedGate quite successfully in the past) that will 'diff' two database schemas and produce a script to make the changes.

Steve

[small]"Every program can be reduced by one instruction, and every program has at least one bug. Therefore, any program can be reduced to one instruction which doesn't work." (Object:erlDesignPatterns)[/small]

 

[abcfantasy]

thanks for the help, i'll see what i can do.

ABC -

http://www.abcfantasy.tk

 

[grande]

Why does each user have a seperate copy of the database? Shouldn't there be one copy that each person works off of?

-------------------------
Call me barely Impressive Captain.

 

[abcfantasy]

i'm doing this small quiz game, and has a database that contains the questions available, categories, questions answered and so on...

I used a database with this game mostly for practice as I'm relatively new to dbs. It would be quite interesting to have 1 shared database (on a server or something) but have no idea how to do that for now.

ABC -

http://www.abcfantasy.tk

 

[stevexff]

It would be quite interesting to have 1 shared database (on a server or something) but have no idea how to do that for now

Easier than you might think, actually. Certainly a lot simpler than trying to create database scripts for distribution...

Steve

[small]"Every program can be reduced by one instruction, and every program has at least one bug. Therefore, any program can be reduced to one instruction which doesn't work." (Object:erlDesignPatterns)[/small]