By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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.