Migrating from SQL server 7 to 2000

[dummieq]

Hi,
We have Sql server 7 running. We have installed SQL server 2000 on another machine. We now need to migrate all the data files from m/c running 7 to 2000. What are the issues involved? Should we create login and password again.

Thanks a bunch for your help..
regards

 

[JayKusch]

Here is a good link to answer most of your conversion questions.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_upgrade_5jw3.asp

Thanks

J. Kusch