« 10G Install Successful | Main | SWAMP Projects Module Gets a Facelift »
August 12, 2005
Wilbur Applications "Moving" Along
Will and I tackled the move of a couple of the toughest schemas from Wilb over to Aero. We're about 90% done! These schemas proved to be quite a challenge as they directly interact with Banner data. The processes for connecting to Banner data are quite different on the two databases. I did manage to "move" a schema that someone else had already moved, thereby stomping all over their work, and breaking a perfectly good application. Brian was actually pretty nice when he called me considering I had just blown away a bit of his handiwork! (I'm now thinking of writing a small app that gives us a bit of information about the myriad applications UCS has written to prevent this kind of error in the future.)
The good news is that Will and I were able to put the added infrastructure in place to enable these schemas to get at the data they need to work. One application is being tested by its users to see if any hidden bugs are lurking there, and we will tackle the final schema next week.
Once all applications are safely moved to Aero, we will be in a position to shut down the Wilb database, and move forward with our ultimate goal of providing Oracle 10g to the campus community.
Posted by rossm at August 12, 2005 11:34 AM
Comments
What about the banner applications on other servers pointing to wilbur? Who is taking care of those and doing all the necessary testing?
Posted by: Summer at August 15, 2005 4:26 PM
What we are moving from Wilb is any schema with one or more packages and/or one or more tables. This would have picked up any app which had a user on Wilb, but not any apps using only a db link. I am not aware of any apps like this, but there sure could be some. I will talk with Brian and Mike S. and see if they are aware of any Banner apps. Do you know of any other specific apps like this?
Posted by: rossm at August 16, 2005 10:58 AM
Post a comment
Thanks for signing in, . Now you can comment. (sign out)
(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)