moving sql 6.5

how do I transfer a sql 6.5 database to a new server, with the same version
of sql, 6.5? I have to transfer the devicesm database and loggins, retaining
the user permissions on the new server.
Thanks.For the database, I recommend that you use DUMP and LOAD. Just make sure
that you run sp_help_revdatabase on the source server. That will tell you
how to create the database on the dest server before you do the restore. As
for logins, just create them on the dest server, and you then map the users
using sp_change_users_login.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"miclos" <anonymous@.discussions.microsoft.com> wrote in message
news:3FDD5595-8073-452E-AC8A-E03C50E156B2@.microsoft.com...
> how do I transfer a sql 6.5 database to a new server, with the same
version of sql, 6.5? I have to transfer the devicesm database and loggins,
retaining the user permissions on the new server.
> Thanks.