|
| How to update database after client information is in there |
 |
Fri, 14 Mar 2008 16:28:16 +000 |
Hello,
What is the best way to update a database (say add a table or change an existing
table) when the database is already live and has client data in it?
This looks tricky, so i'd like to get some feedback before going ahead.
|
| Post Reply
|
| Re: How to update database after client information is in there |
 |
Fri, 14 Mar 2008 16:59:43 +000 |
Just point your connection string to the server, rather than your local
machine.
|
| Post Reply
|
| Re: How to update database after client information is in there |
 |
Fri, 14 Mar 2008 17:02:20 +000 |
DisturbedBuddha:
Just point your connection string to the server, rather than your local
machine.
Won't that overwrite data already in the database?
|
| Post Reply
|
| Re: How to update database after client information is in there |
 |
Fri, 14 Mar 2008 17:15:40 +000 |
These are things you need to consider when adding or changing a table in an
existing database:
If this table is a lookup table, make sure first to populate this newly created
or added fields with valid data, second to populate all foreign keys fields in
the foreign table.
If a newly created or added field is a foreign key of an existing table, make
sure to poplulate this field with valid data.
If the newly created or added fields are not null, make sure to populate these
fields with valid data.
Otherwise, you may safely add or changing a table in an existing database.
|
| Post Reply
|
|
|
|
|
|
|
|
|
|