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 |
|
Pinto
Aged Yak Warrior
590 Posts |
 Posted - 2006-11-16 : 10:37:56
|
| I have two 'identical' sql databases, Live and Test but they have got out of sync - I've developed on Test and now Live is a lot different. How can I copy Test to replace Live.By the way, Live isn't used yet, but is going to be soon. |
|
|
jshurak
Starting Member
44 Posts |
Posted - 2006-11-16 : 11:05:10
|
| Are these databases on the same server? If they are you can make a back up of Test and restore the back to Live. Right clicking on the Test database, select all tasks -> backup database. You can select a location inside the window that pops up. After the back up is complete you can right click on the Live database, select all tasks -> restore database. From there you can select the location of the Test backup. This is all done in Enterprise manager. I would also suggest doing a back up of Live, just to be safe. Just make sure you don't restore from the Live backup!International Businessman of Mystery |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-11-16 : 13:11:21
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=74366Kristen |
|
|
|
kginni
Starting Member
13 Posts |
Posted - 2006-11-17 : 09:11:01
|
| in case you only want to copy the tables data then you can use the DTS packages |
|
|
|
|
|
|
Copy database