Hello,
I am new here. I will have to migrate some hundred Paradox Databases (on
as many machines) to MariaDB. The best way to do so, would be something
like a script. My OSs are Linux (Debian) and Win7.
Is there some kind of documentation of the experience of someone, who
has migrated from Para
There seem to be a few scripts available for migrating from Paradox to
MySQL, and these should work with MariaDB. No idea how reliable any of
them are though - if you come across anything useful, feel free to
share, or to create a page on our Knowledge Base.
On 16/02/2016 23:25, Hugo Wau wrote:
>
Windows ships with a (32 bit) ODBC driver for Paradox. There are several
tools that may migrate from external ODBC sources to MySQL/MariaDB I of
course recommend our own SQLYog. As far as I understand from discussions
bugs.mysql.com, (Oracle) MySQL Workbench will not work with MariaDB anymore
(bu
BTW: as an ODBC driver exists, I believe you can also connect to your
Paradox database file with the "connect engine" in MariaDB and simply copy
tables to normal (InnoDB etc) MySQL/MariaDB. tables using "CREATE TABLE ..
AS SELECT * FROM .." or similar.
But one more disclamer. I never used the Conn
Hmmm - I probably overlooked one detail. To use the Connect engine with a
32 bit ODBC driver I think the server should be a 32 bit server. So you may
then want to migrate the data to a 64 bit server as 2nd step.
SQLyog (32 bit) can use the 32-bit driver and migrate data to a 64 bit
server directly
Hi,
You can always migrate to mysql then drop mariadb in on top. That is the
great thing about being a drop-in replacement.
--Justin
On Wed, Feb 17, 2016 at 8:17 AM, Peter Laursen
wrote:
> Windows ships with a (32 bit) ODBC driver for Paradox. There are several
> tools that may migrate from
Hi Hugo
You might want to look at something like Talends Data Integration Tool -
You should be able to use either the Generic JDBC or ODBC connector to
connect to the paradox data and then the MySQL Connection works very well
with mySQL drivers to connect to the Mariadb database.
Well worth the
Hello Ian,
I am still searching.
My first thought would be, to have each user produce a clear cut backup
of his total database. This would result in a lot of .db (and some .mb)
files, which then are exported (via .CSV) to be filled into the
respective MariaDB tables.
Probably I can use pxlib (i
8 matches
Mail list logo