Hi Hwee

We may not be moving across for a while yet, so unfortunately I can't advise on anything at the moment.

From what I know about Client/Server you will need to setup various Remote Views to access the data, and any native foxpro data-command will have to be switched accordingly to suit the Server Database.

Kev

>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.