October 6, 2002 at 6:50 pm
I am upgrading a 7.0 database to 2000 database.
There are two common methods:
1. Backup / Restore
2. Detach / Attach
Question 1:
What happens to a 7.0 database when it gets upgraded to 2000?
- internal structure changes, etc...
Question 2:
- Are there any differences between using Detach/Attach VS Backup/Restore?
October 7, 2002 at 3:58 am
Answer 1: Yes there are some internal changes and ou will not be able to move the files back to a 7 server. But mostly it is related to system tables.
Answer 2: To the best of my knowledge, only the way the file is processed for restore and attaching the server.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
October 7, 2002 at 4:24 am
The other issue for #2 may be time. Depending on drive size, network speed, etc, it might be faster to do the backup/restore rather than copying the mdf across (or maybe zipping the mdf)...or vice versa.
Andy
October 7, 2002 at 8:41 am
Can someone explain what happens to both User and System databases when they are upgraded from 7.0 to 2000?
- what exactly are those "internal changes"?
October 7, 2002 at 7:35 pm
anybody???
October 7, 2002 at 8:07 pm
Sorry, do not know everything. But a number of system tables are added to each DB for such thing as column and tables descriptions. Also new function ::fn... items are added. Soem system sp_ are altered. The file structure I believe may also be a bit different (at least the backup outputs are for sure). Also, database items such as recovery are altered to support the recovery models of 2000. I am sure there is more but I believe this is a fairly good list.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
October 7, 2002 at 8:48 pm
any known issues with upgrading a database from 7.0 to 2000?
October 7, 2002 at 10:00 pm
Following may help a bit. http://www.asapsoftware.com/microsoft/sql2000/ for
"What’s New in SQL Server 2000 ",
"SQL Server 2000 Upgrade Guide " and
"SQL 2000 Upgrade Calculator".
October 7, 2002 at 10:07 pm
BOL: Search for "New and Enhanced Features in Transact-SQL"
List include some other enhancements and new features, for replication, DTS, etc.
October 10, 2002 at 12:42 pm
Has anyone had any problems with a database after it has been upgraded from 7.0 to 2000?
(if so, solutions?)
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply