UPSIZING VFP TO MYSQL

[tatin]

I was advised to move away from .dbf as a backend data store as it is not very secure. Anyone can do an ODBC FROM MS access and make unauthorized updates. Hence I moved to MySql, which is free.

I was then faced with the problem of upsizing my my .dbc and found that the Upsizing wizard in VFP only handles Microsoft's SQL Server, neither did Mysql have an import facility for VFP .dbcs. I play around and realized that it handled MS Access Tables, so I imported my .dbc into an MS Access .mdb and then Exported them to MySql via the export file type 'ODBC Databases'. This assumes that you have a MySql/MS Access ODBC connection in place.

Good Luck

 

[craigsboyd]

tatin,

Nice tip, and certainly a good use of the tools at hand on your part.

http://www.sweetpotatosoftware.com

 

[wgcs]

FYI, MySql is no longer quite free...

MySql is now GPL (it used to be LGPL, I think), and it seems that it requires all clients accessing it as their primary data store to be GPL too:

http://www.mysql.com/company/legal/licensing/

see also:

http://fox.wikis.com/wc.dll?Wiki~MySql

- Bill

Get the best answers to your questions -- See FAQ481-4875.