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 - 2002-03-26 : 09:15:37
|
| Deepak writes "We have an MS-SQL Server 7.0, a live database. Now we need to create another MS-SQL Server 7.0 environment, which will not be connected to the live system. The new enviroment will be used for development work on integration with other systems.Pls let me know the best way to create this environment, we want the same schema objects, data etc. in our development environment." |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-03-26 : 10:21:58
|
| you can DTS to transfer all the objects to your development system.-------------------------------------------------------------- |
 |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-03-26 : 11:49:19
|
| DTS is good, or perhaps a backup and restore.setBasedIsTheTruepath<O> |
|
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-03-27 : 05:29:34
|
| Or perhaps even an sp_detachdb followed by an sp_attachdb. and just script the SPs etc.Edited by - knookie on 03/27/2002 05:29:58 |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-03-27 : 07:52:53
|
Or you could click your heels three times and say, "There's no place like home, there's no place like home...", oh wait, sorry, wrong problem. |
|
|
|
|
|
|
Copying SQL Server 7.0 schema into another SQL Server 7.0.