Linux MySQL Remote Database

[mattfitzwater]

I have a customer that wants to install the ECHI-Converter on a
Windows Server 2003 Instance and connect to a remote Linux MySQL
Database. Is this possible and if so what would the process be to
create the tables? Do I have to install the echi-converter on the
remote DB server to do the rake migrate?

[JasonGoecke]

If possible, I would recommend running the ECHI-Converter on the same
MySQL server on Linux if possible. Windows works fine as you know, but
a simplified architecture with fewer servers involved is always
better.

Having said that, if you are going to run on Windows you simply do the
same thing to create the database by using rake migrations. The key is
that you will need to install the MySQL drivers on Windows, then
accessing the remote MySQL server on Linux is no problem, as it really
does not matter where it is at.

So, the steps would be:

- On Windows Server (presuming you already have a uname, passwd, db
configured on the Linux MySQL server)

1. Install Ruby and required libraries (including MySQL stuff for
Ruby!) listed on http://echi-converter.rubyforge.org
2. Install ECHI-Converter
3. Install MySQL Libs for Windows
4. Configure your database connection details in database.yml
5. Run 'rake migration'

Thats it, the migration action will create the requisite database
schema. For a little more information on what migrations are have a
look here:

http://api.rubyonrails.org/classes/ActiveRecord/Migration.html

Good luck!