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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-07-10 : 09:17:21
|
| lathishc writes "I want to make a Test system in SQL server that is same as the production system running in another SQL server machine1)How can i do it?2)As the DB is huge, can i copy only the table structures so that the datas are not copied to Test server but only the structures later on i can copy the required datas to test servers?" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-07-10 : 09:23:51
|
| From Production, do Generate SQL Script and run it in TEST serverMadhivananFailing to plan is Planning to fail |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-07-11 : 07:32:46
|
Be careful if you set up a test system with only part of the data as it may not behave the same, and then your tests will be wasted!Kristen's first rule of testing: "Do not test a hybrid system"  Kristen |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-07-11 : 07:52:45
|
| Also beware that generating SQL scripts from production database and running them on test server will not happen smoothly if the scripts are not generated in the order of dependencies between tables For e.g. if some master table is referred by trans table and trans table creation is done first in script before master table creation, it will cause errors....Harsh AthalyeIndia."Nothing is Impossible" |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-07-11 : 08:02:19
|
| Indeedie ... the Generate Scripts tool puts all the FK definitions in a single "block", so its relatively easy to defer running them until AFTER the data has been imported, thus the sequence of data import becomes un-important.Kristen |
|
|
|
|
|
|
test system