On Tue, Jul 26, 2022 at 11:04 PM <ngtech1ltd@gmail.com> wrote:
Hey Gordon,
Before I am filing a jira bug report I would like to verify how the same queries are running on other DB ie: * MSSQL * PostgreSQL * Oracle DB
You are probably going to have to ask that question on forums where the primary interest are those respective databases.
Are there any recommended tools to migrate the data from MariaDB to PostgreSQL or MSSQL?
Migrating to completely different databases is not something you can do without a non-trivial amount of effort, unless your application and requirements are pretty trivial. You are going to have to at the very least make changes to your application to address various incompatibilities in the SQL dialects and features.
Specifically MSSQL has a migration tool but I have yet to use it so I am looking for whatever recommendations. Any MariaDB to PostgreSQL transferring tool known to anyone?
In theory, mysqldump has an option for formatting the output so that it is more easy to ingest into other databases. In reality, unless your data and structures are very trivial, you will still have to thump the output to make the ingestion process work.
I can try to re-create the scenario just with the relevant tables and it would be pretty simple to do eventually but time consuming if there is any automated tools for that.
Any Recommendation is more then welcome!
The recommendation I can give you is that if you are looking at migrating to a completely different database just to avoid using an index hint, you probably haven't thought through the complexities of migrating between databases.