Migrate SQL 2000 -> SQL 2008

nav-conq

Hi everbody,

i have an NAV Installation with NAV 4.01 and SQL 2000.

Can I directly migrate from 4.01 / SQL 2000 to NAV 2009 (technical Update!) / SQL 2008 :?:
Only Backup SQL 2000 and Restore in SQL 2008 ?

thanx for your answers
nav-conq

kriki

You can detach (or take offline) your db files in SQL2000 and then attach them to SQL2008. Or make a SQL backup and then restore it.
Then you open the DB with NAV2009. This will ask to convert the DB. This can take some time.

ara3n

I always suggest clients to backup through nav and create a new db in 2008.

There are issues with security and you will get odd errors. There is a blog that kine did where he ran into the issue. I've run the same issue with another client as well.

kriki

That works if the DB is not too big. If you have a BIG DB and the customer has only a small window, you need to go with faster methods than using a NAV-backup.

ara3n

Here is the blog

http://msmvps.com/blogs/kine/archive/20 ... -2005.aspx