General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Minimizing code changes when moving to SQL Server
I'm beginning a migration of our application from using VFP tables to using SQL Server. Rewriting the biz objects isn't too difficult since I've got some basic table insert/delete/update code. I've got a lot of report code though that for speed reasons, accesses the VFP tables directly to pull data. How can I minimze the changes to the report code when migrating to SQL Server 2005? Can I create a FoxPro remote view on the fly at the start of each report, that references the SQL tables, then from then on the code thinks it is accessing VFP tables?
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