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 |
|
newSqlMan
Starting Member
11 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-16 : 09:48:12
|
So, if I understand you correct, you have a DEVELOPMENT database that has some new / changed columns and tables, and you want to make those same changes to your LIVE database?We do this by saving a script EVERY time we make a DDL change to the DEV database. Then we run all those changes against our LIVE database when we deploy an upgrade.However, that is too late for where you are now  although I do recomend that technique for the future.There are tools which can compare two databases - e.g. DEV and LIVE, or in your case PC-1 and PC-2, and make a script of the command to change the LIVE database to be the same as DEV. For example Red-Gate's SQL Compare tools:http://www.red-gate.com/products/SQL_Compare/index.htm |
 |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2010-01-16 : 10:10:39
|
| Another tool that can do this: Microsoft Visual Studio Database Developer edition. You can import the schema from one database, compare it against another database, preview change scripts, selectively apply changes etc. |
|
|
|
newSqlMan
Starting Member
11 Posts |
Posted - 2010-01-16 : 10:31:44
|
| so where do u get this script to save changes in DEV database and then run it on Live db? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-16 : 11:34:46
|
| Errrmmm ... from the Database Comparison Tool that Red-Gate make that I provided a link too? Or am I missing something? |
|
|
|
|
|
|
|
|
copy/update SQL to another SQL