>Hector, Im still having difficulty getting the SQL server data sent as sql server data.
>
>
>The guy who is sending the data says he cannot uinderstand what I mean when I ask for the 'Data Files' and he has sent me the SQL Server data copied out to Excel.
>
>Is there any reason why these files could not be sent. From what you say, it should be just a matter of emailing me a .MDF file which should have all tables, rules etc . Then I should be able to copy them on to my PC and access them from within VFP.
>
>Am I missing something ?
He couldn't just e-mail you the MDF because SQL Server locks this file so he cannot copy it while SQL Server is running.

Yet, there are plenty of options to have him send you the files.

He could do a back up of the database, e-mail it to you, and you could restore the database in your server.

He could use SQL Server Data Transformation services to create another copy of the database (specially if he does not want to e-mail you all data in the database.)

He could also use detach to copy the database (the MDF+LDF+[NDFs]) and e-mail them to you. Although this option requires that they stop they SQL Server for a few minutes.




>
>Regards,
>
>Gerard
>
>
>
>
>
>>>Is there any problems in sending SQL as an intact Database
>>> from one location to another and then running up an app
>>> at the other site.
>>No this shouldn't be a problem. You can do this creating a back up of the database on one site and restoring it at the other side.
>>
>>You can also detach the database in one site and attach it at the other side.
>>
>>>What are the extensions in SQL (Are they like .DBC , .DBF
>>> or is everyting in one access type file like a .MDB ?
>>A database typically have an MDF and a LDF. I believe there are also NDF files.