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 |
|
tribune
Posting Yak Master
105 Posts |
 Posted - 2002-04-16 : 13:36:58
|
| Can someone reference me a good procedure for copying databases to a SQL2k server from SQL7.0? I have found a few articles on the internet but they are not very straight forward. I need to make sure every transaction that has been made is copied so the move will be flawless. All permissions, sprocs, views, triggers, etc need to be moved as well. Thanks for your help in advance. -trib |
|
|
MuadDBA
628 Posts |
Posted - 2002-04-16 : 14:08:30
|
| What about simpy detaching from SQL7 and attaching into SQL2K? It automatically converts the DBs to the new format, and you should be good to go. |
 |
|
|
tribune
Posting Yak Master
105 Posts |
Posted - 2002-04-16 : 16:07:47
|
| I cant detach any databases because I get errors that they are in use (even when i stop sql).How have the rest of you been dealing with the sql 7 to 8 upgrade? |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-04-17 : 02:29:33
|
| Try backup and restore. Search these forums for the topic, it is well covered.-Chad |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-04-17 : 17:25:19
|
| I did detach/attach but in order to ensure nobody else was using the databases I had to set them into "dbo Use Only" mode and kill any SPIDs that were still hanging around. There are several other steps that you'll need to take including copying Logins, re-aligning DB users to server logins, update statistics, and a couple others. As Chad mentioned, there have been a handful of forum threads here that cover most of what you need.------------------------GENERAL-ly speaking... |
|
|
|
|
|
|
Moving to SQL 2000