How to move Dynamics NAV from one SQL to another SQL.

thomastthomast Member Posts: 102
Hi Everyone,

How do you move a Dynamics NAV installation from one SQL server to another on a completely different server and domain?

A reference to a description of this process would be appreciated.

Thanks.

Best Answer

Answers

  • EvREvR Member Posts: 178
    But that would clear all the users.
    There is no official migration script but if you know the new usernames and SID's you could write a simple migration codeunit or xmlport that migrates the current users. If that's useful depends of course on the number of users.
  • PoltergeistPoltergeist Member Posts: 200
    ActiveDirectory has the possibility to store the SID from the other domain into the new domain. I believe it's called SID history.
  • postsauravpostsaurav Member Posts: 708
    Hi,

    I think if both the servers are in same domain you can simply do it -

    1. Disconnect all session to the database. (Client and Navision Service Tier).
    2. Take Backup of Database. (in case of issues).
    3. Detach the database from server.
    4. Move all three files from old server to new server (mdf, ndf & ldf)
    5. If possible place files in same folder structure as of old server.
    6. If not possible place file as required.
    7. Login to new SQL Server, select attach and select the mdf file. If the path is same then system automatically picks the ndf and ldf file.
    8. if path is different select ndf and ldf manually in the attach window.
    9. Database will be moved successfully in new server.
    10. Create service account (account used to Navision Services) with appropriate permissions.
    11. Allow SQL Port in firewall (to access the sql from service tier).

    Let me know if any doubts.

    Thanks & Regards,
    Saurav Dhyani

    Do you Know this About NAV?


    Connect - Twitter | Facebook | Google + | YouTube

    Follow - Blog | Facebook Page | Google + Page
  • thomastthomast Member Posts: 102
    thank you so much guys!!! :) All very helpfull - looks like I've managed it now.
  • turnip595turnip595 Member Posts: 1
    Hi thomast, Can you share how you managed it? Did you use ADMT for your migration?
Sign In or Register to comment.