sloans030499
asked on
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.
Help?
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.
Help?
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?
ASKER
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.
We want to (daily) pull from the btrieve to the SQL Server for performance reasons.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
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.
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.
GREETING!
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.
https://www.experts-exchange.com/jsp/qList.jsp?ta=commspt
https://www.experts-exchange.com/jsp/zonesAll.jsp
Thank you,
Moondancer
Moderator @ Experts Exchange
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.
https://www.experts-exchange.com/jsp/qList.jsp?ta=commspt
https://www.experts-exchange.com/jsp/zonesAll.jsp
Thank you,
Moondancer
Moderator @ Experts Exchange