Getting SQL-server test data 1

[aharrisreid]

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.

 

[DSummZZZ]

You will need SQL to access SQL files. You could grab a handful of SQL records and export them to flat text. From there, you should be able to import them into MSDE.
Dave S.

 

[aharrisreid]

DSummZZZ, thanks for the reply.

>>You could grab a handful of SQL records and export them to flat text. From there, you should be able to import them into MSDE.<<

Would this be something like comma-delimeted format? If so table structure would not be included. Does the flat-text format include data to reconstruct the table structure in MSDE?

TIA,
Alan

 

[DSummZZZ]

I haven't used SQL Server enough to answer your question, sorry. I have only connected to it remotely a few times in the past. I can only suggest you go to the &quot;Microsoft: SQL Server&quot; forum and present your questions. They could probably help you out.
Dave S.

 

[davidkirchner]

Easiest way of getting data from existing SQL tables?
1. Export directly to the MSDE server.
2. Stop the SQL server, Detach the database, copy the data file, reattach database, start SQL server.
Move data files to the MSDE machine, attach, reset user rights, run.

What are the corresponding files I need to use with MS SQL?
Database=.mdf
Transction Log=.ldf

Are SQL7 databases/tables compatible with MSDE 2000?
6.5 is not compatable! Not sure if SQL 2000 will read SQL 7 mdf. I know you can set compatability to version 7 in SQL 2000 ...if you can load the database. David Kirchner