>We have a project vfp with back end Foxpro database we are planning to switch to SQL Server could you please give me some information will there be a lot of code changes on the front end.

I'm sure you'll get plenty of replies that say if you've used local views it shouldn't be that hard to convert.

As much as I'm sure you don't want to hear this, YES, there will be a lot of code changes involved. Why? Because the actual code that does the retrieving and updating of the records should be coded in SQL Server stored procs. The advantage that offers is the ability to test and modify those stored procs OUTSIDE of your frontend. If you go the SQL Passthrough route, any changes in the SQL code executed will require you to redistribure the EXE. Stored procs don't limit you in this way.

Also, you're probably going want to go the n-tier route with this application. That too will require code changes.

We've (Red Matrix Technologies) got a customer in Miami Lakes who has done some very solid VFP / SQL Server work using our DataClas/VFP middle-tier business object. Maybe you could take a look at what they're doing with VFP and SQL Server. Just a thought....

Hope this helps.