1 PurposeThe Northwind Company has made the decisionto migrate their existing database system. As the contracted system providerhas decided not to renew their contract with the Northwind Company for theexisting infrastructure. The contracted system provider will cut off all theextended support for the Microsoft Server and the Oracle database 1.2 System Overview Company’s existing database is Oracle 9eand maintained on a single Microsoft Server 2003. Company decided to migratethe Oracle database to SQL SERVER 2012 database management system.
MicrosoftSQL SERVER 2012 DBMS should be hosted on a Microsoft server 2008. 1.2.1 System Description The company datais used by internal users from home office or remote region office. Allregional users can access the database remotely using virtualprivate network (VPN) connection. Thesystem is to also provide limited access to reports for customers, suppliersand shippers.
The reports and queries generated from the system usingvarious applications like Visual Basic .NET, Java, Crystal Reports, C++ andC#. Regional and Home office employeeswill be able to modify the data. NorthwindCompany has the condition that all the database tables, relationships willremain in the current configuration. 1.2.2 Assumptions and Constraints Schedule:· Make the plan and diagramthe work flow process.
· The current provider willcut off all support for the system with Northwind at the end of next sixmonths. Resource availability and skillsets · Pool the team with personshaving required technical skills for migration and testing · Create and distribute thecontact list for easy interactions between the team at any time.· Establish the work schedule sothat the DBA’s are available round the clock.· Create and distribute thecontact list for easy interactions between the team at any time.· Assign the responsibilitiesamong the pooled team members, establish their roles and theirresponsibilities.
Software: · Software license will bepurchased by Northwind Company.· Since the migrated systemwill allow regional employees to access the system through web so a web serveris required for the web portal.· The migrated system willbe host on a Microsoft server 2008 server Constraints:· Time line is limited tosix months.
· In new system there willbe limit access to the users based on their roles and access requirements.· Current database tablesand their relationships will remain in the current design and format.· All the current reportingand applications which is written in Visual Basic .NET, Java, Crystal Reports,C++ and C# will be migrated.· All the regional employerscan be access the database through web.· With the migrated systemcustomers, shippers and suppliers can have limited access with the customreporting using web portal.· Initial support of thesystem is maintained for 200 users.· Migrated system must bescalable to support up to 2,000 users of all types.
Budget There are various components that have been budgetedin the preparation of the migration plan. · Cost to maintain Microsoft SQL Server 2008· Licensed softwareMicrosoft SQL 2012 · Cost to establish webportal for web access.· Cost to pay for theDBA’s and team members · Hardware components needed to run the software applications likerouters, switches etc.,bandwidth costsThe approximate budget for purchasing the resourcesand completion of the migration process can be $1, 00,000 1.2.3 System Organization Both Home Office users and Regional users use theNorthwind Company migrated database.
Regional users use the database using VPNconnection. And the database is host on Microsoft SQL server 2008. Other userslike customers cannot use the database directly but they can access limited andcustom reports using web portal. HardwareMajor Components: Switches,Routers, Network cableIntel(x8) processor, 8GB RAM depends upon the application needs. 1.3 Glossary SQL:Structured Query LanguageMSSQL2012 : Microsoft SQL Server 2012enterprise edition 2 Management Overview Implementation of the database migration processwill involve different people each having their own role to make success theproject. DBA plays a crucial role in database migration plan and responsiblefor the success of the migration. DBA is responsible for all the technicalaspects of the migration like· Assigning well definedroles to each person involved in the migration project· Scheduling the test andproduction migrations · Performing test migrations· Performing backups of thenew databaseSo the DBA should be knowledgeable (professional) inboth Oracle and MSSQL.
The overall project is controlled by the Projectmanager. The application developer has make sure the applications designed forthe current database works correctlywith the new database once the migration is complete. 2.1 Description of Implementation This Project will follow the parallel phasedapproach.
Since parallel phase implementation is changeover process that takesplace in stages. Even if the phases of the new system are implemented the oldsystem will remain until unless the new system satisfies all the systemrequirements by the company. This section provides description of thesteps/phases involved in implementation of the project. Phase 1: Implementation Plan Northwind Company has decided to migrate thedatabase from Oracle to MSSQL 2012 to implement this first we need is theImplementation plan. Phase 2: Installing the software /hardware Next step in database migration process after theimplementation plan is to install all the required software / hardware neededto the project. Phase 3: Loading the dataNowNorthwind Company’s data migration team will migrate all the data from theoracle database and load into the MSSQL 2012. Phase 4: Testing Nowthe new system will be testing in order to check the integrity and Qualityassurance.
Data validation should be done to make surethat whether the data is migrated correctly as per the requirement from thecompany. Phase 5: TrainingUsersshould be provided with appropriate training to use the new system andperformance of the user access controls are tested. Phase 6: Go live Thisis the final phase of the process where the new system is fully implemented andready to operate. 2.2 Points-of-Contact Role Name Contact Number Business Sponsor Project/Program Manager Government Project Officer System Developer or System Maintainer Quality Assurance Manager Configuration Management Manager Security Officer Database Administrator Site Implementation Representative IV&V Representative Table2.2 – Points-of-Contact 2.
3 Major Tasks Beloware the major tasks in different phases of a database migration Implementation plan:1. Gathering all the information required for databasemigration.2. Analysis of the source content, metadata 3.
Defining the migration strategy and selecting appropriatetools4. Migration ActivitiesInstalling:Installingall the required software /hardware to migrate the data1. Installing MSSQL server 2012 enterprise edition2. Server installation MSSQL server 2008 3. Installing security software(like Norton anti-virus)4. Installing VPN for regional employees5. Setup all the hardware resources required.
6. Web portal for custom reports.Loading the data Someof the major tasks during loading the data1.
Read the data from the legacy data store2. Reformat the data and merge from multiple sources3. Write the data to the target database4. Manage data errors5. Provide reports on execution 6. Synchronize in the event that the source data must be usedduring the migration, changes in the source can be updated with the target.Testing Major tasks while testing the migrated system.1.
Testing environment setup2. Functionality of the database3. Performance4.
Data validation5. Security does the logins and users have been correctlycreated?6. VPN database access7. Web portal access8. Backup and Recovery TrainingMajortasks in Training phase 1. Set organizational Training objectives2.
Provide appropriate training to the users.3. Trained the employers Go live1. After the successful completion of all the phases themigrated database is ready to use and any further enhancements were made basedon the changed in the company requirements.2.
Providing in person support for the users.3. Analyze results4. Switch off the old2.
4 Implementation Schedule TheImplementation schedule is a chart that lists all the necessary tasks tocomplete the project along with the deadlines to complete the tasks. Belowtable is the implementation schedule for the major tasks in the project. Major tasks Start date Finish date 1 Implementation Plan 1.1 Gathering information 1.2 Analysis source 1.3 Migration strategy 1.4 Activities 2 Installing 2.
1 Setup all the hardware resources 2.2 MSSQL server installation 2008 2.3 MSSQL 2012 enterprise edition installation 2.4 Installing security(like Norton anti -virus) 2.5 Installing VPN 2.
6 Webportal 3 Loading the data 3.1 Read the data from data store 3.2 Merge the data from multiple sources 3.3 Write the data to target database 3.4 Manage data errors 3.5 Provide reports on execution 3.6 Synchronization 4 Testing 4.
1 Testing Environment setup 4.2 Functionality of the database 4.3 Performance 4.4 Data validation 4.
5 VPN data access 4.6 Checking the logins and users 4.7 Web portal access 4.8 Backup and Recovery 5 Training 5.1 Set Organizational Training objectives 5.
2 Trained employers 5.3 Provide training to users 6 Go live 2.5 Security and Privacy Securityis one of the most important step in the entire project. The DBA group appliesand administers database security.
Data security is like a layered cake. i.e.;there is a security at every layer. Norton antivirus security is used for thesecurity of the server. To use the database there should be a secured windowsauthentication or database connections. Regional employees use VPN connectionto access the database so there should be a secured connection in order toconnect to database i.e.
; logins and roles. From all these the security of thisproject is in 3 layer, 1. Server 2. Database connections 3. Web access 2.5.
1 System SecurityFeatures Atthe system security features the Norton anti-virus firewalls and safetystandards are imposed by security administrator on the server system.Fordatabase layer there should be security for the different roles and usersauthentication of the database connections. At web access level for thereshould be a security for web portal authentications for custom reports and VPNauthentication to access the database securely.
2.5.2 Security Set Up DuringImplementation1. Granting necessary privileges to the users or roles.
2. Granting specific permission on database to the differentusers. There will be a different permission for the different users/employeesof the database like system admins should have permission to access all theobjects like tables, etc. in the database. 3. Creating proper credentials (login and password) to the webusers and VPN users. 3 Implementation Support3.1 Hardware,Software, Facilities, and Materials Before begin the database migrationproject the hardware, software, facilities requirements must be clearlyidentified for the migrated system.
3.1.1Hardware1. Connecting devices :Routers, Switches, Wi-Fi routers2. Storage devices: hard drives, discs space for installingMicrosoft SQL server3. Database server 4. Web server 5. Processor: Intel (x86), CPUs 3.
1.2 Software1. Microsoft windows server 20082. Microsoft SQL server 2012 enterprise edition3. VPN software4. Norton Security Software5. SQL server Data tools like SSSM 3.
1.3 Facilities A server room for maintain the server Data center for disaster recovery A class room for providing the training on new database to employees. 3.2DocumentationDocumentationis used to solve the problems while using the new system. It demonstrate how toperform tasks involved in different phases of the migration process.
Differenttypes of documentation need for this project are 1. Server Documentation2. Database(Microsoft SQL server 2012 Enterprise Edition)Documentation3. VPN software Documentation4. Web access Documentation5. Security Documentation6. Appropriate training documentation 3.3 PersonnelA teamwith different roles like manager, developer, tester etc.
are required toimplement the database migration project. 3.3.1 Staffing Requirements 1. Project sponsor: Project sponsor has the responsibility with overall accountability ofthe project.2. Project Manager: Project manager has overallresponsibility for the successful initiation, planning, design, execution,monitoring, controlling and closure of a project.
Project Manager take the sponsors decisionson the scope, schedule and budget and delivers what they required.3. Database Administrator: DBA is responsible for ensuring the success of the migration process.Responsible for data backup and data restore.
4. Web Developer: Responsible to create user interfaces and integrating data fromdatabase. Maintain the web portal.5. System Maintainer: Responsible for maintaining all the systems by monitoring andcorrecting software detects involved in data migration process. 6. Quality Assurance : Responsible for ensuring a project meets reliability, usability, integrity , securityand performance 7.
Trainer:Responsible to provide training about migrated system to the employees and theend-users. 3.3.2 Training ofImplementation Staff Different types of training should be given fordifferent employees in the team. Below are the 4 course programs that should begiven to the team members to complete the migration project 1.
Overview Session: The team members are trained onthe general theories related to the migrating system 2. Navigate session: The team members should betrained to hands-on exercise the new software like how to manipulate thefields, sessions etc.3. Functional Training: Each team is formed withdifferent departments. Each department should be trained on the specificmodules that relate to their department4. Administrative Training: The team members should betrained on software administration like upgrades, security access 3.4 Outstanding IssuesThis subsection of the ProjectImplementation Plan states any known issues or problems relevant toimplementation planning. This section answers the question, “Are there anyspecific issues, restrictions, or limitations that must be considered as a partof the deployment?” If issues are site-specific, provide this information in Section 4,Implementation Requirements by Site.
3.5 ImplementationImpact With the new system implementation new server MSSQL windows server 2008is maintained. The Regional users connect through a VPN. Internal users willconnect the database through windows authentication. Expected to have higherstorage for backup resources. New system ensures the scalability to accept upto 2,000 users of all types.
In case of system failure or crashes or problemsin server there is less time to implement new server or restore the backupdatabase file. 3.6 PerformanceMonitoring Performancemonitoring is an important tool for ensuring that implementation and migrationof the project is successful. There are many tools that monitor the Performanceof the project for SQL server like SSMS, SQL Trace etc. SQL server performancemonitoring involves Disk Activity, Process Utilization, Memory, Monitor SQLserver. Disk Activity: It dealswith Physical Disk. The number of I/O operations waiting, % age of Disk timei.e.
; which indicates so many system requests are waiting for disk access. Process Utilization: Itshows performance of processer like % Processor time, % Privileged time (Timespent on SQL Server I/O requests), % user time (CPU spends on user processes),Queue Length (No of threads waiting for processor time) Memory: How much memory isavailable for new processes, Pages/sec (how many times the virtual memory isaccessed?) Monitor SQL server: Itinvolves Access methods, Buffer Manager, Memory Manager, Locks. Access methods: Itmeasures the allocation of SQL server database Objects. Buffer Manager: It sayshow SQL server used the memory to store data pages and the monitor the physicalI/O as SQL server reads and writes.
Memory Manager: Itprovides the estimate of how much memory SQL server is using. Locks- Average Wait time:Shows the average time needed to lock. 3.7 ConfigurationManagement InterfaceThis subsection of the Project Implementation Plan describesConfiguration Management, such as when versions will be distributed. Referencethe Configuration Management Plan.
4 Implementation Requirements by Site Here it describesall the implementation requirements which are used in successful migration ofNorthwind Company. These are the requirements which are used at NorthwindCompany Main Office. 4.1 SiteName or Identification for Site X(Northwind Company Main Office)4.1.1 Site Requirements Below are thehardware/software/database requirements which are needed at Northwind DatabaseCompany to complete the migration project successfully.
Hardware Requirements: RoutersSwitchesLAN connectionDatabase serverWeb server Software Requirements: Microsoft SQLwindows server 2008 Microsoft SQLserver Enterprise Edition 2012CISCO VPN softwareNorton Anti-virussoftware Database Requirements: Northwind Companydatabase.