Judith Barer wrote:
> Right now I have a VFP 8.0 application that uses native VFP tables.
> If I were to switch my back end database to a database that is
> accessable over the internet would it be better to switch to mysql or
> sql server. My office does own sql server because it came with Small
> Business Server 2003 .
> Are there any costs at all to use Mysql with replication for a web
> site? We do not own the license for using Sql server on a web site
> but I understand that they are can be found on Ebay for a fraction
> of the regular cost.
>
> Also can you just take an existing app which was not designed
> initially to use mysql or sql server and using ODBC just get the data
> from the mysql or sql database without reprogramming the app? How
> well does that work?
>
> Thank you very much
>
Judith, There are major differences between the two databases. I'd first
seek out if you can live with BOTH.
Secondly, if you have a USE MyTable in your system you have rewriting to do.
You have to decide if your going to have all access via SPT's or Remove
Views?
How many people will be banging on this system, 100, 1,000, or 100,000 in a
day or a week?
Stephen Russell
S.R. & Associates
Memphis, TN 38115
901.246-0159
©2005 Stephen the Cook |
