• Bernard

    SQL Server 2000 will perform the necessary changes to the 7.0 database when you detach and attach.  However, as it is a new version of SQL Server, there are some items to be aware of and prepare for:

    • check the default collation of your instances
    • check your logins and users - these may have to remapped afterwards
    • I assume that you have checked all your views, procedures etc for compatibility?  
    • check your compatibility setting after attaching
    • do you have filegroups?  Is your disk structure the same on both servers?  Can you move your files if you have to?

    If you have prepared well for your migration, it should go smoothly.