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 |
|
abuhassan
105 Posts |
 Posted - 2008-10-17 : 08:15:48
|
| HiI have got two instances of SQL server runningone is the real environment which is currently hosted and the other i have on my local machine which i use for testing and development.i have made some changes to the database on my local machine and added a new colunm with some new data in it. Is there a way of using ascript or a command to get a script of that colunm only and the data in it and apply it to the hosted database. I have been told i must drop the whole database on the production environment and take a backup of the database on my local machine and restore it on the hosted environment and thats the only way i can do it, surely there must be a more elegant way without disrupting the service too much? and incorporating small changes etc??? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-17 : 08:34:24
|
| is it just a matter of single column with data? if yes, just fire an alter statement to add it in production and using SSIS/DTS update column with values in dev db |
 |
|
|
abuhassan
105 Posts |
Posted - 2008-10-17 : 09:54:37
|
| few colunms from different tables, alter statement? how does that work? You said "using SSIS/DTS update column with values in dev db" what are SSIS/DTS how do i use them? what do they do? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-17 : 10:46:22
|
quote:
Originally posted by abuhassan
few colunms from different tables, alter statement? how does that work? You said "using SSIS/DTS update column with values in dev db" what are SSIS/DTS how do i use them? what do they do?
Then you need to manually write alter statement for those tables to add new columns.SSIS is Integration Services and DTS is its predecessor available in SQL 2000 & earlier. then can connect to heterogenous data sources ad transfer data between them and even do some modification of data in between transfers. for more details refer below linkswww.sqldts.comwww.sqlis.com |
|
|
|
|
|
|
Database Changes