Toad_for_Oracle_DBA功能及应用.ppt

* First, I will discuss the role of the DBA talk about some of the common DBA tasks and then go into the pains you may be experiencing. Here we can also identify some of the pains you are having. I will then go into what the ideal DBA solution looks like and follow with introducing you to the Toad DBA Suite, including the functionality, some scenarios that you might be familiar with, how the DBA Suite can help you as a DBA and how the DBA Suite will provide value to your IT Organization or company/organization as a whole Finally, I will show you the two DBA offerings that Quest provides with Toad and point out the functional differences between the two. We will conclude with Next Steps As a DBA, you are the database wrangler, you are the technical database expert in the organization. Because you manage, maintain and administer the databases, you are often held responsible when things go wrong with the environments you manage. * * The ideal solution must be able to deliver a systematic approach to simplifying database administration. This approach begins with an integrated solution that solves a wide range of challenges related to general database administration, problem resolution, database schema design, database performance optimization, schema change management, and ensuring code is production-ready. * * * * * Here is some key functionality of Toad Data Modeler… Through Database Design you can create high-quality database structures, generated automatically, following standard best-practice design methodologies You can easily Document your database structures and generate high-quality, detailed reports By Redesigning the Database you can transform existing databases and generate the new design SQL When you are Migrating to a new database, Toad Data Modeler can help by copying existing database structures to the new database platform Using Synchronization features like Generation of Alter Scripts and Model Merge or Model Update you can synchroniye a mode