Migration to SQL Server 2000 from SQL Server 7.0

Hi List,

Any one out there who migrated their OneWorld Xe database from SQL 7.0 to SQL 2000. Any specific procedure that you used and what problems did you face post migration. What are the pre-cautions to be taken. And any document from JDE available for this

Thanks in advance

Not our database but our Central Objects which were in SQL7 on the Deployment Server. Some of these steps may apply.

We did a fresh install, some say a fresh install is the better way to go. I think in our testing we could never get the upgrade to run completely. Anyways:

1. Proper MDAC levels on box.
2. Install SQL 2000 + SP2 for us.
3. Test vanilla.
4. Followed MS KB Article 314546 "Move Databases between computers that are running SQL Server".
- Step 1 we used attach/detach method under KB article 224071. Followed Moving Users Databases section. The others do not get moved (master, tempdb, msdb, model).
- Step 2 to transfer logins and passwords we used the script method under KB article 246133.
- Step 3 we didn't have any Orpaned users.
- Step 4 and 5 we didn't need to do.

I think that was it..good luck.

Grant

Thanks for the info Grant...

Will look it up