Re: Converting from FM 9 to MySQL and keep both

Diego B wrote:
Hi All,

Here it is the starting point: Clinical research DB in FM 9 adv and FM
server 9 adv both on Windows platform.
The database has 10 tables, ~ 600 variables and ~ 1000 records.
I would like to convert the entire database to MySQL for a couple of
reasons:

1) Learning more about SQL
2) Being able to construct more complex queries
3) bring the Database on a *nix/LAMP system

I have read a lot of treads, many people actually ask how to do that
but there are only few replies.
One of the most common is:

1) Build another DB in MySQL, corrispondent to the FM one
2) Export all the records from FM in .cvs
3) Import in MySQL (usually with the help of PHPmyAdmin)

in alternatively someones used FmPro Migrator.

I tried to look at the Migrator but it sounds quite complex (I have to
use also perl scripts) so I would prefer a more straightforward way.

Beside this, I would like to let the two databases talk so that MySQL
is updated every let us say 20 minutes from FM in a sort of automatic
way.
I think that this can be done with ODBC and I installed successfully
ODBC drivers for FM 9, but now I do not know exactly how to proceed.

Any help would be greatly appreciated !

Happy holidays : )

Diego

mantra: FM is not meant to be a front end for MySQL
trap1: if you want server to execute anything in the way of scripts, make sure EVERY script step is web compatible. Read the server help.
trap2. be aware that data shared between FM and SQL is not 'live' , what you see is not necessarily what you may have. Reload in MySQL is usually needed to force updates.



You have 600 variables; how many fields?

An alternate to export via csv, is just to script across data to MySQL, loop through the ESS shadow table records, pushing the data to a related FM TOC. How pratical this is will depend on how many fields you have.


Suggestion; build yourself a test db pair to explore the basics involved in what you want to do
Suggestion; avoid doing anything remote; FM downloads for every sort etc, and can be very slow to execute what you might expect to be immediate.
.

Relevant Pages

  • Strange interaction between rcNG and procfs
    ... you will need to have /proc mounted in order for rcNG startup scripts ... server on a 'large' 5.4-RELEASE-p7 DB server (4GB RAM, ... MAXSSIZ bumped to 2GB in kernel config and mysql currently configured ...
    (freebsd-stable)
  • Re: Access Query w/VBScript
    ... > I have been usinging a Windows Remote Server to exercise the ASP ... none of the scripts (including the one I have ... > I have experimented with the code for connecting to MySql, ...
    (microsoft.public.scripting.vbscript)
  • RE: MySQL/PHPMyAdmin on FC3 Connection Problem
    ... // You can disable a server config entry by setting host to ''. ... MySQL server ... MySQL control user settings ... table to describe the display fields ...
    (Fedora)
  • Re: Using Access for web application?
    ... Any suggestions as to which newsgroup would be more ... The server that the web app will use in this case, ... > which technology you will decide to use as the Web server (Linux or Windows) ... Instead MySQL is being ...
    (microsoft.public.access.dataaccess.pages)
  • [UNIX] phpMyAdmin PHP Code Injection (left.php)
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... phpMyAdmin is "web-based MySQL ... does not prevent a malicious user from altering the servers configuration ... server configurations to the list of servers configuration by adding ...
    (Securiteam)