Ask the Expert

Importing data from Continuity database into Banner

The organization where I work is implementing Banner, a database which appears to be built on the Oracle framework. We already have Continuity 2000, from Plexus Systems, which is a database that runs on top of SQL. Can we import data from the Continuity database into Banner? Would the configuration be difficult? We would like to keep Continuity 2000 to serve our marketing needs, and just import data from Continuity into Banner to fulfill our university reporting needs.

    Requires Free Membership to View

You can certainly write your own routines to move data from SQL Server to Oracle. And SQL Server's DTS utility can help you. However, it has been my experience that it is best to work with the vendor. Talk with your Banner vendor about how they would recommend moving data from your legacy system into their environment. They probably already have tools to help you. You really want to work with the vendor since you want to make sure the data is exactly where the application expects it to be.

This was first published in March 2007

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: