![]() In Toad for SQL Server, when you are exporting data from a grid, choose the ‘SQL Script’ option, that is the equivalent to the ‘Insert Statement’ exports in Toad for Oracle. Of course if you have any specific questions on features you enjoy in Toad for Oracle that you are having problems with in Toad for SQL Server, then drop me a line on Twitter or feel free to leave a comment here. You can always re-open this wizard on demand. If we had to pay then I would strongly recommend PL/SQL Developer for database code writting and TOAD for administration tasks. This allows you to make the product behave a bit more like Toad for Oracle out-of-the-box. 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. ![]()
0 Comments
Leave a Reply. |