14,494 questions
As far as I know, Dynamics and Navision run on SQL Server, so where do you get the migration idea from?
How to migrate Microsoft dynamics NAV 2018 to SQL server
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 73%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anandhswarupp
185
Reputation points
How to migrate Microsoft dynamics NAV 2018 to SQL server
SQL Server | Other
{count} votes
-
Anandhswarupp 185 Reputation points
2024-07-09T08:16:19.19+00:00 Please answer
-
Anandhswarupp 185 Reputation points
2024-07-10T04:10:19.4333333+00:00 My question is wrong
-
Anandhswarupp 185 Reputation points
2024-07-10T04:11:21.68+00:00 How to migrate files using Microsoft dynamics NAV 2018 to SQL server
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous2024-07-10T06:26:32.9933333+00:00 Hi @Anandhswarupp ,
Thank you for your kindly feedback!
I post a new comment below my last answer. May I humbly suggest that you accept Answer if they helped.
Thank you for your understanding! Your action would be helpful to other users who encounter the same issue and read this thread. :)
Best regards,
Lucy Chen
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 9%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
carlahall 0 Reputation points2024-07-10T06:31:49.82+00:00 Backup the current NAV database using SQL Server Management Studio. Install SQL Server on the new server. Restore the backup on the new SQL Server using SSMS. Open Dynamics NAV Administration Tool and update the Database Server barrierstocommunication and Database Name fields to point to the new SQL Server. Restart the NAV service instance and test to ensure everything works correctly.
-
Anonymous
2024-07-10T06:33:42.6466667+00:00 Hi @Anandhswarupp ,
I notice that you open a new thread. May I humbly suggest that you accept Answer if they helped.
Thank you for your understanding! Your action would be helpful to other users who encounter the same issue and read this thread. :)
Best regards,
Lucy Chen
-
Anonymous
2024-07-11T02:03:11.9333333+00:00 Hi @Anandhswarupp ,
Is this issue solved now? If you have any questions, please feel free to share with us.
May I humbly suggest that you accept Answer if they helped. It may help others who see the thread in seek of help.
Your action would be helpful to other users who encounter the same issue and read this thread. :)
Thanks for your understanding. Wish you have a nice day!
Best regards,
Lucy Chen
-
Anonymous
2024-07-22T06:27:51.09+00:00 Hi @Anandhswarupp ,
I hope the answers below is helpful. If you find any of them useful, please remember to mark them as the accepted answer. If you need any additional information, please feel free to let us know.
Your action would be helpful to other users who encounter the same issue and read this thread. Thank you for your understanding! :)
Best regards,
Lucy Chen
Sign in to comment
Accepted answer
-
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator2024-07-09T08:09:42.7233333+00:00 -
Anandhswarupp 185 Reputation points
2024-07-09T08:15:48.61+00:00 I received one request from user to migrate Microsoft dynamics NAV 2018 to SQL server
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 55.00000000000001%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
Balachoo 0 Reputation points2024-08-10T02:30:18.4233333+00:00 o migrate Microsoft Dynamics NAV 2018 to SQL Server, you need to backup the NAV database, restore it on the SQL Server, and then reconfigure the NAV service tier to connect to the new SQL database. This ensures smooth data transition and maintains application functionality.
Sign in to comment -
2 additional answers
Sort by: Most helpful
-
Anonymous
2024-07-10T01:57:16.33+00:00 Hi @Anandhswarupp ,
Thank you for your reaching out and welcome to Microsoft Q&A!
As Erland says, Dynamics and Navision run on SQL Server. Microsoft Dynamics 365 is a suite of intelligent business applications that help organizations manage and streamline their processes, enhance customer engagement, and make data-driven decisions. It combines ERP (Enterprise Resource Planning) and CRM (Customer Relationship Management) capabilities into one cloud-based platform. The individual applications (like Business Central) are running on a database.
So, it makes no sense to say: "How to migrate Microsoft dynamics NAV 2018 to SQL server" These are different layers where no migration process is possible.
Feel free to share your issue here if you have any concerns!
Best regards,
Lucy Chen
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
https://docs.microsoft.com/en-us/answers/support/email-notifications
-
Anonymous
2024-07-10T06:18:13.1833333+00:00 Hi @Anandhswarupp ,
Thank you for your kindly feedback!
From this article, we can get the information:
*You can use the Export Data-tier Application feature in SQL Server Management Studio (SSMS) to download your Azure SQL Database to a .bacpac file which can then be restored into an on-premise SQL Server instance with the Import Data-tier Application feature of SSMS. Once you have the database in an on-premise instance you can convert it using the Dynamics NAV development environment in the usual way. After that you can re-deploy the Dynamics NAV database to Azure SQL Database again.
Hope this can help you well!
Regards,
Lucy Chen
-
Anonymous
2024-07-15T06:04:33.2933333+00:00 Hi @Anandhswarupp ,
Is this issue solved now? If you have any questions, please feel free to share with us.
May I humbly suggest that you accept Answer if they helped. It may help others who see the thread in seek of help.
Your action would be helpful to other users who encounter the same issue and read this thread. :)
Thanks for your understanding. Wish you have a nice day!
Best regards,
Lucy Chen
Sign in to comment -
-
Balachoo 0 Reputation points
2024-08-10T02:30:50.5133333+00:00 grate Microsoft Dynamics NAV 2018 to SQL Server, you need to back up the NAV database, restore it on the SQL Server, and then reconfigure the NAV service bestgolfballs tier to connect to the new SQL database. This ensures smooth data transition and maintains application functionality.