Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bryanfok
Starting Member
1 Post |
 Posted - 2010-05-18 : 05:57:33
|
| Hi AllI am using Sql server express 2008One at my development machine , one at production machine. (Both have the same setup and desgin)What is the best practice to update my production database's tables design, after I made change at my development database and want to update the changes to production ?regardsBryan |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2010-05-18 : 06:26:00
|
| 1. keep the master copy of your database design outside of the database - in a source-control system - vcs, vss, notepad, or whatever.2. run a "compare and identify differences" tool to generate a "what is changed list. you can then turn this into a upgrade script. some commercial products are available for this - one i can recommend as a user is www-red-gate.com, but others also exist for good value. |
 |
|
|
|
|
|
Update Tables design from a server to another