Welcome Guest! Log in
×

Notice

The forum is in read only mode.
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…

Topic-icon Question Is it possible to migrate tables from MariaDB to another DB (SQL Server ..)

More
03 Jul 2018 16:35 #1 by Virginie_Samson
Hello
We are having a problem with Lime Survey.
We need in a one shot to migrate tables from Maria DB to SQL Server.

I saw templates for differents DB, but not Maria DB.

Do you have any idea ?

Thanks
Virginie
More
13 Jul 2018 11:35 #2 by Adrian MATYSIAK
Hi Virginie,

If you want to replicate the tables from one database to another you should try the "Replicator Rdbms" template, that allows you to replicate schemas or particular tables with their data.

A priori MariaDB is based on MySQL so the standard metadata and templates that support MySQL should work for MariaDB as well. If you encounter any MariaDB specific problem do not hesitate to send it to the Stambia support team so we can see it, propose a solution and in case it is necessarry develop a specific metadata/template.

Regards,
Adrian MATYSIAK
More
13 Jul 2018 12:05 #3 by Virginie_Samson
Hello
It is a great idea,thanks !