mibuso.com
Home› SQL General
Options

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

hubi777hubi777 Member Posts: 6
edited 2008-01-04 in SQL General
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

Comments

  • Options
    kinekine Member Posts: 12,562
    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).
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Options
    hubi777hubi777 Member Posts: 6
    Thank you. We will do it that way.

    Greetings
    Hubertus
  • Options
    kinekine Member Posts: 12,562
    (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).
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.