falostamp.blogg.se

The first time you open Toad for SQL Server it offers to step you through a quick configuration wizard. Make Toad for SQL Server a Bit More Like Toad for Oracle

The same functionality exists in Toad for SQL Server, but instead of opening a separate browser for sessions and locks, the same information is displayed in the Object Explorer. Think of this as the right-hand-side equivalent of Toad for Oracle’s Schema Browser. You can double-click on an object and it will bring up the ‘Viewer’ which displays the details for said object. You have a drop-down control to select your database much like you select your ‘Schema’ in Toad for Oracle. For example you can set it up to use the classic ‘Tabbed Multiline’ interface, or use the newer ‘Flat Tree’ view. You can configure the Object Explorer to behave just as the Schema Browser in terms of navigation. Instead, Toad for SQL Server has an Object Explorer. Of course a ‘Schema’ in SQL Server is different than a ‘Schema’ in Oracle, so having a ‘Schema Browser’ in Toad for SQL Server would only help to add a bit of confusion. Toad for SQL Server uses ‘Document Tabs’ for each ‘Window’ you have open in the application. Toad for Oracle is a classic Windows application that utilizes a classic MDI presentation. This is a quick cheat sheet for getting started using Toad for SQL Server if you are already used to using Toad for Oracle.