Pervasive SQL to MS SQL

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Strategies » Pervasive SQL to MS SQL

Pervasive SQL to MS SQL

Rate Topic

Display Mode

Topic Options

Author

Message

krypto69

Posted Monday, August 13, 2012 12:16 PM

SSChasing Mays

Group: General Forum Members
Last Login: Today @ 7:09 AM
Points: 652, Visits: 1,574

I have attached a document from one of our outside developers.

The project is that they need to connect to a IBM (Maximo) DB (push and pull) to get info need for our purchase order system.

I have never worked with a Pervasive DB before.

In looking at the attached doc I have some questions:

Are the 'staging tables' needed?

Can't they link directly on both sides?

Assuming there is a pipe between the two sites, can I add a linked server? Or no because it's not SQL?

Thoughts, comments, ideas welcomed!

Post Attachments

Maximo to Platinum Interface Processing.xlsx (3 views, 24.09 KB)

Post #1344341

« Prev Topic | Next Topic »

Permissions