maria-discuss team mailing list archive

[Peter Laursen <peter_laursen@xxxxxxxxxx>]

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 (as the client/server protocol is the same for 32 and 64
bit servers).


-- Peter

On Wed, Feb 17, 2016 at 2:28 PM, Peter Laursen <peter_laursen@xxxxxxxxxx>
wrote:

> 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
>
>
>
> -- Peter
>
> On Wed, Feb 17, 2016 at 2:17 PM, 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
>>>
>>
>>
>