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 |
|
prasantha60
Starting Member
1 Post |
 Posted - 2011-08-26 : 06:20:59
|
| I already deploy my application to client computers and he is start entering the data in to the database. i made lots of changes in database form my development computer. how can update this changes back to my client computers, with out go through one by one . is there any way i can generate a script from development computers and apply to my client computers ? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-26 : 06:33:40
|
| you can generate scripts from sql management studio------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2011-08-26 : 07:36:43
|
| Use a product like RedGate DB Compare to create a script based on the differences of the two databasesWhen we make database changes, use DESIGN in SSMS, we do not save them, instead we use the "Generate Script" option, put that script in a "patch" file, run it on DEV. And then on TEST / QA / STAGING / PRODUCTION databases we can just run all the "patch" scripts (since the last patch-version we ran) |
|
|
|
|
|
|
Update Client Database