maria-discuss team mailing list archive
Mailing list archive
Re: Is there something like "best practices" to migrate from Paradox to MariaDB?
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 Connect engine. You may run into
some datatype compatibility issues between Paradox and MariaDB and
ODBC/ANSI SQL). In SQLyog import-tool manual datatype mapping/conversion is
possible if defaults fail for some reason
On Wed, Feb 17, 2016 at 2:17 PM, Peter Laursen <peter_laursen@xxxxxxxxxx>
> 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:
> (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:
> 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