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@webyog.com> 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-o... (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@mariadb.org> 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp