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 |
|
Jayarajdaniel.Sundarraj
Starting Member
4 Posts |
 Posted - 2009-09-18 : 08:15:50
|
Hello,I'm new to SQL Server DB, I'm moving a Development DB to QA DBwhat are the different ways i can do that? Please reply me ASAP...With RegardsJayaraj Daniel Albert.S  |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-09-18 : 08:22:25
|
One of the ways is to take backup at development and restore it in QAPS:What is wrong with natural font and colour?  MadhivananFailing to plan is Planning to fail |
 |
|
|
Jayarajdaniel.Sundarraj
Starting Member
4 Posts |
Posted - 2009-09-21 : 00:40:31
|
| Hello Madhivananwhat are the other way then restoring the DB by using Back UP? |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-09-22 : 02:49:51
|
quote:
Originally posted by Jayarajdaniel.Sundarraj
Hello Madhivananwhat are the other way then restoring the DB by using Back UP?
Detach and attachMadhivananFailing to plan is Planning to fail |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2009-09-22 : 12:52:24
|
| Do you need the data or just the structure? I prefer to script everything and then execute those scripts to build my new version.--------------------------------------------Brand yourself at EmeraldCityDomains.com |
|
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2009-09-23 : 08:29:10
|
| Beaware of proper security implementation on QA after restore copy from DEV.With RegardsBSR |
|
|
|
|
|
|
Want to Move DEV DB to QA - SQL 2005...