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 |
|
victord
Yak Posting Veteran
64 Posts |
 Posted - 2002-04-05 : 10:30:09
|
| Dear All ,Is it possible to copy a database from a Sql7 enviroment to SQl2000 enviroment. Which method would you advice i use Backup and restore or DTS, finally what is the bottleneck i might encounter i.e unicode,sort code etc, and how do i go about solving this bottle necks.Thanks in Advance,Victord |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-04-05 : 11:07:39
|
| Upgrading a database from SQL7 to SQL2k is a pretty painless process. Backup/Restore or Detach/Attach will work. There is also a Copy Database wizard (which uses detach/attach behind the scenes). One thing you have to remember is that this is a one-way move. Once the database is on SQL2k you can't move it back to SQL7.You shouldn't see any major problems with your upgrade. Since SQL2k allows setting a collation at the database level, the database will be transferred with its original collation. However, if you are using temp tables in your code, you need to make sure that the collation for tempdb is compatible as well (or use COLLATE function all over the place, which becomes a major hassle). Also, on SQL2k you are not allowed to use lock hints when issuing queries against a linked server. Other than that you'll be fine. There was a lot of discussion about upgrading to SQL2k in the forums here, so if you run a search, you might get a few more useful ideas.---------------Strong SQL Developer wanted in the Boston area. Please e-mail if interested. |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-04-05 : 12:47:23
|
| Remember to rebuild your indexes and update your stats. Also, you will orphan all of your users. Look in the scripts forum to get my script to fix orphaned users.-Chad |
|
|
|
|
|
|
|
|
Moving a Db to SQL2000