1. How best to implement?
  2. What problems may arise during the transition?
  3. Are there any tools to simplify the migration process under Linux (Debian)?

    1 answer 1

    1. Migration is better done with the help of specialized tools, because it dramatically reduces the risk of base distortion. Migrating a database involves not only transferring data, but also transforming the database schema and a certain part of the server business logic of the application in the form of stored procedures.
    2. Incomplete migration, when you manually need to correct or finish individual transition points, as a consequence, high labor intensity and large labor costs of the transition. Incomplete compatibility of the application and the new database, in which the application must be partially redone.
    3. There is SQLWays ( Migrating Sybase to MySQL ) - a program for the transfer (there is a trial version with restrictions on the business logic); Microsoft Data Transformation Services - means for extracting, transforming and entering data into heterogeneous databases; There is RazorSQL - a program that allows you to export and import data in different formats between different databases.