calgarypowerup

Deploying it Via SCCM 2007 1. Go to the below link to extract the MSI's from the setup.exe http://us-downloads.quest.com/Repository/support.quest.com/Toad%20for%20Oracle/11.0/Documentation/11%20Release%202/ToadForOracle_11.0R2_BaseEdition_InstallationGuide.pdf 2. Author an Install script it's simple Msiexec.exe /i 'Application.msi' to install 3. Follow the Below Instructions to create a registry key(Questkey.reg) for invoking License. Windows Registry Editor Version 5.00 [HKEY_CURRENT_USERSoftware{08439167-4CA5-48E9-A810-A3A7C0B80B06}] [HKEY_CURRENT_USERSoftware{08439167-4CA5-48E9-A810-A3A7C0B80B06}Local] [HKEY_CURRENT_USERSoftware{08439167-4CA5-48E9-A810-A3A7C0B80B06}LocalKEY] 'SiteMessage'=' 'ProductName'=' 'ProductVersion'=' 4.The tougher part is invoking the License using a deployment tool (SCCM 2007), SCCM installs the s/w using a system account and wheen it has to write to a current user.you will notice the registry settings are not created.as it is running under system account, and You don't want your users to invoke license manually.. Sol: Create 2 programs for Installation (Install, InstallDBAdmin Module) 1) Install- Write the script to install the registry key silently, ---> Under Program's Environment Tab make sure you are running the program with user's rights; Progrma can run only when a user is logged on. ---> Under Program's Environment Tab; select the option Run another Program First and select 'Program2-InstallDBAdmin Module' select the options 'Always run this programs first' 2)InstallDBAdmin Module- Install script for the application. 5.Deploy the Packages, and Run the Program from 'Run Advertised programs' and there you go.! Thanks, Suresh S

The Toad Object Explorer allows you to effortlessly see objects from any database on a server instance and display detailed information for each object selected. The advanced data grid allows data entry or deletion, as well as the ability to filter, sort, or group the data to your specifications. Performing multiple server administration from a single interface is fast, accurate, and easy by accessing our security migrations dialogue box, or from our compare and synchronize tool for database, servers, and data. These changes can be implemented across multiple databases immediately, or saved to a script and executed in our powerful SQL Editor interface. This is an invaluable time saver, and beneficial to any administrator managing multiple machines. Toad's SQL Optimization for SQL Server is the most comprehensive tuning solution available for SQL Server environments. The SQL Optimization component offers complete SQL performance optimization with problematic SQL detection, automated SQL optimization, and benchmarking capabilities.