← Back to team overview

maria-discuss team mailing list archive

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

 

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 <peter_laursen@xxxxxxxxxx>
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 (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
>>
>
>
> _______________________________________________
> 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
>
>

References