Moving data MySQL & filePro

[GCC Consulting]

________________________________

	From:
filepro-list-bounces+gccconsulting=comcast.net at lists.celestial.com
[mailto:filepro-list-bounces+gccconsulting=comcast.net at lists.celestial.com]
On Behalf Of Richard Hane
	Sent: Monday, September 11, 2006 4:17 PM
	To: user list
	Cc: Rick Hane
	Subject: Moving data MySQL & filePro
	
	
	Situation....
	Our network is a 5 server Windows 2000 & 2003. One of those servers
is a Lynix server.  One of our old apps is written on the Lynix in MySQL
with a Wiki front end display. I would like to move the data to our filePro
ODBC 1.0.13D09.  
	 
	BTW... I am not familar with MySQL and only sightly more familar
with Lynix.
	 
	Question...
	What would the best way to get the data to fp?  
	Can we generate a file from MySQL either in Excel format or fixed
length fields?
	Can the data be written from the Lynix to one of my Windows
machines?
	I believe MySQl is available for Windows too.  Would that be the
best was; install the Windows vesion and some how move the data between the
2 MySQL dbs?
	 
	Any help will be appreciated as this one has me stumped.
	 
	Thank you in advance,
	Rick Hane
	Controller
	DeLuxe Stitcher Company
	www.deluxestitcher.com

If you are running filePro ODBC, why not use it to link to your mySQL dbs
and then post this data to new filePro files?  This would allow you to break
the connection to MySQL.

Richard Kreiss
GCC Consulting