Starquest321
asked on
Pervasive SQL 2000i DB Sync
DBConvert for MS Access and PostgreSQL 2.2.1 (http://dbconvert.com/) allow me to sync from Pervasive SQL 2000i to Access? PostgreSql is Pervasive, right?
ASKER
I understand. Thanks for clearing things up ...
Are there any other tools to do this instead of dbconvert.com?
Are there any other tools to do this instead of dbconvert.com?
You might look at the Integration tool line from Pervasive.
What exactly are you trying to accomplish (why are you wanting to sync from PSQL to Access)?
What exactly are you trying to accomplish (why are you wanting to sync from PSQL to Access)?
ASKER
I am using an ancient software that originally comes from a btrieve 6.15 engine which was upgraded to 2000i. Luckily I have the DDF files which makes the data extraction possible. What I want to do is publish certain parts of the data to sharepoint.
I haven't worked much with Sharepoint but I believe it is possible to connect directly through ODBC from SHarepoint to PSQL.
ASKER
Any links/ideas?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent idea!
As far as accessing Pervasive/Btrieve data from Access, I would suggest "Linking" the tables using ODBC.