>Does anyone have any thoughts on the implementation of a VFP linked database in SS? We have a client that is proposing this as a means to incrementally move their database.
>
>Thoughts, observations, personal experience, etc are welcome.

I have done this once, since the data we needed were from a FPW2.6 application that is to be re-written in VFP7/SQLServer.

My first tip would be to access (SELECT, INSERT, UPDATE, DELETE) your VFP database exclusively through stored proc. The reason is that every query must be made with an OPENQUERY() command, such as:

SELECT * FROM OPENQUERY(LinkedServerName, 'SELECT Field1, Field2 FROM VFPTable WHERE Field3 = "Something"') VFPTableAlias

So when/if you plan on moving the data entirely on SQLServer, you won't need to hunt through your code to rewrite your queries without OpenQuery(). (Read: that's a mistake I've made)

And yes, you'll be able to insert/update/delete your VFP tables using the same OPENQUERY() function in the FROM clause of your queries.

HTH!