[Maria-discuss] Is there something like "best practices" to migrate from Paradox to MariaDB?
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
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
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
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@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
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@webyog.com> 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@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
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
Hello Ian, I am still searching. My first thought would be, to have each user produce a clear cut backup of his total database. This would result in a lot of .db (and some .mb) files, which then are exported (via .CSV) to be filled into the respective MariaDB tables. Probably I can use pxlib (in Linux) for the extraction of the Paradox data-files. An other way, I am thinking of, could be, to use ODBC to copy an entire database from Paradox to MySQL/MariaDB. I am still searching for best practices of others, which have done such migration before. With kind regards Hugo On 17.02.2016 13:49 Ian Gilfillan 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
Hi Hugo You might want to look at something like Talends Data Integration Tool - You should be able to use either the Generic JDBC or ODBC connector to connect to the paradox data and then the MySQL Connection works very well with mySQL drivers to connect to the Mariadb database. Well worth the investment of time and the free tool will let you do this Cheers Peter On Wed, Feb 17, 2016 at 7:25 AM, Hugo Wau <hugowau@gmx.net> 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
-- *Peter McLarty* *Data Analyst DBA* Compare The Market P: +61 7 3377 8952 M: +61 4 0209 4238 http://www.comparethemarket.com.au -- Compare The Market is a brand and trading name of Compare The Market (Pty) Ltd (CTM). This email is for the intended addressee and is confidential and subject to copyright. If you are not the intended addressee, confidentiality has not been waived and any use, interference with, or disclosure of this email is unauthorised. If you are not the intended addressee please immediately notify CTM and then delete the email. CTM does not warrant that this email is error or virus free.
participants (5)
-
Hugo Wau -
Ian Gilfillan -
Justin Swanhart -
Peter Laursen -
Peter Mclarty