Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pulling Data From Pervasive Database

Status
Not open for further replies.
NeilN

NeilN

IS-IT--Management
Jun 16, 2004
24
CA
For one of our clients we need to pull data out of their Pervasive ACCPAC db and into a SQL Server db on a different server (Windows 2003). What's the best way to do this? Do we need to install the entire ACCPAC client to get access to the ODBC driver?
 
Sort by date Sort by votes
No, all you need is the Pervasive client, then use ODBC. If you put the Pervasive client on the SQL server, you can use DTS to transfer the data.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

hushman
  • Locked
  • Question
Deleting quotes from Sage 300
Replies
2
Views
288
ettienne
ettienne
Hemanth3526
  • Locked
  • Question
80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG))
Replies
2
Views
502
Hemanth3526
Hemanth3526
jsh8286
  • Locked
  • Question
Can Not Access Database 49153
Replies
1
Views
172
DjangMan
DjangMan
hushman
  • Locked
  • Question
Sage 300 Changing financial year from 12 periods to 13 periods
Replies
1
Views
130
ettienne
ettienne
jsh8286
  • Locked
  • Question
One Database Slower then the Other - Terminal Server Setup
Replies
4
Views
126
jsh8286
jsh8286

Part and Inventory Search

Sponsor

Back
Top