maria-discuss team mailing list archive

[Gordan Bobic <gordan.bobic@xxxxxxxxx>]

On Tue, Jul 26, 2022 at 11:04 PM <ngtech1ltd@xxxxxxxxx> 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.