I have a very large application developed in VFP. Currently I am using a VFP
database. I need to change the back end to a SQL server. I am using VFP grid
extensively in almost all programs. What would be the best way to switch to
SQL Server.
Re: How is VFP comparing to C#/VB in terms of performance to SQL Serve ... You can't write it to your database because it's down. ... Isn't that when you throw up a box with some kind of cryptic error message and offer to report it to Microsoft before you app crashes taking the data with it? ... It is possible to write slow applications in VFP and it is equally possible to write slow applications in VB/C#. ... If the SQL server is down, where do you log the error message? ... (microsoft.public.fox.helpwanted)
Re: vfp + sql server ...Desmond wrote: ... If i use sql server as the backend database,... Many people who ask this type of question are making a decision to use VFP & ... Fox Tables versus VB and SQL Server.... (microsoft.public.fox.vfp.dbc)
Re: Local View vs Remote View ... view for SQL Server tables or the one containing the remote view for VFP ... I'm trying to create forms which will handle both VFP data and SQL Server... The VFP tables used in this case are counterparts of the ones used ... (microsoft.public.fox.helpwanted)
Re: SV: Fox to SQL Server ... I use Agent too, and I see the same thing. ...Anders' replies have 'SV:' prepended to the subject. ... >>Another way is to create a connection in a VFP datebase to the SQL Server DB ... (microsoft.public.fox.programmer.exchange)
RE: Local View vs Remote View ... Some data will be from SQL Server and some from VFP.... be accessed using ODBC remote views. ...Table1 and table2 have structures ... (microsoft.public.fox.helpwanted)
