![]() |
|
Draw the structure of the new database on Paper Based on the new business requirements, you need to draw the structure of the new database on paper. We often use MS Access at this stage because it has a got a “Documenter” tool which generates a real professional output in a relatively short time. Now you need to analyze the existing code to see how they are using the current database structure and how this usage will change based on the revised structure. For instance, if you are trying to split a long table into two separate tables, then all previous “Select *” queries on that table will be useful. Thus, all the existing code will have to be rewritten. Business - List of business/finance/loan/mortgage resources Computers - List of computer hardware/software/peripheral resources Internet - List of webhosting/webdesign/internet marketing resources Software - List of software resources Web Design - List of web design/development resources Web Hosting - List of web hosting resources Web Promotion - List of search engine optimization/internet marketing resources Web Resources - List of other web resources Recreation - List of travel/hotel/cruise resources Casino - List of online gambling/poker/blackjack/roulette resources Health - List of online pharmacy/hospital/health resources Shopping - List of online shopping/gift resources Miscellaneous - List of all other resources not stated above
You need to create a migration plan. Leaving the tech stuff aside, this basically means how you are going to transfer the data from the old data into the new database. For this you will have a write a script of some kind. This stage is very critical because you might have to adjust your new database. For instance: If in the old database you have customers table which had a name column. Now, if the revised database has firstname, middlename and lastname column then I can bet your database redesign dreams will end here as you can’t migrate the data between the two versions unless your plan includes manual typing. Now you get to design the new database structure as it should be implemented unless you have done in the very first step itself. |
| © Copyright 2006 YourBestWebMaster.com All Rights Reserved. |