General information
Forum:
Microsoft SQL Server
Title:
Getting test data from SQL7
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only