>hi kevin,
>
>i read with interest on the discussion regarding comparing SQL-server vs Foxpro database. I have an exactly same problem here where we are thking of upgrading an old Foxpro apps to run with SQL-server. can u tell me expereince on this ? there are a few aspects that i am looking at : 1) speed comparison of foxpro apps talking to SQL-server as compared to native foxpro database. 2) effort involved in the migration. eg. changing commands like seek in foxpro to something else in Sql-server which achieve the similar result. what else we need to look out for ?
>
>hope u can help. thks.
We have developed all our system to work not only with DBFs, but with SQLServer too.
With bigger databases there real difference in speed between DBFs and SQLServer. We make the same queries to both databases.
There is totaly different way of working with data. You can not use command like SEEK in SQL Server.
You will have to use select and update statements or you should define remote views and proceed your data through that views.
May be you will be forced to change the whole framework that you are using now.
Venelina Jordanova
Outsourcing IT Services Ltd.