A corporation has decided to move its production data off the OS 390 platform to a windows platform running the windows data center operating system.
*There are 18 terabytes of data of mission critical data that needs to be available 24 hrs a day.
*Because of the size of the customer database they need to be partitioned.
*The database must have the capability to support up to 500+ users concurrently; with potential to expand.
*Not all the users are in the same location as the data; therefore remote connectivity capability is necessary.
*The order Entry application is part of the of the suite of desktop applications, written in Microsoft Visual Basic 5.0, that automate business processes. This application provides order entry and tracking functionality, including related interfaces to manage customers, employees, and suppliers.
*There is a hot site for disaster recovery approximately 50 miles away from the primary location. The Hot site is equipped with a tape silo, tapes, and adequate DASD to perform a complete recovery. There is a T3 line that runs between the corporate office and hot site.
To present this proposal;
Which database will you use and why?
How will you move the data to the new platform?
How will you restore your data at the hot site?
What will be required to connect the database to the business application?