Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to view SQL data
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00703957
Message ID:
00705419
Views:
8
Thanks Hector..
Regards,

Gerard


>>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform