I am about to embark on a project developing a Visual Foxpro front-end which will eventually be accessing data using SQL7 (initially) as the back-end. My development pc is not connected to the network where SQL7 is installed.

I don't have SQL-server, but I have MSDE 2000 that comes with Visual Foxpro 7, and this is what I intend to use to test that my remote views and/or SQL-passthrough commands are working correctly.

Q. What is the easiest way of getting data (or a subset) from existing tables on the server network into my development environment. In VFP I can simply take copies of the databases (.dbc/.dcx/.dct), table (.dbf), index(.cdx), etc. files. What are the corresponding files I need to use with MSDE?

Q. Are SQL7 databases/tables compatible with MSDE 2000?

Any help would be appreciated.

Alan