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

Send data from a Pervasive DB and MS SQL Server DB

I have two different types of databases that I want to talk to each other but I can't seem to get them to work, so I need advice on approaches.   One DB is Pervasive, the other is MS SQL Server.

What is the best method to get the two to talk?
1 Solution
Are you looking for one-way or two-way conversations?  If you are strictly wanting to read the Pervasive data from SQL Server, you might look at Linked Servers.  If you want to maintain the data between the two databases, you might look at the Pervasive Integration products.  
define talk?

what is the system scenario?

Data Warehouse?

Bill BachPresidentCommented:
If the Pervasive database has data dictionaries, then you'll have the easiest time using DTS or SSIS from SQLServer to query the database directly.  

Much about answering the question depends on your version of Pervasive and if you have DDF's.  There are white papers that detail how to figure this all out here:
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

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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