Skip to main content
Solved

Migrating from MySQL to MS-SQL

  • January 3, 2022
  • 1 reply
  • 202 views
saiful murad
Jr Varsity II
Forum|alt.badge.img

We have 20 clients on MySQL (2019R2) which we plan to migrate to MS-SQL (2021R1)

What are the requirements for such migration exercise?

What would be the best practice in doing so?

Was looking at 2 options,i.e :

  1. Migrate DB from MySQL to MSSQL or
  2. Snapshot

Any advice would be greatly appreciated.

Thanks in advance.

Best answer by vkumar

Hi @saiful murad 

There is no specific recommendation from Acumatica for such migration. You may chose an approach that is more convenient for you. Snapshots may be convenient if tenant data size is small. If tenant data size is large, you can refer to following articles if you prefer to use snapshots approach.

Hope this helps,

Regards,

    K

    1 reply

    V
    Acumatica Employee
    Forum|alt.badge.img+12
    • vkumar
    • Acumatica Support Team
    • Answer
    • January 4, 2022

    Hi @saiful murad 

    There is no specific recommendation from Acumatica for such migration. You may chose an approach that is more convenient for you. Snapshots may be convenient if tenant data size is small. If tenant data size is large, you can refer to following articles if you prefer to use snapshots approach.

    Hope this helps,

    Regards,

    VijayKumarU
    J
    saiful murad
    Chris Hackett
    Terms & ConditionsCookie settingsAccessibility statement
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved