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 |
|
selrod
Starting Member
2 Posts |
 Posted - 2008-08-12 : 15:02:08
|
| I have 2 servers. A production server and a development server.I want to update the data everynight from the production server to the development server.I currently just backup the production server at night and RESTORE it on the development server.May scenario is that I want to add columns to table1 and have those columns still available after the RESTORE. Is this possible? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-12 : 15:04:13
|
| Not with restore.You could save all of your schema changes into scripts and then run those after each restore. But you'd lose data this way unless you saved the data from the extra columns into another table and then reapplied after the columns were added back.Else, you'll have to write some scripts or use SSIS/DTS to import/export your data.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
selrod
Starting Member
2 Posts |
Posted - 2008-08-12 : 15:16:14
|
Would you recommend another method then using RESTORE...maybe some sort of method of just exporting data from one to another.quote:
Originally posted by tkizer
Not with restore.You could save all of your schema changes into scripts and then run those after each restore. But you'd lose data this way unless you saved the data from the extra columns into another table and then reapplied after the columns were added back.Else, you'll have to write some scripts or use SSIS/DTS to import/export your data.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Restoring database, keeping OLD database structure