April 10, 2003 at 11:47 am
I am in the process of migrating the information from a SQL Server 7.0 server onto a SQL Server 2000 box. The user database consists of multiple datafiles. Looking over some documentation that is here already, it says I should be able to detach the user database on the Sql srvr 7 box, copy the underlying files to the new machine and then do an attach of the database on the Sql 2000. The SQL Srvr is brand new box that only has the system databases currently installed. Have I understood this correctly? I have also seen several notes that say that the SQL Server 7 system databases are not compatible with the SQL Server databases. Do I "export" these databases from the SQL Server 7 (ex: master, model msdb) and then "import" then to the new SQL Server 2000 box?
April 10, 2003 at 12:52 pm
As you already know, you can move the database by detach and attach. You also can backup and restore it.
You can't export and import the system databases from SQL Server 7.0 to SQL Server 2000 but you can script the logins, jobs etc from 7.0 and recreate them in 2000. Remember to update database statistics after database be moved to SQL Server 2000.
April 11, 2003 at 1:26 am
Allen, what you say about export from SQLServer 7 is correct, but an import from the SQLServer 2000 of a SQLServer 7 database works fine. Detach/attach and backup/restore are usually faster, though.
If the collation is different but compatible I would go for the import, so that the collation is the same as on tempdb.
April 11, 2003 at 6:47 am
You can export/import user database but no system databases from 7.0 to 2000.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply