← Back to team overview

maria-discuss team mailing list archive

Re: Is there something like "best practices" to migrate from Paradox to MariaDB?

 

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
(but I may be wrong here) .

If you use 64 bit Windows, you may read this FAQ:
http://faq.webyog.com/content/17/187/en/problems-creating-a-functional-dsn-on-64-bit-windows.html
(on Windows 10 - and possibly 8./8.1 as well - Control panel ..
Administration has entries ("applets") for both 32 bit and 64 bit ODBC
drivers. On Win7 64 bit it is a little tricky to configure a 32 bit driver
as the option is pretty well hidden. The FAQ explains.

Relevant SQLyog docs here:
http://sqlyogkb.webyog.com/category/270-import-external-data
You may use the free SQLyog TRIAL for 2 weeks and import 2 tables per job -
refer: http://sqlyogkb.webyog.com/category/270-import-external-data
The "import external data" tool is available in SQLyog Enterprise and
Ultimate (but not SQLyog Professional).

Disclaimer: I never tried to import from Paradox myself.  But if you decide
to give SQLyog a try and run into issues, just contact us at support@webyog
com (or use our Forums). It should work and if it doesn't, we will fix it.

Attaching a screenshot of the 32 bit ODBC drivers in Win10 64 bit (Danish
language interface - I hope that the language is not a "blocker").



-- Peter Laursen
-- Webyog

On Wed, Feb 17, 2016 at 1:49 PM, Ian Gilfillan <ian@xxxxxxxxxxx> wrote:

> 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:
> > 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 Paradox to MySQL/MariaDB before? (I have googled for
> > days, but have not found such yet.)
> > With kind regards
> > Hugo
> >
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>

Attachment: driver.PNG
Description: PNG image


Follow ups

References