Q

Importing data from Continuity database into Banner

We are implementing Banner, a database built on the Oracle framework. We already have Continuity 2000, a database that runs on top of SQL. Can we import data from the 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.
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 last published in March 2007

Dig Deeper on Oracle database design and architecture

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

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

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close