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 first published in March 2007

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

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:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close