• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 461
  • Last Modified:

Can SQLServer use Btrieve tables...

I have SQLServer set up and need to replicate data from a
Btrieve database (used by a piece of software called primavera).  Is there any way I can get it to do the replication?  I don't have any admin tools for Btrieve so I can't go and tell it to be a publisher (at least, not to my knowledge).

I have gotten MS Access to use the tables by linking them though.

1 Solution
Do you only have to do this once (as in converting the data) or will both databases be used, Btrieve sending data to SQL replication like?
sloans030499Author Commented:
Both will be used.  Replication will occur once a day.

We want to (daily) pull from the btrieve to the SQL Server for performance reasons.
If you can set up a system DSN to the BTrieve DB then you can use Distributed Queries (using OPENQUERY or OPENROWSET) to pull the data from BTrieve and insert it into SQL Server tables.

I use them to retrieve data from DB2 tables on an AS/400 on an hourly basis.



This is one way for SQL Server to 'use' BTrieve tables.

If you have any OLE DB drivers for BTrieve you can set up the BTrieve file as a Linked Server to the SQL Server DB. This is done automatically when you run either the OPENQUERY or OPENROWSET.

Check out the SQL Online Books for more info.

Hope this points you in the right direction.

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

sloans030499Author Commented:
I tried it:

Seems like the OPENQUERY command is recognized, but it doesn't like any of the syntax, even the stuff directly from the MSDN Online Books.

I even tried the sp_addlinkedserver procedure and it couldn't find it.  We are running SQLServer 6.5

Does that make a difference?

Yes, that makes a big difference. The OPENQUERY and sp_addlinkedserver only work with SQL Server 7.0. Sorry, I assumed you had the latest version.

I don't think there is a way for SQL Server 6.5 to use the tables in your BTrieve DB files. Is it possible for you to upgrade to 7.0?

If it's possible for Primavera to dump to data to a text file, you BCP it into SQL Server. That could get complicated, though.

Good luck, and sorry about the confusion.


This question was awarded, but never cleared due to the JSP-500 errors of that time.  It was "stuck" against userID -1 versus the intended expert whom you awarded.  This corrects the problem and the expert will now receive these points; points verified.

Please click on your Member Profile and select "View Question History" to navigate through any open or locked questions you may have to update and finalize them.  If you are an EE Pro user, you can also choose Power Search to find all your open questions.

This is the Community Support link, if help is needed, along with the link to All Topics which reflects many TAs recently added.  You'll also find a link there for Experts who wish to participate in the cleanup effort of old and abandoned questions.

Thank you,
Moderator @ Experts Exchange
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now