Move Nav 3.7 (4.0 SP3) from SQL 2000 to SQL 2005/64

hubi777

Hello,
we want to move our Navision 3.7 (4.0 SP3) database from Win2000/SQL 2000 to a new server with Win2003-64/SQL 2005-64.
What is the correct way:

a) Navision backup. Create new db. Navision restore.

b) SQL backup. Export users with SQL-Script. SQL restore db and users.

We have tested b) successfully, but we are not sure that this is allowed.

Greetings
Hubertus

kine

Because for NAV the SQL is just "some" backend, without differences inversions, you can detach/attach the database from one server to another. And if you transfer the logins too, it will work (of course including re-import license file into master db and adding xp_ndo SPs).

hubi777

Thank you. We will do it that way.

Greetings
Hubertus

kine

(there are some changes in permissions on SQL 2005 and it means that somewhen the users need additional rights e.g. to change passwords etc. But it is a question of SQL itself, not NAV).