Getting a serial number for WinSQL. You need a serial number if you. There is no difference in the actual download for WinSQL Lite, Developer or Professional. Synametrics Technologies WinSQL Professional User s Guide Version 8.5. You can obtain a serial number for WinSQL Professional Lite at no charge from our. It allows you to calculate the unlock code based on the serial number. WINSQL PROFESSIONAL KEYGEN Find Serial Number notice: WinSQL Pro serial number.

  1. Winsql Tutorials
Start display at page:
Download 'Synametrics Technologies. WinSQL Professional User s Guide Version 8.5'
  • Gerald Wood
  • 3 years ago
  • Views:

Transcription

1 Synametrics Technologies WinSQL Professional User s Guide Version 8.5 August 20, 2010

2 Copyright notice Copyright 2010 Synametrics Technologies, a division of IndusSoft Technologies, Inc. and/or one of its subsidiaries. All rights reserved. Use of this documentation and related software is governed by a license agreement. This documentation and related software contain confidential, proprietary and trade secret information of Synametrics Technologies and are protected under United States and international copyright and other intellectual property laws. Use, disclosure, reproduction, modification, distribution, or storage in a retrieval system in any form or by any means is prohibited without the prior express written permission of Synametrics Technologies. This documentation and related software are subject to change without notice. Publication date August 2010 Product and version WinSQL Professional 8.5 Reader comments Any comments or suggestions regarding this publication are should be forwarded to the attention of: 666 Plainsboro Road Suite 656 Plainsboro, NJ or sent by to: Trademarks WinSQL Professional is a registered trademark of Synametrics Technologies, a division of IndusSoft Technologies, Inc. Portions of this software are copyrighted by DataDirect Technologies. Windows is a registered trademark of Microsoft Corporation in the United States and/or other countries. All other product or company names may be trademarks or registered trademarks of their respective companies. ii Release 8.5 August 2010

3 Table of Contents Table of Contents About This Document.. viii Document Conventions.. ix Chapter 1: Getting Started.. 1 Overview.. 1 Requirements.. 2 Installation and Set Up.. 3 Obtaining a Serial Number.. 4 Registering WinSQL Professional ODBC Drivers.. 5 Configuring ODBC.. 7 Creating ODBC Connections.. 7 Establishing a Database Connection Connection Strings Sample Connection Strings Connection Options Uninstalling WinSQL Professional Customizing Shortcut Keys Chapter 2: Running Queries Overview Screen Layout Integrated View Classic View Switching Views Writing SQL Scripts Query Pages Query Set Workbook Using Clipboard Extended Copy - Code Extended Copy - Results Displaying Query Results Modifying results displayed in Grid Modifying results displayed in Text Modifying results displayed in Form Viewing BLOB/CLOB Data Searching for Text August 2010 Release 8.5 iii

4 Table of Contents Printing Results Exporting Grid Content Intelli Tips Table Joins Data Lookup Configuring Data Lookup Display Options Modifying SQL Queries to Retrieve Data Drill-down Results Query History Comments with SQL Statements Query Syntax and SQL Grammar Parameterized Queries Generate Code SQL Wizard Show Native SQL Scripting Wizard Chapter 3: Configuration Options Overview General Tab SQL Editor Tab Editor Options Tab Intelli Tips Tab Advanced Options Tab Chapter 4: Supported Functions Overview Scalar Functions String Functions Numeric Functions Time, Date, and Interval Functions System Functions Chapter 5: Database Catalog Overview About the Database Catalog Database Catalog Caching Enabling Catalog Caching Viewing the Database Catalog Exploring Objects in the Catalog iv Release 8.5 August 2010

5 Table of Contents Providing Filters Browsing Data Using the Quick Math Feature Applying Filters Adding User Comments Creating Local and Shared Comments Using the Insert/Update Record Wizard Using Strings and Dates Ignoring Fields and NULL Values Adding BLOB and CLOB Data Managing Relationships Creating Local Relationships Deleting Relationships Executing Stored Procedures Using the New Table Wizard Reverse Engineering a Table Design Printing Database Search Wizard Using the Database Search Wizard Chapter 6: Using the Database Task Scheduler Overview About the Task Scheduler Types of Tasks Creating a Task to Run a SQL Script Chapter 7: Publishing HTML Pages Overview Using Export Templates Creating a New HTML Template Using an Existing HTML Template Chapter 8: Using Database Diff Overview Database Diff Wizards Schema Diff Wizard Comparing Objects Using Schema Diff Primary Objects and Detail Options Data Diff Wizard Comparing Objects Using Data Diff August 2010 Release 8.5 v

6 Table of Contents Running Database Comparisons Chapter 9: Generating Test Data Overview Creating a Test Environment Starting the Test Data Generation Wizard Specifying Formatted Data Chapter 10: Entity-Relationship Diagrams Overview Creating an E/R Diagram Chapter 11: Exporting and Importing Data Overview Exporting Data Exporting Data to Another Data Source Connected Disconnected Importing a DataBag into a Target Database Quick Transfer to a Text File Enhanced Transfer to a Text File Exporting Data From an SQL Query Target table name Exporting to an External Database Using Existing Templates Export to INSERT Scripts Exporting Data From a Table Exporting to an Executable File Generating Parameterized Executables Importing Text Files Importing a Delimited Text File Importing a Fixed Width Text File Importing from Microsoft Excel Chapter 12: Offline Backup/Restore Overview Backing Up a Database Restoring a Database vi Release 8.5 August 2010

7 Table of Contents Chapter 13: Database-Specific Plug-Ins Overview Overview of Database Plug-Ins Chapter 14: Administrative Tasks Overview Wizards Used For Administrative Tasks Available Wizards Chapter 15: Command Line Processing Overview Command Line Options Command Line Syntax Command Line Examples Running Scripts From a Command Line Script Functions Sample Scripts Troubleshooting Common Problems Index Revision History August 2010 Release 8.5 vii

8 About This Document About This Document Overview WinSQL Professional is a utility designed to interact with many different types of databases. This WinSQL Professional User's Guide is designed to provide details instructions for installing, configuring, and using the program. It also includes information about more advanced features, such as data export, test data generation and schema diff. Audience The is designed for use by database administrators, system administrators, programmers, and other technical staff. viii Release 8.5 August 2010

9 About This Document Document Conventions The following conventions are used throughout this document: Convention Keyboard keys and function keys Key combinations Execution icons Menu names and options Window names Text variables Numeric variables Description Begin with an uppercase letter and appear in bold type, enclosed in brackets; for example, [Enter] or [F1]. Are enclosed in brackets and appear in bold type If joined with a plus sign (+), press and hold the first and second key simultaneously; for example, Press [Ctrl+B]. Begin with uppercase letters and appear in bold type, for example, OK. Begin with uppercase letters and appear in bold type; for example, On the Edit menu, click Options. Begin with uppercase letters and appear in bold type; for example, the Configuration window is displayed. Are enclosed in angle brackets; for example, <file_name>. Are represented by a letter; for example, x. In addition, the following special formats are used: Format Green text Courier Indicates a hyperlink to another section of this document or to a web site text of a message displayed in a window Courier bold text that you must type in a window August 2010 Release 8.5 ix

10 About This Document Format Bold Italics Indicates a reference to a window or to an object in a window, such as an icon, field, or column; also indicates emphasis on a critical instruction or step a reference to another document; also indicates emphasis on certain words (Example: do not delete this file) x Release 8.5 August 2010

11 Chapter 1: Getting Started Chapter 1: Getting Started Overview Introduction This chapter provides information about downloading, installing, and configuring WinSQL Professional. In this chapter This chapter contains the following topics: Topic Requirements 2 Installation and Set Up 3 Obtaining a Serial Number 4 Registering WinSQL Professional ODBC Drivers 5 Creating ODBC Connections 7 Establishing a Database Connection 10 Sample Connection Strings 12 Connection Options 17 Uninstalling WinSQL Professional 19 See Page Customizing Shortcut Keys 20 August 2010 Release 8.5 1

12 Chapter 1: Getting Started Requirements WinSQL Professional is a 32-bit program that runs only on Microsoft Windows XP, Windows 2000, Windows 2003 and Windows Vista. It uses ODBC to connect to any target database for which a driver is available. WinSQL Professional requires that you use ODBC Manager version 3.x or higher. Although version 3.x is required as the ODBC Manager, you can use a driver that is compliant with version 2.x. However, if you use an older driver, you may not be able to use all of the features of WinSQL Professional. To confirm the version of ODBC Administrator currently installed, click Help, and then click About in the ODBC Data Source Administrator window. If version 3.x or higher is not installed, download the most current version from 2 Release 8.5 August 2010

13 Chapter 1: Getting Started Installation and Set Up Regardless of the version of WinSQL Professional you are using, you will always download and unzip (using WinZip ) the same executable file. These executable files are available in two different types of packaging, as described in the following table: File Name WinSQL.zip Description An installation program for WinSQL Professional. Extract the setup executable from the zipped file and follow instructions on the screen to install WinSQL Professional using this file. This is the recommended installation method. WinSQLRaw.zip WinSQLUpgrade.zip This is a zipped file that contains all necessary executable files and ODBC drivers. However, this file does not contain an installer. Files must be manually copied to the directory of your choice, and the icons for the program must be manually created. Use this file if you are upgrading from version 4.7 or 5.0. If you have version 4.6 or earlier installed, we recommend that you uninstall and reinstall version 5.5. This file does NOT contain every file it only includes the main executable file and updated database plug-ins. August 2010 Release 8.5 3

14 Chapter 1: Getting Started Obtaining a Serial Number A serial number is required within the first 30 days of using WinSQL Professional. This serial number determines the edition for which you are licensed. You can obtain a serial number for WinSQL Professional Lite at no charge from our website ( When you download WinSQL Professional from Synametrics Technologies Web site, a serial number for WinSQL Professional Lite is delivered to you. If you decide to purchase either the WinSQL Professional Developer or WinSQL Professional version, you must contact Synametrics Technologies for a different serial number to convert your existing installation. 4 Release 8.5 August 2010

15 Chapter 1: Getting Started Registering WinSQL Professional ODBC Drivers If using the ODBC drivers installed with WinSQL Professional, they must be registered prior to using WinSQL Professional. Registering the drivers configures them so that they appear in ODBC Manager in Windows Control Panel. The first time you run WinSQL Professional, the following window is displayed: The WinSQL ODBC Installer window displays all the available drivers installed with WinSQL Professional. The installation status is displayed next to the name of every driver. You may choose to register only the drivers that you want to use, or select all of them. Synametrics Technologies recommends that you register all the drivers. Notes: To re-register or unregister a driver, click Help, and then click Register ODBC Drivers within WinSQL Professional. When drivers are unregistered, all associated data source names (DSNs) are also removed. WinSQL Professional works with all ODBC drivers, regardless of the manufacturer. August 2010 Release 8.5 5

16 Chapter 1: Getting Started Therefore, you do not have to register these drivers if you are planning to use a different driver to connect to your database. 6 Release 8.5 August 2010

17 Chapter 1: Getting Started Configuring ODBC Configuring ODBC and creating data sources is required before WinSQL Professional can be used for database management. The following topics describe these procedures. Creating ODBC Connections Perform the following steps to create ODBC connections: 1 From the Start menu, click Control Panel. 2 Click Administrative Tools. 3 Double-click the ODBC Data Sources (32bit) or the Data Sources (ODBC) icon. The ODBC Data Source Administrator window is displayed: Three different types of DSNs can be created: User DSN - These data sources are local to a computer, and may only be used by the current user. System DSN - These data sources are local to a computer, rather than dedicated to a user. The system, or any user having privileges on the system, can use a data source set up with a system DSN. August 2010 Release 8.5 7

18 Chapter 1: Getting Started File DSN - These are file-based data sources that may be shared between all users that have the same drivers installed and who have access to the database. These data sources are not machine- or user-specific. Determine the type of DNS you need. The following steps, as an example, describe how to create an MS-SQL Server database (System DSN) connection: 1 From the ODBC Data Source Administrator window, click the System DSN tab. 2 Click Add. The window that is displayed lists all the ODBC drivers installed on the computer. 3 Click to select SQL Server: 4 Click Finish. The following window is displayed: Note: The following screen may look different if you are connecting to a database other than MS SQL Server. 8 Release 8.5 August 2010

19 Chapter 1: Getting Started 5 Enter the desired name in the Name field. 6 Enter an arbitrary description in the Description field. 7 Enter the server s host name or IP address in the Which SQL Server do you want to connect to? field. 8 Click Next. Follow the instructions on the screen to complete this step. Depending upon the back-end database to which you are connecting, the screens may look different on your machine. August 2010 Release 8.5 9

20 Chapter 1: Getting Started Establishing a Database Connection Running queries against a database requires that a DSN be created. After performing the steps described in Creating ODBC Connections, perform the following steps to connect to the database: 1 From the File menu, click New Connection. 2 Select the desired DSN in the Data Source Name drop-down list. 3 Enter the appropriate user ID in the User ID field. 4 Enter the appropriate password in the Password field. The ODBC Data Source window should be completed as follows: 5 Click OK to connect to the database. 10 Release 8.5 August 2010

21 Chapter 1: Getting Started Connection Strings A connection string is a set of connection parameters that tell WinSQL Professional how to connect to a remote database. If you want to use a connection string for connecting to a database, or if your application requires it, you must specify a DSN (data source name), a File DSN, or a DSN-less connection in the string. The difference is whether you use the DSN=, FILEDSN=, or the DRIVER= keyword in the connection string, as described in the ODBC specification. A DSN or FILEDSN connection string tells the driver where to find the default connection information. Optionally, you may specify attribute=value pairs in the connection string to override the default values stored in the data source. Beginning with ODBC Administrator version 4.0, a DSN is not required to establish a database connection. To use a connection string rather than a DSN connection, click the Specify connection string checkbox. The following window is displayed: August 2010 Release

22 Chapter 1: Getting Started Choose one of the following connection string types and use the accompanying format as an example for creating your entry: DSN connection, which uses the following format: DSN=data_source_name[;attribute=value[ ;attribute=value]..] File DSN connection, which uses the following format: FILEDSN=filename.dsn[;attribute=value[ ;attribute=value]..] DSN-less connection, which uses a specific driver instead of a data source, and uses the following format: DRIVER=[{]driver_name[}][;attribute=va lue[;attribute=value]..] If you are unsure about what to enter here, delete everything from the text box and click OK. The ODBC Driver manager window will display, and you can select the data source to which you wish to connect. WinSQL Professional captures the connection string that is used by the ODBC Driver manager and saves it for future use. The next time you establish connection, this text box will be completed for you. Sample Connection Strings The following is a list of connection string formats for the most common database types: DBase / FoxPro Firebird Driver={Microsoft dbase Driver (*.dbf)};dbq=<c:data>; Where <c:data> is the folder where the files are stored DRIVER=Firebird/InterBase(r) driver;uid=sysdba;pwd=secret;dbname =<c:data>test.fdb 12 Release 8.5 August 2010

23 Chapter 1: Getting Started Where the database resides in the <c:data> folder Informix Using WinSQL Professional Informix Wire Protocol DRIVER={WinSQL Professional Informix Wire Protocol};uid=yourID;PWD=secret;hos t=yourserverip;port=1526;db=yourdat abase;srvr=ol_yourdb Using Informix driver from IBM Driver={INFORMIX BIT};Host=hostname;Server=myserver; Service=ol_yourdb;Protocol=olsoctcp ;Database=mydb;UID=username;PWD=myP wd Where <ol_yourdb> represents the server name from sqlhosts file on the Informix server IBM DB2 Using WinSQL Professional DB2 Wire Protocol Driver Driver={WinSQL Professional DB2 Wire Protocol};Database=myDbName;IpAddre ss=myservername;port=myportnum;prot ocol=tcpip;uid=myusername;pwd=secre t Using IBM Driver Driver={IBM DB2 ODBC DRIVER};Database=myDbName;hostname= myservername;port=myportnum;protoco l=tcpip;uid=myusername;pwd=secret August 2010 Release

24 Chapter 1: Getting Started Mimer Driver={MIMER};Database=yourDatabas e;uid=youruserid;pwd=secret; MS Access Standard Security Driver={Microsoft Access Driver (*.mdb)};dbq=c:mydb.mdb;uid=admin; Pwd=; Workgroup Driver={Microsoft Access Driver (*.mdb)};dbq=c:mydb.mdb;systemdb=c :mydb.mdw; MS Excel Driver={Microsoft Excel Driver (*.xls)};dbq=c:myexcel.xls;default Dir=c:mypath; MS SQL Server Using SQL Server Security Driver={SQL Server};Server=YourServerIP;Databas e=yourdb;uid=sa;pwd=secret Using Trusted Connection Driver={SQL Server};Server=YourServer;Database= YourDBName;Trusted_Connection=yes Using TCP/IP with on a non-standard port Driver={SQL Server};Server= ,4321;ui d=sa;pwd=secret;database=yourdb; 14 Release 8.5 August 2010

25 Chapter 1: Getting Started MySQL DRIVER={MySQL ODBC 3.51 Driver};server=YourServerIP;PORT=33 06;database=myDatabase;user=myUsern ame;password=secret;option=3 Oracle Using WinSQL Professional Wire Protocol Driver Driver={WinSQL Professional Oracle Wire Protocol};host=tarzan;port=1521;Uid =scott; Pwd=tiger;sid=orcl Using WinSQL Professional Driver DRIVER={WinSQL Professional Oracle};uid=SCOTT;pwd=tiger;SRVR=or cl Using Microsoft Driver Driver={Microsoft ODBC for Oracle};UID=scott;PWD=tiger;SERVER= ORCL; In the previous two examples, the variable SERVER and SRVR refers to the name in TNSNAMES.ORA file on your machine. Note that WinSQL Professional Wire Protocol Driver, used in the first example, does not need TNSNAMES.ORA file. Paradox If you are using Oracle s ODBC driver, the name of the driver is different on every machine. Refer to the ODBC Data Source Administrator to obtain the driver name. August 2010 Release

26 Chapter 1: Getting Started Driver={Microsoft Paradox Driver (*.db )};DBQ=c:data;DefaultDir=<c:data >; Where <c:data> is the folder where the files are stored. PostgreSQL Driver={PostgreSQL};Server=ipaddres s;port=5432;database=yourdbname;uid =yourid;pwd=secret; Sybase Using WinSQL Professional Sybase Wire Protocol Driver={WinSQL Professional Sybase Wire Protocol};uid=sa;pwd=secret;NA=goof y,5000;db=yourdatabasename Using Sybase Open Client Driver Driver={SYBASE ASE ODBC Driver};Srvr=YourServerName;Uid=sa; Pwd=secret Text Files Using WinSQL Professional Text File driver Driver={WinSQL Professional Text File};DB=c:data Using Microsoft Text Driver Driver={Microsoft Text Driver (*.txt; *.csv)};dbq=c:data;extensions=asc,csv,tab,txt; 16 Release 8.5 August 2010

27 Chapter 1: Getting Started Connection Options Database Type / WinSQL Professional Plug-in This connection option specifies the type of database to which you are connecting, and it also specifies a database plug-in. The names displayed in this list include the database plug-ins identified by WinSQL Professional when it is started. Choice of database type is only available in WinSQL Professional. For more information about plug-ins, see Database-Specific Plug- Ins later in this document. Important note: If the database to which you are trying to connect is not displayed in the list, it does not mean you cannot connect to that database with WinSQL Professional. It means that WinSQL Professional will not be able to query specific database features, such as triggers and SQL scripts for views and stored procedures. Auto commit transactions When this option is checked, all transactions are automatically committed. Certain databases, such as Oracle, do not allow explicit transactions. Therefore, it may be useful to turn off this option, which will allow you to manually COMMIT and ROLLBACK any transaction. When this option is turned off, a red indicator appears on the status bar. This indicator is a reminder to COMMIT or ROLLBACK before closing the connection. Enable catalog caching Selection this option at connection allows WinSQL to automatically create a cached version of your database catalog on your local machine. Caching your database catalog reduces the amount of time it takes to fetch metadata information from the back-end database, which greatly increases access time to your data. When caching is enabled, WinSQL stores the contents of the Catalog Details window to a local file. The next time you connect to the same database, WinSQL loads the catalog information from this local file rather than sending queries to the database. August 2010 Release

28 Chapter 1: Getting Started For more information, see the Database Catalog Caching topic later in this document. Load catalog after connection Selecting this option allows WinSQL to fetch the database catalog immediately after establishing connection. 18 Release 8.5 August 2010

29 Chapter 1: Getting Started Uninstalling WinSQL Professional Prior to installing WinSQL Professional, you must unregister any registered ODBC drivers in WinSQL Professional. Failure to do so removes the files but does not remove registry entries. Unregister ODBC Drivers 1 Start WinSQL Professional. 2 From the Help menu, click Register ODBC drivers. 3 Select all drivers, and then click Unregister. Uninstall WinSQL Professional 1 From the Start menu, click Control Panel. 2 Double-click Add/Remove Programs. 3 Click WinSQL Professional in the list of programs that is displayed, and then click Add/Remove. 4 Click Next. 5 Click Remove, and then click Next. 6 Click Remove. Note: A reboot is NOT required after uninstalling WinSQL Professional. August 2010 Release

30 Chapter 1: Getting Started Customizing Shortcut Keys Keyboard shortcut keys can be used to access many of the features available in WinSQL Professional. Perform the following steps to view and/or modify keyboard shortcut keys: 1 From the Tools menu, click Customize Shortcuts. The following window is displayed: 2 Click the + (plus sign) by each of the menu options to display a submenu, illustrated as follows: 20 Release 8.5 August 2010

31 Chapter 1: Getting Started 3 Click to select an option. If a shortcut key exists for the option, it is displayed as follows: 4 If a new keyboard shortcut key is desired, press the key combination, and then click to select Overwrite existing values OR if a keyboard shortcut key does not exist, press the key combination. If accepted and not in use by another option, the selected key combination is displayed on the Customize Shortcuts window. If the select keyboard shortcut is already in use, the following information is displayed on the Customize Shortcuts window: Continue to enter other key combinations until the value is accepted. August 2010 Release

32 Chapter 1: Getting Started Note: Any combination of control keys (Shift, Alt, and Ctrl), plus a letter or number, can be used. The only exception is Ctrl+[space bar], which is reserved for use by Intelli Tips. 22 Release 8.5 August 2010

33 Chapter 2: Running Queries Chapter 2: Running Queries Overview Introduction This chapter provides information about creating, running, viewing, saving, and printing queries within WinSQL Professional. In this chapter This chapter contains the following topics: Topic Screen Layout 25 Integrated View 25 Classic View 26 Switching Views 26 Writing SQL Scripts 27 Query Pages 28 Query Set Workbook 28 Using Clipboard 29 Extended Copy Code 29 Extended Copy - Results 30 Displaying Query Results 31 Intelli Tips 42 Data Lookup 44 See Page Configuring Data Lookup Display Options 44 Modifying SQL Queries to Retrieve Data 47 August 2010 Release

34 Chapter 2: Running Queries Topic Drill-Down Results 49 Query History 52 Comments with SQL Statements 52 Query Syntax and SQL Grammar 52 Parameterized Queries 54 Generate Code 55 SQL Wizard 57 See Page Scripting Wizard Release 8.5 August 2010

35 Chapter 2: Running Queries Screen Layout WinSQL provides two different types of views (screen layouts) when viewing queries: Important note: Integrated View Classic View For the purposes of this document, all procedural steps and screen shots refer to the Integrated View. However, Classic View screen shots are used in instances where they better serve to illustrate the function being performed. Integrated View When using the Integrated View, WinSQL displays part of the catalog screen next to the query window. This allows you to quickly and conveniently see the tables, views, and other objects in the database. The Integrated View is depicted in the following screen shot: When you click a node that requires additional information, WinSQL automatically switches the current tab from Query to Catalog Details. For example, if you click the Browse Data or Manage Relationship nodes, WinSQL switches the current view to display the additional node information. August 2010 Release

36 Chapter 2: Running Queries Classic View Unlike the Integrated View, the Classic View does not display the catalog screen. When in Classic View, you must click the Catalog tab to view catalog details. An advantage to using this view is that it provides more room to display the query and results tabs. The Classic View is depicted in the following screen shot: Switching Views To switch between integrated and classic views, simply click Switch to Integrated View or Switch to Classic View from the View menu. The text of the menu item changes based on the view you currently are using. 26 Release 8.5 August 2010

37 Chapter 2: Running Queries Writing SQL Scripts Writing and submitting SQL queries to a back-end database is the most important and useful feature of WinSQL Professional. Once a database connection is established, any type of SQL script may be written to extract data from the database. You can highlight part of the script to run, or not highlight anything to run the complete script. If there is more than one result set, WinSQL Professional will display them one after another in different tabs. August 2010 Release

38 Chapter 2: Running Queries Query Pages A query page is a group of SQL scripts displayed on the screen. You can have multiple query pages per window. Creating multiple query pages helps you manage queries when your SQL scripts get larger. The first query page is created automatically when you connect to a database. Thereafter, you have an option to create as many query pages as you need. The number of query pages allowed is limited only by available memory on the machine. To create a query page, point to the File menu, and then click New Query Page. The number of the current query page is displayed in the Available Query Pages field: You can navigate to different query pages by selecting the desired query page from the Available Query Pages drop-down list. Query Set Workbook If you have more than one query page created in WinSQL Professional, they can all be saved in a query workbook. To save all current queries in a workbook, point to the File menu, and then click Save Workbook. 28 Release 8.5 August 2010

39 Chapter 2: Running Queries Using Clipboard Results from queries can be copied to the Windows Clipboard by pressing [Ctrl+C]. The information copied to the Clipboard can then be copied into a variety of other software applications, depending on the type of output desired. Extended Copy - Code WinSQL Professional allows you to copy SQL code into HTML or Rich Text format using the Extended Copy option in the Query window. You can also convert code using the Convert to Code option. The following topics describe these options. Convert to Code This option allows you to write SQL code and convert that code into a third-generation language, such as C-Sharp, Visual Basic, or Java. Perform the following steps to convert SQL code: 1 Right-click the desired script in the Query window, and then click Extended Copy. 2 Click Convert to Code. The SQL2Code Wizard window is displayed: 3 Select the desired language in the Language dropdown list. August 2010 Release

40 Chapter 2: Running Queries 4 If desired, change the default variable name in the Variable Name field. 5 Click Copy to copy the text to the clipboard. Copy to Rich Text This option copies SQL code to the Windows Clipboard in Rich Text format, which allows you to paste SQL code to different applications, such as a word processing application that uses Rich Text format. To copy SQL code into Rich Text format, right-click the desired script in the Query windows, click Extended Copy, and then choose Rich Text. Copy to HTML This option converts the SQL code into HTML, while retaining all syntax highlighting, and provides a convenient way of creating HTML documentation. To copy SQL statements into HTML, right-click the desired script in the Query windows, click Extended Copy, and then choose HTML. Extended Copy - Results When query results are displayed in the Query window, you have the option to copy data from more than one cell. To perform an extended copy, click in the results grid in the Query window, right-click, and then select the desired option. 30 Release 8.5 August 2010

41 Chapter 2: Running Queries Displaying Query Results WinSQL Professional allows you to display query results in the following formats: Grid Text Form It is recommended that you display results in Grid unless you are running a query that returns large amount of text containing new line characters. Managing result sets that are displayed in Grid is much easier than in Text. For example, you can save the contents of the results Grid to a CVS, tab-delimited, or spreadsheet file. Note: The result is limited to 16MB of characters per cell when the data is displayed in a Grid control, 4096 characters when displayed in the Text control and 32 KB when displayed in the Form control. Since it is not practical to display the entire 16 MB of data in one grid cell, WinSQL will display a magnifying glass icon if the cell data is greater than 1024 characters. You may lick the magnifying glass to zoom and view the entire data. In case of text field, data will get truncated if the length is greater than 4096 characters. This will not happen if you try to export the field to another database. To select the method used to display query results, click the down arrow in the Execute Queries drop-down list, depicted as follows: The resulting data display can be modified to include or exclude certain columns by click the X in the column header: August 2010 Release

42 Chapter 2: Running Queries This functionality is also available for the Browse Data Grid option available in the Catalog Details tab. Note: Right-click and select Display all columns to display formerly hidden columns. Modifying results displayed in Grid Double-click the desired row to modify the results displayed in a grid. The Update Wizard is invoked, allowing you to modify existing values. Notes: You can only modify results sets that are generated from one table. Queries containing a JOIN statement are not editable. Modifying results displayed in Text Result sets in text are not editable. Modifying results displayed in Form To modify data, simply start typing the new value. After specifying the new values you can either press [Enter] or click Save to save the modified data to the database. 32 Release 8.5 August 2010

43 Chapter 2: Running Queries Several keyboard shortcuts can be used when the data is displayed in Form view. These shortcuts are described in the following table: Key combination [Alt] + right arrow [Alt] + left arrow [Shift] + [Alt] + right arrow [Shift] + [Alt] + left arrow [Esc] [Enter] Result Displays the next record Displays the previous record Saves any modified data and displays the next record Saves any modified data and displays the previous record Discards any modified values and refreshes the window Saves the newly-modified values. This shortcut only works in single-line edit controls. Pressing [Enter] in a multi-line control inserts a new line in the data. Viewing BLOB/CLOB Data This feature provides a mechanism to view images, audio, video, or other binary format. Perform the following steps to view BLOB/CLOB data: 1 Establish a connection to the desired database. For more information, see Establishing a Database Connection. 2 Click the Query tab. 3 Run an existing query, or create a new query that fetches a binary or large text from the database and click the play icon. 4 In the Resultset window locate the text in green (indicating long data), and click the zoom icon to display the object: August 2010 Release

44 Chapter 2: Running Queries If the object is a text object, the following information is displayed in the Zoomed data window: Click the Rich Text tab to view the formatted text object: 34 Release 8.5 August 2010

45 Chapter 2: Running Queries If the object is an image, click the Image tab to view the image: August 2010 Release

46 Chapter 2: Running Queries 5 Click Close to close the Zoomed data window. Note: If the binary object is not a rich text or image object and is, for example, a Microsoft Word document or an Microsoft Excel spreadsheet, click the Other tab to select the appropriate application to view the object, and then click Launch Application: If your desired application is not listed, select <<Custom>> and specify the extension for your file. For example, if you have an AutoCad diagram saved in the database specify DWG as the file extension. 36 Release 8.5 August 2010

47 Chapter 2: Running Queries Searching for Text Using the Find option in WinSQL Professional allows you to search for text within SQL scripts or query results. To initiate a search, point to the Edit menu, and then click Find. The appropriate search window is displayed. For example, if the selected control is the Query window, the following window is displayed: If the selected control is a results Grid, the following window is displayed: August 2010 Release

48 Chapter 2: Running Queries This window displays the columns contained in the Grid. You can either select the desired columns, or you can select the Search in ALL columns option to search within all Grid columns. 38 Release 8.5 August 2010

49 Chapter 2: Running Queries Printing Results Results displayed in a Grid can be printed in three different formats by right-clicking the displayed results, and then clicking Print Results. A window similar to the following is displayed: After typing a title for your report in the Title field and selecting the desired column width and color option, select one of the available print format options, using the information in the following table as a guideline: Option Tabular Best fit Description This option prints the data in a format similar to a spreadsheet. Pages are added sideways for additional columns and downward for additional rows. This is the best option for printing large amounts of data using the least number of pages. This option allows a row of data in a record to wrap to additional lines, allowing multiple records to be printed on each page. This is the best option for viewing multiple records in one page. August 2010 Release

50 Chapter 2: Running Queries Option Description 1 Record per page This option prints one record per page in a format similar to a printed form. Click OK once the desired printing options have been selected. 40 Release 8.5 August 2010

51 Chapter 2: Running Queries Exporting Grid Content Results displayed in a Grid can be exported by right-clicking the displayed results, and then clicking Export data, depicted as follows: Select the desired export output, enter the desired file name in the Target File Name field, and then click OK. August 2010 Release

52 Chapter 2: Running Queries Intelli Tips The Intelli Tips feature facilitates the writing of SQL queries by displaying the catalog objects in a pop-up window as the user types his/her queries. Prerequisites for Intelli Tips The Intelli Tips feature will only work if: You are using WinSQL Professional You have fetched the database catalog prior to writing the SQL query By default, WinSQL Professional fetches the database catalog after the connection is established. This feature can be disabled for use with large databases; however, the database catalog must be manually fetched prior to using Intelli Tips. When Intelli Tips are enabled, Intelli Tips displays a window containing Table and Field as you type SQL script in the query window. You can also press [Ctrl+spacebar] to manually invoke the Intelli Tips window. The data displayed in the Intelli Tips window is pulled from the Catalog Details window. Therefore, any filter you have applied in the Catalog Details window applies to the data in the Intelli Tips window. The Intelli Tips window can display both tables and fields. WinSQL Professional parses the current query and displays the appropriate tab (tables or fields). To display columns for a particular table, click the Tables tab, select the desired table, and then click the Fields tab to display the fields within the selected table. 42 Release 8.5 August 2010

53 Chapter 2: Running Queries Table Joins WinSQL Professional recognizes relationships that are specified on your back-end server using foreign key constraints. In addition to foreign keys, you can also create a local relationship among tables. For more information, see Creating Local Relationships later in this document. When relationships are found among tables, the Intelli Tips window automatically displays the WHERE clause necessary for the JOIN statement, depicted as follows: August 2010 Release

54 Chapter 2: Running Queries Data Lookup The Data Lookup feature in WinSQL Professional allows users to view the actual values in the tables when writing SQL queries. The value appears automatically when WinSQL Professional detects a WHERE clause in the query window, illustrated as follows: Configuring Data Lookup Display Options Perform the following steps to enable or disable and to configure the Data Lookup feature: 1 Start WinSQL Professional and connect to the desired database. 2 From the Edit menu, click Options. 3 Click the Intelli Tips tab. The following window is displayed: 44 Release 8.5 August 2010

55 Chapter 2: Running Queries 4 Use the information in the following table to specify the desired parameters: Field Enable auto intelli tips Display delay time in milliseconds Assign aliases in FROM clause Force quoted identifiers Definition If checked, Intelli Tips will be displayed automatically as you type your SQL queries. This is the amount of time WinSQL waits after a key is pressed before displaying the Intelli Tips window. This value is in milliseconds If checked, WinSQL will assign aliases for tables in the FROM clause. For example, if this NOT checked, the query will look like: Select Customer.Name from Customer When this is checked, the query will look like: Select c.name from customer c If checked, WinSQL will always enclose object names in quotes. The generated query will look like: Select * August 2010 Release

56 Chapter 2: Running Queries Field Enable/Disable Data Lookup Number of records to display Max length for character fields Definition From dbo. customer When this is NOT checked, WinSQL will only put quotes on objects that have an embedded space in their name. Select one of the following options: Disable data lookup: Select this option if you wish to disable Data Lookup. Doing so will prevent the Data tab from appearing in the Intelli Tip window. Enable for every column: Select this option to enable data lookup for every column whose data type is one of the following: 1) numeric, 2) Date/time, or 3) character (where the length is less than the specific character length). Enable for columns that I choose: If this option is selected, you must specifically assign a SQL query to every column for which you wish to enable data lookup. To assign a SQL query, double-click that column in the Catalog Details window (see Enable for every column, above). The number of records to display in the Intelli Tips window. If the query returns more than the specified number of records, they will be ignored. Data lookup is enabled for fields where the column length is less than this value. For example, if there is a remarks field in a table and its size is 255, Data Lookup is not enabled for this field. This value only applies to character 46 Release 8.5 August 2010

57 Chapter 2: Running Queries Field Definition types. Max record count for a table For large databases, WinSQL Professional may take a long time to fetch records from a table. Therefore, if you specify a value other than -1, WinSQL Professional will only run data lookup queries for table having fewer numbers of rows than what you specify here. 5 Click OK when all options have been selected. Modifying SQL Queries to Retrieve Data When data is populated in the Intelli Tips window, WinSQL Professional runs a query in the background. This query retrieves necessary records for a particular column and displays them on the screen. A SQL query can be associated with every column in the database. Perform the following steps to associate a query with a column. 1 Start WinSQL Professional and connect to the desired database. 2 Click the Catalog Details tab. 3 Navigate to the desired column in the left pane of the catalog tree: August 2010 Release

58 Chapter 2: Running Queries 4 Double-click the desired field. A window similar to the following is displayed: 5 Modify the query as desired, and then click OK. 48 Release 8.5 August 2010

59 Chapter 2: Running Queries Drill-down Results When you run a query from a single table that has relationship, WinSQL Professional allows you to drill down to related rows in the associated table. Prerequisites for Drill-down The Drill-down feature will only work when: You are using WinSQL Professional The FROM clause in the SELECT statement contains only one table You have fetched the database catalog prior to running your query Either foreign or local relationships are defined in the table Consider the following scenario as an example, which contains a database with four tables. Their relationships are displayed in the figure below. Notice that the ORDERS table has two parents, EMPLOYEE and CUSTOMER, and it has one child, LINEITEM. August 2010 Release

60 Chapter 2: Running Queries When you run the following query in WinSQL Professional, it displays the columns containing primary and foreign key in a different color with a + (plus sign) next to the value. Note: The following illustration is in Classic View. The first column in this example contains the primary key from the ORDERS table, which is displayed in red. The two subsequent columns contain data that map to the CUSTOMER and EMPLOYEE tables and is defined as a foreign key. Data for these columns is displayed in blue. You can click the + to display related data from the associated table. For example if you click the E_SSN column where the value is 50, WinSQL Professional will run another query that will pull the employees whose E_SSN equal 50, depicted as follows: 50 Release 8.5 August 2010

61 Chapter 2: Running Queries Note: The following illustration is in Classic View. August 2010 Release

62 Chapter 2: Running Queries Query History WinSQL Professional keeps a history of queries you have previously run. The default number of queries stored is 50; however, this value can be changed by clicking Configure on the History tab, and entering a new value in Modify historic count option. In addition, older queries are replaced by newer queries on a first in, first out basic. Historic queries can also be copied to disk for backup purposes. Comments with SQL Statements WinSQL Professional recognizes two kinds of comments: Comment type Line Description A line beginning with two dashes is consider a comment line Enclosed Any text that is enclosed by /* /* Beginning with WinSQL Professional version 3.5, you have the option of allowing WinSQL Professional to parse the comments before the SQL statement is submitted to the server. This option allows you to use comments that a back-end database may not support. Synametrics recommends that you allow the DBMS to handle supported comments. This option can be configured by pointing to the Edit menu and then clicking Options. Query Syntax and SQL Grammar WinSQL Professional does not contain its own syntax. It inherits the SQL dialect from the back-end server and submits the query as is to the back-end database. Similarly, it displays the results data as is from the server. This feature allows users to submit queries that are specific to a particular database. There are, however, exceptions to this rule. The submitted script is modified under the following conditions. When you use a WinSQL Professional specific parameter in the query. In this case, the parameter will be replaced before submitting the query 52 Release 8.5 August 2010

63 Chapter 2: Running Queries If a query terminator is found within the script. The default value for query terminator is GO. You use a code template. Code templates are explained in more detail in the Database-Specific Plug-Ins topic in this document. Templates replace pre-defined tokens into server specific SQL. For example, when a user types DESCRIBE <TABLENAME> in an Oracle database, WinSQL Professional replaces this command with a set of Oracle specific scripts necessary to pull table definition. August 2010 Release

64 Chapter 2: Running Queries Parameterized Queries Beginning with WinSQL Professional version 2.0, parameters can be accepted in queries. Any text that is preceded by two colons (::) is considered a parameter, and users are prompted to enter a value when the query is run. In addition, WinSQL Professional stores the values for previously-used parameters so that the user does not have to type them every time. Notes: Once a value has been specified for the first parameter in a query, you can press [Enter] to move to the next parameter. WinSQL Professional attempts to determine the data type for the subsequent parameters; however, the default data type can be determined by selecting a type from the list. Parameter queries cannot be used to export data. 54 Release 8.5 August 2010

65 Chapter 2: Running Queries Generate Code WinSQL s Generate Code function allows users to quickly generate one of the following SQL scripts: Select Insert Update Delete Create View Drop Table Once selected, the script displays in the Query window. The primary keys in the selected table are, by default, used as parameter fields in the script and are indicated by a double colon (::). Note: The parameter field indicator can be modified, if desired. For more information, see the General Tab topic in Chapter 3, Configuration Options. Perform the following steps to use the Generate Code function: 1 Start WinSQL Professional and connect to the desired database. 2 Click the plus (+) sign by Tables to view a list of tables in the catalog tree of your database. 3 Click to select the desired table, and then right-click to display the submenu. 4 Click Generate Code. A window similar to the following is displayed: August 2010 Release

66 Chapter 2: Running Queries 5 Click the desired script. The content of the selected script is displayed in the Query window. In the following example, the SELECT statement was generated, and the primary key for the table (c_id) is the parameter field: Notes: Parameter fields can be removed from the script as desired. When generating a new script, the highlighted content of the existing script displayed in the Query window is overwritten. If the cursor is positioned within the content of an existing script when a new script is generated, the new script is pasted at the current cursor position. 6 Click the Execute queries icon ( ) to run the script. 56 Release 8.5 August 2010

AssetWise Performance Management. APM Remote Upgrade Guide

AssetWise Performance Management APM Remote Upgrade Guide Trademark Notice Bentley, the B Bentley logo, AssetWise, Ivara, the Ivara EXP logo, Ivara Work Smart, Aladon and RCM2 are either registered or

More information

User Manual. Onsight Management Suite Version 5.1. Another Innovation by Librestream

User Manual Onsight Management Suite Version 5.1 Another Innovation by Librestream Doc #: 400075-06 May 2012 Information in this document is subject to change without notice. Reproduction in any manner

More information

Legal Notes. Regarding Trademarks. 2012 KYOCERA Document Solutions Inc.

Legal Notes Unauthorized reproduction of all or part of this guide is prohibited. The information in this guide is subject to change without notice. We cannot be held liable for any problems arising from

More information

User Guide. Analytics Desktop Document Number: 09619414

User Guide Analytics Desktop Document Number: 09619414 CONTENTS Guide Overview Description of this guide.. ix What s new in this guide..x 1. Getting Started with Analytics Desktop Introduction.. 1

More information

MyOra 3.0. User Guide. SQL Tool for Oracle. Jayam Systems, LLC

MyOra 3.0 SQL Tool for Oracle User Guide Jayam Systems, LLC Contents Features.. 4 Connecting to the Database.. 5 Login.. 5 Login History.. 6 Connection Indicator.. 6 Closing the Connection.. 7 SQL

More information

Sage Intelligence Financial Reporting for Sage ERP X3 Version 6.5 Installation Guide

Sage Intelligence Financial Reporting for Sage ERP X3 Version 6.5 Installation Guide Table of Contents TABLE OF CONTENTS.. 3 1.0 INTRODUCTION.. 1 1.1 HOW TO USE THIS GUIDE.. 1 1.2 TOPIC SUMMARY..

More information

User's Guide. Using RFDBManager. For 433 MHz / 2.4 GHz RF. Version 1.23.01

User's Guide Using RFDBManager For 433 MHz / 2.4 GHz RF Version 1.23.01 Copyright Notice Copyright 2005 Syntech Information Company Limited. All rights reserved The software contains proprietary information

More information

FileMaker 11. ODBC and JDBC Guide

FileMaker 11 ODBC and JDBC Guide 2004 2010 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker is a trademark of FileMaker, Inc. registered

More information

CONTACTS SYNCHRONIZER FOR IPAD USER GUIDE

User Guide CONTACTS SYNCHRONIZER FOR IPAD USER GUIDE Product Version: 1.0 CONTENTS 1. INTRODUCTION..4 2. INSTALLATION..5 2.1 DESKTOP INSTALLATION..5 2.2 IPAD INSTALLATION..9 3. USING THE CONTACTS SYNCHRONIZER

More information

3 Setting up Databases on a Microsoft SQL 7.0 Server

3 Setting up Databases on a Microsoft SQL 7.0 Server Overview of the Installation Process To set up GoldMine properly, you must follow a sequence of steps to install GoldMine s program files, and the other

More information

IceWarp Server Windows Installation Guide

IceWarp Unified Communications IceWarp Server Windows Installation Guide Version 11.3 Published on 2/6/2015 Contents IceWarp Server Windows.. 4 Pre-requisites.. 5 Launch Installer Wizard.. 6 Select

More information

MAS 500 Intelligence Tips and Tricks Booklet Vol. 1

MAS 500 Intelligence Tips and Tricks Booklet Vol. 1 1 Contents Accessing the Sage MAS Intelligence Reports.. 3 Copying, Pasting and Renaming Reports.. 4 To create a new report from an existing report..

More information

There are numerous ways to access monitors:

Remote Monitors REMOTE MONITORS.. 1 Overview.. 1 Accessing Monitors.. 1 Creating Monitors.. 2 Monitor Wizard Options.. 11 Editing the Monitor Configuration.. 14 Status.. 15 Location.. 17 Alerting..

More information

DeviceAnywhere Enterprise. ios Device Onboarding Guide

DeviceAnywhere Enterprise ios Device Onboarding Guide DeviceAnywhere Enterprise ios Device Onboarding Guide DeviceAnywhere Enterprise 6.2.1 DeviceAnywhere Enterprise Automation 6.2.1 DeviceAnywhere Enterprise

More information

Toad for Data Analysts, Tips n Tricks

Toad for Data Analysts, Tips n Tricks or Things Everyone Should Know about TDA Just what is Toad for Data Analysts? Toad is a brand at Quest. We have several tools that have been built explicitly for developers

More information

Results CRM 2012 User Manual

Results CRM 2012 User Manual A Guide to Using Results CRM Standard, Results CRM Plus, & Results CRM Business Suite Table of Contents Installation Instructions.. 1 Single User & Evaluation Installation

More information

Getting Started with Vision 6

Getting Started with Vision 6 Version 6.9 Notice Copyright 1981-2009 Netop Business Solutions A/S. All Rights Reserved. Portions used under license from third parties. Please send any comments to: Netop

More information

Teradata SQL Assistant Version 13.0 (.Net) Enhancements and Differences. Mike Dempsey

Teradata SQL Assistant Version 13.0 (.Net) Enhancements and Differences by Mike Dempsey Overview SQL Assistant 13.0 is an entirely new application that has been re-designed from the ground up. It has been

More information

Microsoft Access 2007

How to Use: Microsoft Access 2007 Microsoft Office Access is a powerful tool used to create and format databases. Databases allow information to be organized in rows and tables, where queries can be formed

More information

MGC WebCommander Web Server Manager

MGC WebCommander Web Server Manager Installation and Configuration Guide Version 8.0 Copyright 2006 Polycom, Inc. All Rights Reserved Catalog No. DOC2138B Version 8.0 Proprietary and Confidential The information

More information

Plug-In for Informatica Guide

Winsql Tutorials

HP Vertica Analytic Database Software Version: 7.0.x Document Release Date: 2/20/2015 Legal Notices Warranty The only warranties for HP products and services are set forth in the express warranty statements

More information

NETWORK PRINT MONITOR User Guide

NETWORK PRINT MONITOR User Guide Legal Notes Unauthorized reproduction of all or part of this guide is prohibited. The information in this guide is subject to change without notice. We cannot be held liable

More information

Tips and Tricks SAGE ACCPAC INTELLIGENCE

Tips and Tricks SAGE ACCPAC INTELLIGENCE 1 Table of Contents Auto e-mailing reports.. 4 Automatically Running Macros.. 7 Creating new Macros from Excel.. 8 Compact Metadata Functionality.. 9 Copying,

More information

Table of Contents. Introduction..9. Installation..17. Program Tour..31. The Program Components..10 Main Program Features..11

2011 AdRem Software, Inc. This document is written by AdRem Software and represents the views and opinions of AdRem Software regarding its content, as of the date the document was issued. The information

More information

Getting Started using the SQuirreL SQL Client

Getting Started using the SQuirreL SQL Client The SQuirreL SQL Client is a graphical program written in the Java programming language that will allow you to view the structure of a JDBC-compliant database,

More information

Attix5 Pro Server Edition

Attix5 Pro Server Edition V7.0.3 User Manual for Linux and Unix operating systems Your guide to protecting data with Attix5 Pro Server Edition. Copyright notice and proprietary information All rights reserved.

More information

FileMaker 12. ODBC and JDBC Guide

FileMaker 12 ODBC and JDBC Guide 2004 2012 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker and Bento are trademarks of FileMaker, Inc.

More information

National Fire Incident Reporting System (NFIRS 5.0) Configuration Tool User's Guide

National Fire Incident Reporting System (NFIRS 5.0) Configuration Tool User's Guide NFIRS 5.0 Software Version 5.6 1/7/2009 Department of Homeland Security Federal Emergency Management Agency United States

More information

WhatsUp Gold v16.3 Installation and Configuration Guide

WhatsUp Gold v16.3 Installation and Configuration Guide Contents Installing and Configuring WhatsUp Gold using WhatsUp Setup Installation Overview.. 1 Overview.. 1 Security considerations.. 2 Standard

More information

SAP Business Objects Business Intelligence platform Document Version: 4.1 Support Package 7 2015-11-24. Data Federation Administration Tool Guide

SAP Business Objects Business Intelligence platform Document Version: 4.1 Support Package 7 2015-11-24 Data Federation Administration Tool Guide Content 1 What's new in the.. 5 2 Introduction to administration

More information

Backup Assistant. User Guide. NEC NEC Unified Solutions, Inc. March 2008 NDA-30282, Revision 6

Backup Assistant User Guide NEC NEC Unified Solutions, Inc. March 2008 NDA-30282, Revision 6 Liability Disclaimer NEC Unified Solutions, Inc. reserves the right to change the specifications, functions,

More information

Jet Data Manager 2012 User Guide

Jet Data Manager 2012 User Guide Welcome This documentation provides descriptions of the concepts and features of the Jet Data Manager and how to use with them. With the Jet Data Manager you can transform

More information Professional

Installing RMFT on an MS Cluster

Installing RMFT on an MS Cluster RMFT Software Version 2.4.3 Supported on: Windows Server 2003 Enterprise Edition Windows Server 2000 Advanced Windows Server 2003 Datacenter Edition Windows Server 2008

More information

Reconfiguring VMware vsphere Update Manager

Reconfiguring VMware vsphere Update Manager vsphere Update Manager 6.0 This document supports the version of each product listed and supports all subsequent versions until the document is replaced by a

More information

Rational Rational ClearQuest

Rational Rational ClearQuest Version 7.0 Windows Using Project Tracker GI11-6377-00 Rational Rational ClearQuest Version 7.0 Windows Using Project Tracker GI11-6377-00 Before using this information, be

More information

Business Intelligence Getting Started Guide

Business Intelligence Getting Started Guide 2013 Table of Contents Introduction.. 1 Introduction.. 1 What is Sage Business Intelligence?.. 1 System Requirements.. 2 Recommended System Requirements..

More information

Remote Management System

RMS Copyright and Distribution Notice November 2009 Copyright 2009 ARTROMICK International, Inc. ALL RIGHTS RESERVED. Published 2009. Printed in the United States of America WARNING: ANY UNAUTHORIZED

More information

Advanced Event Viewer Manual

Advanced Event Viewer Manual Document version: 2.2944.01 Download Advanced Event Viewer at: http://www.advancedeventviewer.com Page 1 Introduction Advanced Event Viewer is an award winning application

More information

Simply Accounting Intelligence Tips and Tricks Booklet Vol. 1

Simply Accounting Intelligence Tips and Tricks Booklet Vol. 1 1 Contents Accessing the SAI reports.. 3 Running, Copying and Pasting reports.. 4 Creating and linking a report.. 5 Auto e-mailing reports..

More information

MyOra 3.5. User Guide. SQL Tool for Oracle. Kris Murthy

MyOra 3.5 SQL Tool for Oracle User Guide Kris Murthy Contents Features.. 4 Connecting to the Database.. 5 Login.. 5 Login History.. 6 Connection Indicator.. 6 Closing the Connection.. 7 SQL Editor..

More information

Attix5 Pro Server Edition

Attix5 Pro Server Edition V7.0.2 User Manual for Mac OS X Your guide to protecting data with Attix5 Pro Server Edition. Copyright notice and proprietary information All rights reserved. Attix5, 2013 Trademarks

More information

SC-T35/SC-T45/SC-T46/SC-T47 ViewSonic Device Manager User Guide

SC-T35/SC-T45/SC-T46/SC-T47 ViewSonic Device Manager User Guide Copyright and Trademark Statements 2014 ViewSonic Computer Corp. All rights reserved. This document contains proprietary information that

More information

Embarcadero Rapid SQL Developer 2.0 User Guide

Embarcadero Rapid SQL Developer 2.0 User Guide Copyright 1994-2009 Embarcadero Technologies, Inc. Embarcadero Technologies, Inc. 100 California Street, 12th Floor San Francisco, CA 94111 U.S.A. All rights

More information Number

Data Tool Platform SQL Development Tools

Data Tool Platform SQL Development Tools ekapner Contents Setting SQL Development Preferences..5 Execution Plan View Options Preferences..5 General Preferences..5 Label Decorations Preferences..6

More information

Chapter 4 Accessing Data

Chapter 4: Accessing Data 73 Chapter 4 Accessing Data The entire purpose of reporting is to make sense of data. Therefore, it is important to know how to access data locked away in the database. In this

More information

Security Explorer 9.5. User Guide

2014 Dell Inc. ALL RIGHTS RESERVED. This guide contains proprietary information protected by copyright. The software described in this guide is furnished under a software license or nondisclosure agreement.

More information

Crystal Reports Installation Guide

Crystal Reports Installation Guide Version XI Infor Global Solutions, Inc. Copyright 2006 Infor IP Holdings C.V. and/or its affiliates or licensors. All rights reserved. The Infor word and design marks

More information

FileMaker Pro and Microsoft Office Integration

FileMaker Pro and Microsoft Office Integration page Table of Contents Executive Summary..3 Introduction..3 Top Reasons to Read This Guide..3 Before You Get Started..4 Downloading the FileMaker Trial

More information

Test Center Enterprise. ios Device Onboarding Guide

Test Center Enterprise ios Device Onboarding Guide Copyright Copyright 2012 Keynote DeviceAnywhere. All Rights Reserved. March 2012. Notice 2012 Keynote DeviceAnywhere. All rights reserved. THE INFORMATION

More information

USER GUIDE. Unit 2: Synergy. Chapter 2: Using Schoolwires Synergy

USER GUIDE Unit 2: Synergy Chapter 2: Using Schoolwires Synergy Schoolwires Synergy & Assist Version 2.0 TABLE OF CONTENTS Introductions.. 1 Audience.. 1 Objectives.. 1 Before You Begin.. 1 Getting

More information

ODBC Driver Version 4 Manual

ODBC Driver Version 4 Manual Revision Date 12/05/2007 HanDBase is a Registered Trademark of DDH Software, Inc. All information contained in this manual and all software applications mentioned in this manual

More information

ODBC Client Driver Help. 2015 Kepware, Inc.

2015 Kepware, Inc. 2 Table of Contents Table of Contents 2 4 Overview 4 External Dependencies 4 Driver Setup 5 Data Source Settings 5 Data Source Setup 6 Data Source Access Methods 13 Fixed Table 14 Table

More information

File Management Utility User Guide

File Management Utility User Guide Legal Notes Unauthorized reproduction of all or part of this guide is prohibited. The information in this guide is subject to change without notice. We cannot be held

More information

Ekran System Help File

Ekran System Help File Table of Contents About.. 9 What s New.. 10 System Requirements.. 11 Updating Ekran to version 4.1.. 13 Program Structure.. 14 Getting Started.. 15 Deployment Process.. 15

More information

IBM FileNet eforms Designer

IBM FileNet eforms Designer Version 5.0.2 Advanced Tutorial for Desktop eforms Design GC31-5506-00 IBM FileNet eforms Designer Version 5.0.2 Advanced Tutorial for Desktop eforms Design GC31-5506-00 Note

More information

Upgrading to Document Manager 2.7

Upgrading to Document Manager 2.7 22 July 2013 Trademarks Document Manager and Document Manager Administration are trademarks of Document Logistix Ltd. TokOpen, TokAdmin, TokImport and TokExRef are registered

More information

Create a New Database in Access 2010

Create a New Database in Access 2010 Table of Contents OVERVIEW.. 1 CREATING A DATABASE.. 1 ADDING TO A DATABASE.. 2 CREATE A DATABASE BY USING A TEMPLATE.. 2 CREATE A DATABASE WITHOUT USING A TEMPLATE..

More information

Desktop Surveillance Help

Desktop Surveillance Help Table of Contents About.. 9 What s New.. 10 System Requirements.. 11 Updating from Desktop Surveillance 2.6 to Desktop Surveillance 3.2.. 13 Program Structure.. 14 Getting

More information

Laptop Backup - Administrator Guide (Windows)

Laptop Backup - Administrator Guide (Windows) Page 1 of 86 Page 2 of 86 Laptop Backup - Administrator Guide (Windows) TABLE OF CONTENTS OVERVIEW PREPARE COMMCELL SETUP FIREWALL USING PROXY SETUP FIREWALL

More information

STATISTICA VERSION 9 STATISTICA ENTERPRISE INSTALLATION INSTRUCTIONS FOR USE WITH TERMINAL SERVER

Notes: STATISTICA VERSION 9 STATISTICA ENTERPRISE INSTALLATION INSTRUCTIONS FOR USE WITH TERMINAL SERVER 1. These instructions focus on installation on Windows Terminal Server (WTS), but are applicable

More information

FmPro Migrator - FileMaker to SQL Server

FmPro Migrator - FileMaker to SQL Server FmPro Migrator - FileMaker to SQL Server 1 1.1 1.2 1.3 1.4 1.5 1.6 1.7 1.8 1.9 1.10 1.11 1.12 1.13 1.14 1.15 FmPro Migrator - FileMaker to SQL Server Migration

More information

Rapid Assessment Key User Manual

Rapid Assessment Key User Manual Table of Contents Getting Started with the Rapid Assessment Key.. 1 Welcome to the Print Audit Rapid Assessment Key..1 System Requirements..1 Network Requirements..1

More information

Installation and Operation Manual Portable Device Manager, Windows version

Installation and Operation Manual version version About this document This document is intended as a guide for installation, maintenance and troubleshooting of Portable Device Manager (PDM) and is relevant

More information

Silect Software s MP Author

Silect MP Author for Microsoft System Center Operations Manager Silect Software s MP Author User Guide September 2, 2015 Disclaimer The information in this document is furnished for informational use only,

More information

Installing SQL Express. For CribMaster 9.2 and Later

Installing SQL Express For CribMaster 9.2 and Later CRIBMASTER USER GUIDE Installing SQL Express Document ID: CM9-031-03012012 Copyright CribMaster. 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004,

More information

Core Protection for Virtual Machines 1

Core Protection for Virtual Machines 1 Comprehensive Threat Protection for Virtual Environments. Installation Guide e Endpoint Security Trend Micro Incorporated reserves the right to make changes to this

More information

'SQL Database Professional ' module PRINTED MANUAL

'SQL Database Professional ' module PRINTED MANUAL 'SQL Database Professional ' module All rights reserved. No parts of this work may be reproduced in any form or by any means - graphic, electronic, or

More information

Centran Version 4 Getting Started Guide KABA MAS. Table Of Contents

Page 1 Centran Version 4 Getting Started Guide KABA MAS Kaba Mas Welcome Kaba Mas, part of the world-wide Kaba group, is the world's leading manufacturer and supplier of high security, electronic safe

More information

Setting up an MS SQL Server for IGSS

Setting up an MS SQL Server for IGSS Table of Contents Table of Contents..1 Introduction.. 2 The Microsoft SQL Server database..2 Setting up an MS SQL Server..3 Installing the MS SQL Server software..3

More information

Allworx OfficeSafe Operations Guide Release 6.0

Allworx OfficeSafe Operations Guide Release 6.0 No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in any form or by any means, electronic, mechanical, photocopy,

More information

Bosch ReadykeyPRO Unlimited Installation Guide, product version 6.5. This guide is item number DOC-110-2-029, revision 2.029, May 2012.

Bosch ReadykeyPRO Unlimited Installation Guide, product version 6.5. This guide is item number DOC-110-2-029, revision 2.029, May 2012. Copyright 1995-2012 Lenel Systems International, Inc. Information

More information

Database Studio is the new tool to administrate SAP MaxDB database instances as of version 7.5.

1 2 3 4 Database Studio is the new tool to administrate SAP MaxDB database instances as of version 7.5. It replaces the previous tools Database Manager GUI and SQL Studio from SAP MaxDB version 7.7 onwards

More information

Colligo Contributor File Manager 4.6. User Guide

Colligo Contributor File Manager 4.6 User Guide Contents Colligo Contributor File Manager Introduction.. 2 Benefits.. 2 Features.. 2 Platforms Supported.. 2 Installing and Activating Contributor File

More information

Embarcadero DB Change Manager 6.0 and DB Change Manager XE2

Product Documentation Embarcadero DB Change Manager 6.0 and DB Change Manager XE2 User Guide Versions 6.0, XE2 Last Revised April 15, 2011 2011 Embarcadero Technologies, Inc. Embarcadero, the Embarcadero

More information

EVENT LOG MANAGEMENT..

Event Log Management EVENT LOG MANAGEMENT.. 1 Overview.. 1 Application Event Logs.. 3 Security Event Logs.. 3 System Event Logs.. 3 Other Event Logs.. 4 Windows Update Event Logs.. 6 Syslog.. 6

More information

Colligo Email Manager 6.0. Offline Mode - User Guide

6.0 Offline Mode - User Guide Contents Colligo Email Manager 1 Key Features 1 Benefits 1 Installing and Activating Colligo Email Manager 2 Checking for Updates 3 Updating Your License Key 3 Managing SharePoint

More information

Installation Instructions Release Version 15.0 January 30 th, 2011

Release Version 15.0 January 30 th, 2011 ARGUS Software: ARGUS Valuation - DCF The contents of this document are considered proprietary by ARGUS Software, the information enclosed and any portion thereof

More information

Version 4.61 or Later. Copyright 2013 Interactive Financial Solutions, Inc. All Rights Reserved. ProviderPro Network Administration Guide.

Version 4.61 or Later Copyright 2013 Interactive Financial Solutions, Inc. All Rights Reserved. ProviderPro Network Administration Guide. This manual, as well as the software described in it, is furnished

More information

Installation Instruction STATISTICA Enterprise Small Business

Installation Instruction STATISTICA Enterprise Small Business Notes: ❶ The installation of STATISTICA Enterprise Small Business entails two parts: a) a server installation, and b) workstation installations

More information

Copyright. Copyright. Arbutus Software Inc. 270-6450 Roberts Street Burnaby, British Columbia Canada V5G 4E1

i Copyright Copyright 2015 Arbutus Software Inc. All rights reserved. This manual may contain dated information. Use of these materials is based on the understanding that this manual may not contain all

More information

ORACLE BUSINESS INTELLIGENCE WORKSHOP

ORACLE BUSINESS INTELLIGENCE WORKSHOP Integration of Oracle BI Publisher with Oracle Business Intelligence Enterprise Edition Purpose This tutorial mainly covers how Oracle BI Publisher is integrated with

More information

PowerLogic ION Enterprise 5.6

PowerLogic ION Enterprise 5.6 Power Management Software User Guide April 2007 Notices This section describes the symbols used in this guide. Danger This alerts you to things that may cause serious injury

More information

National Fire Incident Reporting System (NFIRS 5.0) NFIRS Data Entry/Validation Tool Users Guide

National Fire Incident Reporting System (NFIRS 5.0) NFIRS Data Entry/Validation Tool Users Guide NFIRS 5.0 Software Version 5.6 1/7/2009 Department of Homeland Security Federal Emergency Management Agency

More information

OPERATION MANUAL. MV-410RGB Layout Editor. Version 2.1- higher

OPERATION MANUAL MV-410RGB Layout Editor Version 2.1- higher Table of Contents 1. Setup.. 1 1-1. Overview.. 1 1-2. System Requirements.. 1 1-3. Operation Flow.. 1 1-4. Installing MV-410RGB Layout

More information

Portions of this product were created using LEADTOOLS 1991-2009 LEAD Technologies, Inc. ALL RIGHTS RESERVED.

Installation Guide Lenel OnGuard 2009 Installation Guide, product version 6.3. This guide is item number DOC-110, revision 1.038, May 2009 Copyright 1992-2009 Lenel Systems International, Inc. Information

More information

Rapid SQL 7.6 Evaluation Guide. Published: January 12, 2009

Rapid SQL 7.6 Evaluation Guide Published: January 12, 2009 Embarcadero Technologies, Inc. 100 California Street, 12th Floor San Francisco, CA 94111 U.S.A. This is a preliminary document and may be changed

More information

XMailer Reference Guide

XMailer Reference Guide Version 7.00 Wizcon Systems SAS Information in this document is subject to change without notice. SyTech assumes no responsibility for any errors or omissions that may be in this

More information

Microsoft Access 2010 Part 1: Introduction to Access

CALIFORNIA STATE UNIVERSITY, LOS ANGELES INFORMATION TECHNOLOGY SERVICES Microsoft Access 2010 Part 1: Introduction to Access Fall 2014, Version 1.2 Table of Contents Introduction..3 Starting Access..3

More information

BIGPOND ONLINE STORAGE USER GUIDE Issue 1.1.0-18 August 2005

BIGPOND ONLINE STORAGE USER GUIDE Issue 1.1.0-18 August 2005 PLEASE NOTE: The contents of this publication, and any associated documentation provided to you, must not be disclosed to any third party without

More information

DbVisualizer 9.2 Users Guide. DbVisualizer 9.2 Users Guide

DbVisualizer 9.2 Users Guide 1 of 428 Table of Contents 1 DbVisualizer 9.2 12 2 Getting Started 13 2.1 Downloading 13 2.2 Installing 13 2.2.1 Installing with an Installer 14 2.2.2 Installation from an

More information

UNICORN 7.0. Administration and Technical Manual

UNICORN 7.0 Administration and Technical Manual Page intentionally left blank Table of Contents Table of Contents 1 Introduction.. 1.1 Administrator functions overview.. 1.2 Network terms and concepts..

More information

Colligo Email Manager 6.0. Connected Mode - User Guide

6.0 Connected Mode - User Guide Contents Colligo Email Manager 1 Benefits 1 Key Features 1 Platforms Supported 1 Installing and Activating Colligo Email Manager 2 Checking for Updates 3 Updating Your License

More information

VRC 7900/8900 Avalanche Enabler User s Manual

VRC 7900/8900 Avalanche Enabler User s Manual WLE-VRC-20030702-02 Revised 7/2/03 ii Copyright 2003 by Wavelink Corporation All rights reserved. Wavelink Corporation 6985 South Union Park Avenue, Suite

More information

Release Bulletin Sybase ETL Small Business Edition 4.2

Release Bulletin Sybase ETL Small Business Edition 4.2 Document ID: DC00737-01-0420-02 Last revised: November 16, 2007 Topic Page 1. Accessing current release bulletin information 2 2. Product summary

More information

DiskPulse DISK CHANGE MONITOR

DiskPulse DISK CHANGE MONITOR User Manual Version 7.9 Oct 2015 www.diskpulse.com [email protected] 1 1 DiskPulse Overview..3 2 DiskPulse Product Versions..5 3 Using Desktop Product Version..6 3.1 Product

More information

WhatsUp Gold v16.1 Installation and Configuration Guide

WhatsUp Gold v16.1 Installation and Configuration Guide Contents Installing and Configuring Ipswitch WhatsUp Gold v16.1 using WhatsUp Setup Installing WhatsUp Gold using WhatsUp Setup.. 1 Security guidelines

More information

Virtual CD v10. Network Management Server Manual. H+H Software GmbH

Virtual CD v10 Network Management Server Manual H+H Software GmbH Table of Contents Table of Contents Introduction 1 Legal Notices.. 2 What Virtual CD NMS can do for you.. 3 New Features in Virtual

More information

Server. Version 3.7 Users Guide. Revised 5/28/03

Server Version 3.7 Users Guide Revised 5/28/03 Copyright 1996-2003 by Wavelink Corporation. All rights reserved. This manual may not be reproduced, in whole or in part, without prior written permission

More information

STATISTICA VERSION 12 STATISTICA ENTERPRISE SMALL BUSINESS INSTALLATION INSTRUCTIONS

STATISTICA VERSION 12 STATISTICA ENTERPRISE SMALL BUSINESS INSTALLATION INSTRUCTIONS Notes 1. The installation of STATISTICA Enterprise Small Business entails two parts: a) a server installation, and b)

More information