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 |
|
lcsgeek
Starting Member
38 Posts |
 Posted - 2005-07-13 : 09:05:57
|
| I have a SQL Server 7 database that I want to migrate to SQL Server 2000. What is the recommended method to accomplish this? I have two physical servers one running SS7 (housing all my data) and another new server running SS2000.Methods that come to mind:* using SS7 Enterprise Manager rightmouse the desired db and choose 'All Tasks' then 'Generate SQL Scripts' ensure that 'Script All Objects' is checked and click 'Ok'. Then on the SS2000 machine create a new db with the same name as on the SS7 machine and run this script using Query Analyzer.* copy the SS7 files into the DATA folder on the SS2000 maching. Then using the Enterprise Manager on SS2000 rightmouse the Databases object and choose 'All Tasks' and then 'Attach Database' option pointing to the DATA\SS7.mdf and SS7.ldf files.any information would be much appreciated.thanks |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2005-07-13 : 09:41:15
|
| Another way is to simply backup your SQL Server 7 DB and restore it on the SQL Server 2K box.In this case you don't even have to create the db first.Franco |
 |
|
|
lcsgeek
Starting Member
38 Posts |
Posted - 2005-07-13 : 11:37:39
|
| does SS2000 make changes to the db files when I access them or do I have to run some migration utility on them to bring them up to SS2000 or does SS7 and SS2000 create identical files? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-07-13 : 12:52:38
|
| Your first method is not recommended. Your second needs to ensure that the MSSQLSERVER service is stopped on the SQL Server 7.0 server prior to the copy. And yes using attach is one of the recommended approaches. The other is what franco has mentioned. You can use the upgrade wizard, but I only recommend that for upgrading from 6.5 to 7.0 or 6.5 to 2000. The wizard just isn't needed to go from 7.0 to 2000.Anyway, there are quite a few upgrade articles here. Go to the main site (www.sqlteam.com) and check out the articles.Tara |
|
|
|
lcsgeek
Starting Member
38 Posts |
Posted - 2005-07-13 : 13:24:34
|
| excellent, thanks so much - both of you. |
|
|
|
|
|
|
SS7 to SS2000 migration question