General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Moving to SQL backend
Environment versions
Network:
Windows 2003 Server
We have a mature vertical market application in 150+ sites, it started in dBase and has gradually moved through to VFP9.
Most (but not all) is rewritten into VFP9 OOP style with data objects being accessed from data input forms and those data objects doing the read/write. The reports are all VFP reports, based on either SQL queries to the back end data or direct reading of VFP tables.
We are now experiencing major issues with;
a) larger clients data slowing down due to volume of data being read across the network.
b) issues with Server 2008 R2 (documented in other threads).
Our long term plan is to move over to .Net with SQL back end (currently undergoing .Net training), but clearly that is going to take a while to complete.
What I want to know is what my short term options are? Can I use the upsizing wizard and simple change my table reads to be remote views to a SQL back end? is it that simple or will that take so long to write/debug etc that I am wasting my time?
Any thoughts / ideas welcome!
Gary.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only