INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

fact finding question VFP9 & MSSQL 2016

fact finding question VFP9 & MSSQL 2016

(OP)
Hi all,
This is just a fact finding question to see if anyone knows if this is possible.

Can MSSql 2016 read VFP Tables.

I was asked this question during a job interview.


Thanks!

RE: fact finding question VFP9 & MSSQL 2016

Any version of MSSQL can add other data via linked server or import it using an SSIS package and defining an OleDB source with the OleDB provider, that's valid for any other DBMS, not only DBFs.

If the question is about any new feature of native (Foxpro) DBF file access this would be news to me, but I don't think that would be integrated into the list of sources for SSIS and surely I see no reason, why T-SQL would be extended with commands acting on DBFs. T-SQL is concerned about SQL Server databases and the only other aspects of other file types are either flat files or backup files. CLR integration also opens some doors, but that's just due to whatever .NET Framework features are used. I don't see any reason, why the core database engine would be expanded to direct native DBF access.

One more aspect is also older and happened even before VFP was phased out as product, MSSQL Server had the new data type date introduced in 2008 (AFAIR, but surely in 2008R2). This definitely happend at least in parallel to VFPs retirement plans and when you consider both had to be planned earlier than announcement or release, the decision might have been made to allow for easier data transfer from DBF to MSSQL databases to be able to transfer data without much conversion and adaption troubles. But otherwise, I see no merging in of the DBF SQL engine into T-SQL, which hasn't been done long before. To continue that thought I would go off topic now about the end of VFP, I spare that part and just conclude, there is no native aspect of DBF file handling more than for any other third party database. Still, only flat files have a special role aside of native SQL tables and remote data. Other file types only are added outside the core SQL Server DB engine, eg SSMS allows you to easily take a result and store it as excel file, but that is a feature of the studio, not of the sql engine. And as I already said CLR integration also opens many doors, but not for core db engine T-SQL code. The integration into CLR Stored Procs make that even tighter, but still a separate thing, as CLR also isn't directly having native DBF handling inside, this also goes through ODBC or OleDB.

Bye, Olaf.

RE: fact finding question VFP9 & MSSQL 2016

And, of course, VFP can read and write (and create and delete) SQL Server tables (given suitable components, such as an ODBC driver).

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

RE: fact finding question VFP9 & MSSQL 2016

(OP)
Thanks Guys,
Very Helpful Information.

RE: fact finding question VFP9 & MSSQL 2016

Quote:

I was asked this question during a job interview
.

Just out of curiosity, was the interviewer asking this question to test your knowledge, or did he genuinely want to know the answer? And what did you answer him?

I don't mean to pry, so don't answer if you prefer not to (and I won't ask if you go the job).

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close