Toad for SQLServer Freeware on cloud

1-click AWS Deployment 1-click Azure Deployment


Run faster, more reliable databases by doing more work in less time with Toad™… Features. The Generate SQL | statement/script sub-menu now has a new option, Append To Editor. AWS. Username: To connect to the operating system, 

Toad for SQL Server is a SQL Server client with all the features required to access the database, and create and manage database objects on the same Windows Server, in this article we shall create a database table, add table data, and query the table.  We shall also discuss some of the other features including setting the current connection, dropping a table, and dropping a connection. This article has the following sections. 

Creating a Database Table with the New Table Wizard 

Exploring Database Objects with Explorer 

Adding Table Data with SQL Editor 

Querying a Table 

Dropping a Table 

Disconnecting and Reconnecting 

Using Multiple Connections 

Dropping a Connection 

Stopping and Deleting a VM Instance 

Closing the RDS Connection 

Creating a Database Table with New Table Wizard 

In this section we shall create table wlslog with columns logid, category, type, servername, code and msg. To create a new database table in tempdb database select the Tables tab and click on Create a table as shown in Figure 1. 


Figure 1. Create a table 

The Create Table wizard gets started, as shown in Figure 2. The Database, Schema and table name must be selected or specified. Default settings are provided for Database and Schema. 


Figure 2. Create Table wizard 

Specify table name as wlslog and specify primary key column as logid of type int. Select the Not Null checkbox for the logid column and click on Set Primary Key to set the column as a primary key column as shown in Figure 3. 


Figure 3. Setting Primary Key Column 

Click on Add as shown in Figure 4 to add each of the other columns category, type, servername, code and msg. 


Figure 4. Adding columns 

The data type in the Type column is selected from the drop-down, as shown in Figure 5. The default data type for each new column is int. 


Figure 5. Selecting Datatype 

After adding all columns click on OK to create the table, as shown in Figure 6. 


Figure 6. Creating Table 

The confirmation dialog indicates Table successfully created. The table wlslog gets added to the Object Explorer, as shown in Figure 7. 


Figure 7. Table added in Object Explorer 

A new table provides several options, which are displayed with a right-click on a table in Object Explorer as shown in Figure 8. 


Figure 8. Displaying Table Options 

Exploring Database Objects with Explorer 

Toad for SQL Server provides the Explorer to explore database objects. Click on Explorer in the toolbar as shown in Figure 9. The Explorer is different from the Object Explorer View which is displayed by default. 


Figure 9. Explorer 

The Explorer includes its own Object Explorer. The database objects for the tempdb database are displayed in separate categories. Tabs are provided for a database’s Tables, Views and Indexes. Select the dbo.wlslog table in Object Explorer as shown in Figure 10, and tabs for the table’s Columns, Data, Statistics, Indexes, Constraints and other table-related objects get displayed. 


Figure 10. Database Table Objects 

Select the Columns tab to display the table’s columns as shown in Figure 11. 


Figure 11. Table Columns 

Select the Data tab to display the table data. Initially the table is empty, as shown by no data being displayed in Figure 12. 


Figure 12. Data 

Adding Table Data with SQL Editor 

In this section we shall add table data to the wlslog table using a SQL Editor. Click on Edit in the toolbar as shown in Figure 13 to launch a SQL Editor. 


Figure 13. SQL Edit 

Copy and paste the following SQL script in the SQL Editor. 

INSERT INTO wlslog(logid,category,type,servername,code,msgVALUES(1,’Notice’,’WebLogicServer’,’AdminServer’,’BEA-000365′,’Server state changed to STANDBY’); 

INSERT INTO wlslog(logid,category,type,servername,code,msgVALUES(2,’Notice’,’WebLogicServer’,’AdminServer’,’BEA-000365′,’Server state changed to STARTING’); 

INSERT INTO wlslog(logid,category,type,servername,code,msgVALUES(3,’Notice’,’WebLogicServer’,’AdminServer’,’BEA-000365′,’Server state changed to ADMIN’); 

INSERT INTO wlslog(logid,category,type,servername,code,msgVALUES(4,’Notice’,’WebLogicServer’,’AdminServer’,’BEA-000365′,’Server state changed to RESUMING’); 

INSERT INTO wlslog(logid,category,type,servername,code,msgVALUES(5,’Notice’,’WebLogicServer’,’AdminServer’,’BEA-000361′,’Started WebLogic AdminServer); 

INSERT INTO wlslog(logid,category,type,servername,code,msgVALUES(6,’Notice’,’WebLogicServer’,’AdminServer’,’BEA-000365′,’Server state changed to RUNNING’); 

INSERT INTO wlslog(logid,category,type,servername,code,msgVALUES(7,’Notice’,’WebLogicServer’,’AdminServer’,’BEA-000360′,’Server started in RUNNING mode’); 

Click on Execute SQL to run the SQL script as shown in Figure 14. 


Figure 14. Execute SQL 

Because AutoCommit is ON by default, the SQL transaction gets committed and data gets added and as the Messages tab in Figure 15 shows, 7 rows affected. 


Figure 15. Data Added 

The Data tab in the Explorer still does not display the data.  Click on Refresh to display the table data added as shown in Figure 16. 


Figure 16. Refresh 

Table data gets displayed in Data tab, as shown in Figure 17. 


Figure 17. Data tab displays data 

Querying a Table 

In this section we shall run a SQL query.  Click on Edit in the toolbar to launch another SQL Editor. In the SQL Editor add a SQL query statement (SELECT * FROM dbo.wlslog). The SQL Editor’s  code completion feature may be used to select the table, as shown in Figure 18. 


Figure 18. Adding SQL Query Statement 

Position the cursor at the SQL statement and click on Execute Current Statement to run the SQL statement as shown in Figure 19. 


Figure 19. Execute Current Statement 

The result set gets displayed, as shown in Figure 20. 


Figure 20. Result Set 

Dropping a Table 

To drop a table, wlslog as an example, right-click on the table in Object Explorer and select Drop one or more tables as shown in Figure 21. 


Figure 21. Drop one or more tables 

Alternatively, right-click on the dbo.wlslog table in Explorer and select Drop Table as shown in Figure 22. 


Figure 22. Drop Table 

In the Drop Table wizard click on OK as shown in Figure 23. 


Figure 23. Drop Table 

A confirmation dialog indicates that the table is dropped, as shown in Figure 24. Click on OK. 


Figure 24. Object successfully dropped 

  Disconnecting and Reconnecting 

To disconnect a connection, right-click on the connection in the Connection Manager and select Disconnect as shown in Figure 25. The option to Disconnect All connections is also provided. And the option to Reconnect a connected connection is also provided. 


Figure 25. Disconnect 

To connect, right-click on the disconnected connection and select Connect as shown in Figure 26. 


 Figure 26. Connect 

The disconnected connection gets connected. 

Using Multiple Connections 

To demonstrate using multiple connections, create another connection. Create a connection that is just like another connection. Right-click on the connection and select Create Like… as shown in Figure 27. 


 Figure 27. Create Like 

The Create New Connection dialog gets opened with the same configuration as the original connection.  Click on Connect as shown in Figure 28. 


 Figure 28. Create new Connection>Connect 

A new connection gets created with the same connection configuration as the original connection, as shown in Figure 29. 


Figure 29. New Connection that is like another connection 

With multiple connections, only one connection can be the current connection and it is the connection with a dotted square around the plug icon, as shown in Figure 30. The first connection in Figure 29 and in Figure 30 is a connection that is not connected. When a new connection is created or connected it becomes the current connection. Right-click on the first connection and select Connect. 


Figure 30. Connecting a Disconnected Connection 

The connection gets connected and becomes the current connection, as shown in Figure 31. 


Figure 31. Newly Connected Connection becomes Current Connection 

To make the other connection as current, right-click on the connection and select Set As Current as shown in Figure 32. 


Figure 32. Setting a Connection As Current 

The connection becomes the current connection as shown in Figure 33. 


 Figure 33. Connection Set as Current 

Dropping a Connection 

To drop or delete a connection right-click on the connection and select Remove as shown in Figure 34. 


 Figure 34. Removing a Connection 

In the confirmation dialog click on Yes as shown in Figure 35. 


 Figure 35. Remove Connection Verification Prompt 

The connection gets removed, as shown by two connections getting replaced by one in the Connection Manager in Figure 36.  To make the only connection as the current connection, right-click on it and select Set As Current. 


 Figure 36. Setting the Only Connection as the Current Connection 

Stopping and Deleting the VM Instance 

To stop the VM instance on Google Cloud platform select Stop from the drop-down to manage the instance as shown in Figure 37. 


 Figure 37. Stopping a VM Instance 

In the Stop VM Instance click on Stop as shown in Figure 38. 


 Figure 38. Stop VM Instance Verification 

The VM instance gets stopped, as shown in Figure 39. Click on Start to start the VM instance if needed. To delete a VM instance select Delete. 


 Figure 39. Delete 

In the Delete an instance dialog click on Delete as shown in Figure 40.


 Figure 40. Delete an instance 

The VM instance gets deleted, as indicated by VM Instances page not listing any instances in Figure 41. 


 Figure 41. VM Instance Deleted 

Closing the RDS Connection 

To disconnect an RDS connection select Disconnect in the Chrome RDS as shown in Figure 42. 


 Figure 42. Disconnect 

The connection to the VM instance in the Chrome RDS gets disconnected, as shown in Figure 43. 


Figure 43. Disconnected Connection 

 We started by creating a VM instance for SQL Server based on Windows server on Google Cloud Platform and connecting to the VM instance with Chrome RDS.  Subsequently we installed Toad for SQL Server 6.8 on the Windows Server and connected to the SQL Server instance running on the Windows server with Toad for SQL Server. We discussed different features of Toad for SQL Server, such as choosing a database, opening and arranging Views, creating a database table, adding table data, exploring database objects, querying table, dropping table, disconnecting and connecting a connection, creating a new connection, and dropping a connection.  We also discussed stopping and deleting a VM instance, and closing the Chrome RDS connection. Toad for SQL Server is a client for SQL Server and offers several other features in addition to those explored in these articles. 

Toad in the Cloud

From here, you can do a variety of things with the Oracle12 Pluggable Database. Toad is an excellent tool to use to create a pluggable database, move a pluggable database to the Oracle Cloud, and to manage your Oracle based application.

Toad Database Browser

You can now use the Toad Database Browser to view and manage the new cloud instance. This example shows the Toad Database Browser connected to a local Oracle12 container database.

The information I’ve been working with walks you through creating a clone PDB database and dropping it (but saving database files). You can then use Toad’s FTP abilities to move these database files to the Oracle Cloud.

Toad Database Browser connected to Oracle Cloud

Create from XML File

Once you get the files on the Cloud environment, connect to that instance using your new connect string in Toad and using the Database Browser again, create a PDB using ‘Create from XML Files”.

Create Pluggable Database Final Setup

Oracle will do a bunch of checks, even suggest and insert tnsnames entries, database browser setup, and even start up the new PDB.

There isn’t any reason you couldn’t just connect to the cloud instance now and do a ‘Create from Seed’.

Toad Data Pump Export

You can now use Toad’s Import/Export features to export an entire schema with data from your host database and move the export file (using Toad’s FTP again) to the Oracle Cloud connection and again using Toad to import the schema tables/indexes and data.

You are ready to roll with your application now.

Run faster, more reliable databases by doing more work in less time with Toad™ for SQL Server®. This single toolset maximizes productivity through extensive automation, intuitive workflows and built-in expertise. Plus, it complements Microsoft tools by solving key SQL Server challenges, so you can proactively manage large numbers of databases. It also makes it easy to manage change, resolve issues quickly and promote the highest levels of code quality, performance and maintainability.

The Freeware edition has certain limitations, and is not intended to be used as a TRIAL for the commercial edition of Toad for SQL Server.

Toad for SQLServer Freeware on cloud for AWS



Major Features of  Toad for SQLServer Freeware on cloud

A) Database Administration

1.Object Explorer

The Generate SQL | statement/script sub-menu now has a new option, Append To Editor. Use this command to add the generated SQL statement or script to the Editor at the location of your cursor within the Editor pane.

The Tables tab now includes a Last Updated column. To display the column, right-click a column header and select Options | Extra Columns | Last Updated.

2.Object Management

When detaching a database, Toad for SQL Server now includes the “SET SINGLE_USER” syntax in the script to put the database in single-user mode.

You can now generate a Data Script from the Export menu. Select Tools | Export | Data Script. The Generate Data Script dialog opens for the select database.

In the Alter Table dialog, the Columns page now supports multi-select on columns. Ctrl + click to select multiple columns. Then click the UP or DOWN arrows to move all selected columns.

3.Connection Manager

You can now add parameters to a SQL Server connection in the Connection Properties dialog. Toad for SQL Server includes the application name parameter with value “Toad for SQL Server” by default. You can add additional parameters if needed.

B) Query Development


You can now easily select and execute the code within a single region of a script. In the Editor, right-click within the script region you want to execute and select Select Current Region. Then press F5 to execute the code.

If you select the Include Actual Execution Plan option when executing SQL, in the Execution Plan window the tab now reads “Actual Plan” to indicate the actual plan is displayed. When the option is deselected, the tab reads “Estimated Plan” indicating the estimated plan is displayed.

The SQL Server 2012 SQL statement CREATE SEQUENCE is now included in the Code Snippets.


Installation Instructions For Windows

A) Click the Windows “Start” button and select “All Programs” and then point to Toad for SQL Server

B) RDP Connection: To connect to the operating system,

1) Connect to virtual machine using following RDP credentials :

Hostname: PublicDNS / IP of machine
Port : 3389
Username: To connect to the operating system, use RDP and the username is Administrator.
Password : Please Click here to know how to get password .

C) Other Information:

1.Default installation path: will be on your root folder “C:\Program Files (x86)\Quest Software\Toad for SQL Server Freeware 6.1”
2.Default ports:

Windows Machines: RDP Port – 3389
Http: 80
Https: 443
Configure custom inbound and outbound rules using this link

Installation Step by Step Screenshots








Toad for SQLServer Freeware on cloud

Related Posts