Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Sage BusinessWorks v6 Database Schema

Posted on 2006-11-10
1
Medium Priority
?
1,282 Views
Last Modified: 2007-12-19
Hi,
I wanted to know if anyone could tell me where I could obtain a database schema of SAGE BusinessWorks v6. I want to write crystal reports against this database and know that crystal will do the linking for me but want to see how the company has the database designed.

Thanks!!!
Mac
0
Comment
Question by:maclikes
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 18

Accepted Solution

by:
mirtheil earned 500 total points
ID: 17915994
I believe BusinessWorks  uses the Pervasive.SQL database engine.  You should look for DDF files (FILE.DDF, FIELD.DDF, and INDEX.DDF).  If you've got those, you should be able to use Crystal to access the data.  You might also check out the ODBC Datasources. BusinessWorks may already have DSNs set up.  If not, there may also be Pervasive Database Names setup.
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question