Using Toad for SQL Server with Google Cloud Platform - II

    Aug 9, 2018 3:31:41 PM by Deepak Vohra

    Toad for SQL Server is a client for SQL Server database. In three articles we are exploring using Toad for SQL Server with SQL Server on Google Cloud Platform. In the first article we installed SQL Server on Windows and connected to the SQL Server from a local machine using the Chrome RDP extension.  In this continuation article we install Toad for SQL Server on Windows and connect to SQL Server with Toad for SQL Server.  This article has the following sections.

    Installing Toad for SQL Server on Windows

    Connecting to SQL Server Database with Toad for SQL Server

    Choosing a Database

    Opening and Arranging Toad for SQL Server Views

    Installing Toad for SQL Server on Windows Server VM

    In this section we shall install Toad for SQL Server 6.8 on the VM instance on Google Cloud Platform. Connect to the VM instance from a local machine using Chrome RDS, as discussed in the first article.  To be able to download Toad for SQL Server on the Windows Server VM we need to add the download website to the list of trusted websites. Start Internet Explorer and from the Settings icon select Internet Options. In Internet Options select the Security tab and click on Trusted sites. Click on the Sites button. In Trusted Sites dialog add the URL http://www.quest.com to the field Add this website to the zone. Click on Add. The website gets added to the list of trusted sites. Similarly add URL https://www.toadworld.com.

    Next, enable downloads. In the Internet Options window click on the Custom level… button with the Security tab and Internet zone selected. In the Security Settings – Internet zone window scroll and select Enable for Downloads>File download and click on OK. Click on Apply followed by OK in Internet Options window.

    To download Toad for SQL Server navigate to URL https://www.toadworld.com/products#sql-server on the local machine. Click the 'Try for Free' button and fill out the registration form and navigate to the downloads page. Right-click on the Toad for SQL Server Developer Edition (64-bit) Download icon and select Copy link address as shown in Figure 1.

     dd1

    Figure 1. Copying download link for Toad for SQL Server from Download page

    We shall use the download link in a browser on the VM instance to download and install Toad for SQL Server 6.8. We have not directly downloaded on the VM instance because downloading requires filling out a registration form and the form fields may not get displayed properly on a VM instance based Windows Server.

    Open the download URL in Internet Browser on the VM instance, and the Toad for SQL Server zip file should get downloaded. Click on Save as shown in Figure 2.

    dd2

    Figure 2. Saving Downloaded Toad for SQL Server Zip File

    The download gets completed, as shown in Figure 3. Click on Open folder.

    dd3

    Figure 3. Download Completed>Open folder

    Double-click on the Toad for SQL Server application as shown in Figure 4.

    dd4

    Figure 4. Toad for SQL Server application

    Click on Run in the Open File dialog. In the User Account Control window click on Yes as shown in Figure 5 to allow the program to make changes to the VM.

    dd5

    Figure 5. User Account Control

    The Toad for SQL Server Installation wizard gets started, as shown in Figure 6. Click on Next.

    dd6

    Figure 6. Toad for SQL Server Installation wizard

    In License Agreement select I accept the license agreement and click on Next. In Destination folder select the default destination folder and click on Next as shown in Figure 7.

    dd7

    Figure 7. Selecting Destination Folder

    Select the default settings for Register File Extensions and click on Next. As we won’t be using the SQL Server Management Studio, select the option Do not install the SQL Server Management Studio as shown in Figure 8.

     dd8

    Figure 8. Selecting whether to install SQL Server Management Studio

    In Additional Properties select the default setting to Allow saving passwords and click on Next as shown in Figure 9.

    dd9

    Figure 9. Additional Properties

    SQL Server starts to get installed, as shown in Figure 10.

    dd10

    Figure 10. Installing Toad for SQL Server

    After Toad for SQL Server gets installed click on Finish as shown in Figure 11.

    dd11

    Figure 11. Toad for SQL Server successfully installed

    An Installer Information dialog prompts to restart the system for the configuration changes to take effect. Click on Yes. Toad for SQL Server is shown to be installed on Windows Server in Figure 12.

    dd12

    Figure 12. Toad For SQL Server installed

    Toad for SQL Server gets launched. In the Configuration Wizard Layout and Settings select the option that includes Toad for SQL Server and click on Finish as shown in Figure 13.

    dd13

    Figure 13. Configuration Wizard>Layout and Settings

    The Toad for SQL Server gets started, as shown in Figure 14.

    dd14

    Figure 14. Toad for SQL Server started

    Connecting to SQL Server Database with Toad for SQL Server

    In this section we shall create a connection to SQL Server running on the Windows Server VM on Google Cloud platform with Toad for SQL Server. Select Connect>New Connection as shown in Figure 15.

    dd15

    Figure 15. Connect>New Connection

    In the Create New Connection wizard the Server name is selected by default. The Authentication is selected by default to Windows Authentication, which is what we shall use. To select the database click on the ... icon for the Database field as shown in Figure 16.

    dd16

    Figure 16. Create New Connection

    In Browse Databases select the tempdb database as shown in Figure 17. Click on OK.

    dd17

    Figure 17. Browse Databases

    The tempdb gets selected. Click on Connect to connect to the database as shown in Figure 18.

    dd18

    Figure 18. Connect

    A new connection gets added in the Toad for SQL Server Connection Manager, as shown in Figure 19. The Object Explorer displays the tempdb and the tables in the database.

     

    dd19

    Figure 19. Connection added

    Select the connection in the Connection Manager and click on Tools to display the several options for the connection, including SQL Editor, Explorer, Query Builder, Find, Import, Export, and Data Generator as shown in Figure 20.

    dd20

    Figure 20. Options for a connection in Tools

    Choosing a Database

    To choose the current database click on Choose Database in Object Explorer as shown in Figure 21.

    dd21

    Figure 21. Object Explorer>Choose Database

    Select a database from the drop-down as shown in Figure 22.

    dd22

    Figure 22. Choosing a Database

     

    Opening and Arranging Toad for SQL Server  Views

    A View is an inset window in Toad for SQL Server. Commonly used Views are Connection Manager, Object Explorer, Project Manager, SQL Recall, and Output. These and other Views may be selected from Views in the toolbar, as shown in Figure 23.

    dd23

    Figure 23. Selecting Views

    As an example, add the SQL Recall and Output views as shown in Figure 24. The SQL Recall view is displayed vertically and the Output view horizontally.

    dd24

    Figure 24. Adding Views

    The Views displayed may be arranged vertically or horizontally. Individual tabs may be selected and dragged to rearrange, as shown for the SQL Recall view displayed horizontally instead of vertically,  in Figure 25.

    dd25

    Figure 25. Arranging SQL Recall View Horizontally

    Summary

    In this article we installed Toad for SQL Server on a Windows Server on EC2 and connected to the SQL Server instance running on the same Windows server.  We started to explore the different features of Toad for SQL Server by choosing a database, and opening and arranging Views. In a subsequent article we shall create a database table, add table data, explore database objects, and query table.  

     

     

     

     

     

     

    Tags: Toad for SQL Server

    Deepak Vohra

    Written by Deepak Vohra

    Deepak Vohra is an Oracle Certified Associate, Oracle Database 10g, and Sun Certified Java Programmer. Deepak has published on OTN and in Oracle Magazine.