Copy SQL Server 6.5 Database

I am trying to copying a version 6.5 database on one serv to another version
6. database on another server. And finally upgrade the 6.5 database to 2000.
As I have never worked with 6.5, how do I perform the copy? We have to
perform this step as the current server is dying.
OttoHi
You need to do a backup (DUMP) on the old server, copy the file over and
then a restore (LOAD) on the new 6.5 server.
You can do the dump and restore through Enterprise Manager. SQL 6.5 does not
support attach/detach.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Otto@.ITP" <OttoITP@.discussions.microsoft.com> wrote in message
news:1AA7D978-FACD-4F5F-BE42-A59CBD6D682B@.microsoft.com...
> I am trying to copying a version 6.5 database on one serv to another
version
> 6. database on another server. And finally upgrade the 6.5 database to
2000.
> As I have never worked with 6.5, how do I perform the copy? We have to
> perform this step as the current server is dying.
> Otto|||Otto,
You will need to run sp_help_revdatabase first on the existing server. This
will give you the order of allocations that were used to create the
database.
Use that information to create the exact same database structure on another
6.5 server. Then do a DATABASE DUMP from the original server and a DATABASE
RESTORE to the target server.
When doing this, remember that the sysusers table points to entries in
syslogins. The chances are very small that your users will map properly.
(I would recommend recording the rights granted to each user using
sp_helprotect, deleting the users, then recreating them with the appropriate
rights on the SS2000 server once you are done.)
RLF
"Otto@.ITP" <OttoITP@.discussions.microsoft.com> wrote in message
news:1AA7D978-FACD-4F5F-BE42-A59CBD6D682B@.microsoft.com...
> I am trying to copying a version 6.5 database on one serv to another
version
> 6. database on another server. And finally upgrade the 6.5 database to
2000.
> As I have never worked with 6.5, how do I perform the copy? We have to
> perform this step as the current server is dying.
> Otto