Has anyone successfully used the upsize wizard with MySQL?

[jrumbaug]

I am using VFP 8
I am using MySQL 5.0
I am using the MySQL ODBC 3.51.12

I can connect to and run a remote view from MySQL. But when I run the upsize wizard, the saved conection does not show up on the list of conections unless I select ALL ODBC conections. Then I get an error saying "SERVER TYPE IS NOT MySQL. SELECT ANOTHER DATA SOURCE." I'm trying to figure out if I'm doing something wrong, or if I should use other software for upsizing.

Jim Rumbaugh

 

[Neil Toulouse]

As far as I am aware the upsizing wizard is only for Microsoft SQL Server NOT MySQL.



I like work. It fascinates me. I can sit and look at it for hours...

 

[jrumbaug]

Thanks FatSlug,
that's good enough for me. I'll use another tool for the job.

Jim Rumbaugh

 

[Neil Toulouse]

You might find it fun(!) to write your own wizard/procedure for doing this. There are more than enough functions in VFP to tell you what your tables/fields/structures are. You just need to make sure it all fits in with the MySQL data types etc.

It's not too hard but may take some time to do.

I like work. It fascinates me. I can sit and look at it for hours...

 

[JimWWinter]

You might want to check out DBDesigner 4 from

http://www.fabforce.net/dbdesigner4).

A very good, free, tool to convert from VFP to MySql.

Rsgards,
Jim