convert foxpro database to other ODBC database

Discussion:

(too old to reply)

Victoria

2004-10-07 08:21:22 UTC

Dear all,

There is an existing Foxpro application.

I want to change the Foxpro database to other databases(e.g.MySQL,SQL
server)using ODBC connection.

I have already converted the foxpro database to MySQL database.

Can anyone suggest me how should I convert the code using ODBC
connection?

And also, it is time-consuming to convert all the code?

Thanks for reply my questions.

Victoria

Bill Walter

2004-10-07 12:53:44 UTC

Permalink

Go to www.ProSysPlus.com and download Hank Fay's Video on using xCase2VPM to
create applications that can work with several different backends. The main
trick is that everything needs to be done with views and then you simply
rebuild the views to map to the appropriate database. He has a number of
tools to make the job much easier, and he takes care of a lot of the
differences in data types and SQL commands in MySQL and Oracle and some of
the others. In the video in less than an hour he creates and application in
VFP and then switches it to SQL Server, but once you are at that point he
talks about how you would also be able to point the same application at
MYSQL or other ODBC data sources. Also you can build and test everything
using a workstation based VFP database and then apply one switch to use the
same application with the backend database.

Bill Walter

Post by Victoria
Dear all,
There is an existing Foxpro application.
I want to change the Foxpro database to other databases(e.g.MySQL,SQL
server)using ODBC connection.
I have already converted the foxpro database to MySQL database.
Can anyone suggest me how should I convert the code using ODBC
connection?
And also, it is time-consuming to convert all the code?
Thanks for reply my questions.
Victoria

Victoria

2004-10-08 07:42:24 UTC

Permalink

Post by Bill Walter
Go to www.ProSysPlus.com and download Hank Fay's Video on using xCase2VPM to
create applications that can work with several different backends.

Did u mean the Online Training Videos > "Client-Server: Four Tools"
video?

Post by Bill Walter
The main trick is that everything needs to be done with views and then you
simply rebuild the views to map to the appropriate database.

I don't understand the view concept, can you explain it a little bit
more?

Post by Bill Walter
In the video in less than an hour he creates and application in
VFP and then switches it to SQL Server, but once you are at that point
he talks about how you would also be able to point the same application at
MYSQL or other ODBC data sources.

From the video, I found that he creates an application with his tool
but not Visual FoxPro. I have all the source code and project file for
the existing application. What should I do next actually?

Very thanks to answer my questions.

Victoria

Rick Bean

2004-10-11 12:45:51 UTC

Permalink

Victoria,
A lot depends on how the application was written. If it was written as a "typical" desktop application, it may require a major rewrite. If it was written using n-tier design with business and data handling levels, it could be very simple. There is no simple "one answer fits all" solution.

Rick