Cart
Previous Next

Advanced features: Code Snippets, SQL Syntax Checking and Code Formatting

Contents


This article describes SQL text-editing features provided in dbForge Studio for MySQL and dbForge Fusion for MySQL. You can effortlessly create and then edit SQL scripts using SQL editor. Press the New SQL icon on the Standard toolbar to create a new SQL script. To open existing SQL scripts, in the File menu, click Open File, and then choose the required file.

Code Snippets

Code snippets are frequently used standard pieces of code which you can insert into your code while working in SQL editor.

Several keystrokes to insert a code snippet

To insert a snippet in SQL document, select it from the suggestion list, use smart tag, or press the hot key combination Ctr+K and then X. The Insert Snippet drop-down list appears. Select a snippet and view information about it. Double-click the required snippet in the list and it will appear in your script.

If a snippet has a shortcut word, you can use it for the quickest insertion. Enter a shortcut word and press the Tab key, the corresponding snippet will be inserted.

Using Snippets Manager

Snippets Manager is used to add new, delete and modify existing snippets. In the manager, you can add and modify snippet shortcuts, literals and the snippet text itself.

To open Snippets Manager, click Snippets Manager in the Tools menu.

Using the Code Snippets window

Open the Code Snippets window and drag-and-drop the required snippet to the opened SQL script or right-click the snippet and select the Insert into Document option from the menu.

By default, the Code Snippets window is docked to the left upper corner of the program window and is in auto-hide mode, so it is easy to see and quickly open it while working with SQL scripts. In the window you can see a set of folders with neatly organized code templates and a preview panel. Just click, preview, and then insert. Based on your needs, you can rename code snippets, and rearrange all by drag-and-dropping in the window.

The variables and parameter values in the code templates are highlighted with green. This feature is made not only for better visibility of parameters, but also for quick navigating through them. Insert the snippet into the script, enter the required parameters into the green fields and press the Tab key to move from one variable to another. To complete the insertion, press Enter. Note, when you press Enter, you can't navigate through the inserted parameters any more.

Code Templates window

Context-sensitive Code Completion

When typing code, you can benefit from several code completion features. They are the following:

  • Word Completion
  • Phrase completion
  • List Members
  • Parameter Information for stored procedures
  • Quick Information about schema objects

Depending on what code elements you are typing, the automatically appeared completion list will show the best matches. Select the required value from the list and press Enter. To close the completion list, press Esc. You can easily access the completion features by either selecting Code Completion from the Edit menu, or by pressing corresponding icons on the Text toolbar. You will quickly remember which icon to choose thanks to the tooltips.

Type just one or two first characters of any item in SQL syntax and the Word Completion feature opens the completion list where the most appropriate match is highlighted. Next to the list you can see a brief explanation for the selected item.

When typing names of valid databases, tables, columns, and other database objects, the List Members feature helps you complete them and shows the matches in the completion list. In case you have typed, for example, the table name and then the dot (.) symbol, the completion list will show all columns names of this table. You can also open the List Members completion list, by pressing the familiar shortcut - Ctrl+Space.

The Parameter Information feature will help you quickly see the names and types of parameters, which are used in a function or stored procedure script. All information is neatly displayed in the Parameter Info tooltip. The parameter in bold is the next parameter that is required for the function or stored procedure. To see the information about procedure or function parameters, type the name of the procedure (or function) and open the left bracket. To see the tooltip again, press the familiar shortcut Ctrl+Shift+Space.

The Quick Info feature is a tooltip with brief information about database objects, parameters, and variables. The tooltip appears when you place the mouse pointer on the required item in the SQL script or press the shortcut Ctrl+K and then I. In case of database objects, the tooltip shows their location and types. You will find this option useful, while working with large scripts.

Automatic SQL syntax check

Syntax check is a great option, as it helps you create error-free SQL code and significantly save time while checking the code. As you start typing, syntax check automatically checks any element in your code. If any errors are found, they are highlighted with red wavy lines. If you place the mouse pointer to any underlined error, you can see the error text in the tooltip.

One-click access to schema objects' definitions

Working with scripts, you can navigate to definitions of schema objects and variables in one click. Right-click an object or a variable in your code and select the Go to definition option from the menu. The mouse pointer will be moved to the object's definition.

If the definition is outside of the current script, an object editor or a corresponding DDL script will open in another window. You will appreciate this feature even more while working with SQL scripts in a database project. A project can contain SQL scripts and query files located in different folders and on different discs, but thanks to Go to definition option you still can navigate to the definitions of database objects from the scripts where these objects are mentioned.

On-the-fly renaming of database objects

Renaming of database objects requires accuracy and time. In SQL editor, you can quickly rename as well as preview the changes before applying them. Save your efforts and rename the following database objects: tables, table columns, views, aliases, stored routines, local variables, triggers, events, UDFs, and users.

To rename an object in the script:

  1. Right-click an object name.
  2. Click Rename on the shortcut menu.
  3. Enter a new name for the object.
  4. Press F2 to preview changes, or press Enter to complete object renaming without preview.

The Preview Changes dialog box organizes all the changes as a tree in the upper part and allows you to preview changes, marked with green, in the bottom part. To apply the changes, click the Apply button at the bottom of the Preview Changes dialog box. To discard changes and close the dialog box, click Cancel.

Extended options for Code Formatting

We format our code to make it standards-driven and clear for other people. dbForge Studio for MySQL and dbForge Fusion for MySQL have a wide choice of options for code formatting. Based on your needs, you can use 4 types of formatting:

  • Automatic
  • Manual
  • Using SQL formatter wizard - to format multiple SQL files at once.
  • Through the command line (not available in dbForge Fusion for MySQL)

Automatic code formatting significantly saves your time. By default, when you finish a statement with a delimiter, it is automatically formatted. You can tune automatic formatting and change the default rules in the Preferences window. In the Tools menu, click Options. When the window opens, expand the Formatting node, select the required tab, and edit the rules. The New Lines, Indentation, Spacing, and Wrapping tabs allow you to preview the selected rule. To apply the rules, click OK.

Code profiles are used for command standardization. You can create your own profiles with necessary statements to format and adjust their formatting. The application also allows modifying existing profiles.

In case you want to format SQL code manually, decide whether you want to format the whole code in your script or only a statement. To format the whole script, in the Edit menu, point to Advanced, and then click Format Document. To format the current statement, right-click the required statement and select the Format Current Statement option from the menu. You can also select one or several statements and choose the Format Selection option from the right-click menu. The selected code will be formatted.

Use SQL Formatter wizard to format SQL code in multiple files or folders. To open the wizard, click SQL Formatter in the Tools menu. On the first wizard's page select whether to format only selected SQL files or files in the selected folders. Move to the next page to select either files or folders. (In our case the files were selected.) To add folders to the list or remove them, use the corresponding buttons in the right corner of the wizard.

To start formatting, click the Format button. When formatting is finished, check the results in the selected files, which are automatically opened.

You can perform all code formatting tasks, including bulk formatting and scheduling, through the convenient command-line interface. To lean more, refer to the Formatting Code through the Command Line entry of the product documentation.

Summary

Nowadays, contemporary tasks require more and more sophisticated work with SQL scripts, so we have to speed up our work, automate coding, and produce standards-driven code. dbForge Studio for MySQL and dbForge Fusion for MySQL have all essential features to help you with creating and editing SQL scripts. You can use code templates to quickly create the required statement, significantly save time using code completion features, and entrust checking errors to automatic syntax check. Renaming of objects or local variables is no longer a time-consuming and troublesome task, but quick and visual with the Renaming feature. Add to your benefits a quick navigation to definitions of database objects and rich options for code formatting.

Make maximum use of SQL text-editing features and produce high-quality SQL code.

Products
Support
Company
  • FREE Products

    FREE Products

    A set of tools distributed free of charge

  • SQL Server Tools

    SQL Server Tools

    Must-have tools for SQL Server database development, management and administration.

  • SSMS Add-ins

    SSMS Add-ins

    Plugins that add missing features to SQL Server Management Studio and improve your productivity while working with Microsoft SQL Server.

  • MySQL Tools

    MySQL Tools

    Must-have tools for MySQL database development, management and administration.

  • Oracle Tools

    Oracle Tools

    Must-have tools for Oracle database development, management and administration.

  • PostgreSQL Tools

    PostgreSQL Tools

    Must-have tools for PostgreSQL database development, management and administration.

  • ADO.NET Providers for Databases

    ADO.NET Providers for Databases

    An enhanced data connectivity solution built over ADO.NET architecture and a development framework with a number of innovative technologies.

  • ADO.NET Providers for Clouds

    ADO.NET Providers for Clouds

    The fastest way to create .NET applications, working with cloud data.

  • ODBC Drivers for Databases

    ODBC Drivers for Databases

    Drivers provide the Direct access to custom databases, which eliminates the use of database client libraries, simplifies the deployment process, and extends your application capabilities

  • ODBC Drivers for Clouds

    ODBC Drivers for Clouds

    Drivers provide the Direct access to custom cloud databases, which eliminates the use of database client libraries, simplifies the deployment process, and extends your application capabilities

  • SSIS Data Flow Components

    SSIS Data Flow Components

    A set of components for SQL Server Integration Services (SSIS) packages that provides easy to set up cost-effective data integration using SSIS ETL engine. Our components offer high performance data loading, convenient component editors, SQL support for cloud data sources and lots of data source specific features.

  • Excel Add-ins for Databases

    Excel Add-ins for Databases

    Excel add-ins that allow you to work with database data in Microsoft Excel as with usual Excel spreadsheets.

  • Excel Add-ins for Cloud Apps

    Excel Add-ins for Cloud Apps

    Excel add-ins that allow you to work with cloud data in Microsoft Excel as with usual Excel spreadsheets.

  • Delphi Data Access Components

    Delphi Data Access Components

    Data Access Components for Delphi, C++Builder, and Lazarus

  • dbExpress Drivers

    dbExpress Drivers

    A database-independent layer that defines common interface to provide fast access to SQL database servers from Delphi and C++Builder on Windows and Mac OS X for both 32-bit and 64-bit platforms

  • Productivity Tools

    Productivity Tools

    A set of tools that help developers to write code, conduct code reviews, compare sources, track the working hours with the web application and much more.

  • ORM Solutions

    ORM Solutions

    A set of tools that are dedicated to producing software targeting the Object-Role Modelling methodology

  • Data Services

    Data Services

    All-in-one cloud service that allows you to integrate, back up, access, and manage your cloud data.

  • SQL Decryptor

    SQL Decryptor

    A free tool for restoring lost definitions and decrypting SQL procedures, functions, triggers, and views in SQL Server databases.

    Download
  • Event Profiler for SQL Server

    Event Profiler for SQL Server

    Convenient GUI to SQL Trace for inspecting SQL Server Database Engine instance. The tool allows you to capture data about each server event.

    Download
  • Search

    Search

    A FREE add-in for SQL Server Management Studio that allows you to quickly search SQL objects and data in your databases.

    Download
  • SQL Formatter

    SQL Formatter

    Free on-line tool for SQL code formatting.

    Learn more
  • T4 Editor

    T4 Editor

    An advanced tool for Visual Studio, T4 Editor includes intellisense, syntax highlighting, code outlining and other features of a top-notch Visual Studio text editing add-in.

    Download
  • dbMonitor

    dbMonitor

    The tool provides visual monitoring of your database applications. dbMonitor performs per-component tracing of database events such as commit, rollback, SQL statement execute, creating and destroying components etc.

    Download
  • Monitor

    Monitor

    A FREE add-in for SQL Server Management Studio that allows you to track and analyse SQL Server performance.

    Download
  • dbForge Studio for SQL Server

    dbForge Studio for SQL Server

    A powerful IDE for SQL Server management, administration, development, data reporting and analysis. The tool will help SQL developers to manage databases, speed up routine tasks, as well, as to make complex database changes.

    Buy Download
  • Developer Bundle for SQL Server

    Developer Bundle for SQL Server

    Take a full control over database development and management with dbForge Developer Bundle for SQL Server with sensational discount in comparison with bying tools separately.

    Buy Download
  • Compare Bundle for SQL Server

    Compare Bundle for SQL Server

    Grab the full power to handle changes in your databases with dbForge Compare Bundle for SQL Server. It will save you hours of work comparing and deploying SQL Server databases.

    Buy Download
  • Schema Compare for SQL Server

    Schema Compare for SQL Server

    Tool for quick and safe schema comparison and synchronization, easy analysis of database structure differences, and deployment of changes to a required SQL Server.

    Buy Download
  • Data Compare for SQL Server

    Data Compare for SQL Server

    Tune your SQL database comparison, quickly analyze differences in a well-designed user interface and effortlessly synchronize data via a convenient wizard.

    Buy Download
  • Data Generator for SQL Server

    Data Generator for SQL Server

    Convenient and easy-to-use GUI tool for a fast generation of large volumes of SQL Server test table data. The tool includes a huge collection of predefined generators with sensible configuration options.

    Buy Download
  • Documenter for SQL Server

    Documenter for SQL Server

    A tool for automatic generation of documentation for SQL Server databases. The tool supports HTML and PDF formats and allows configuring generation on multiple levels.

    Buy Download
  • Query Builder for SQL Server

    Query Builder for SQL Server

    Tool for visual creation of any queries without code typing. Includes lots of innovative options for extended query results management.

    Buy Download
  • Event Profiler for SQL Server

    Event Profiler for SQL Server

    Convenient GUI to SQL Trace for inspecting SQL Server Database Engine instance. The tool allows you to capture data about each server event.

    Download
  • SQL Decryptor

    SQL Decryptor

    A free tool for restoring lost definitions and decrypting SQL procedures, functions, triggers, and views in SQL Server databases.

    Download
  • dbForge Fusion for SQL Server

    dbForge Fusion for SQL Server

    Visual Studio plugin for database development and administration tasks. Explore and maintain existing databases, design compound SQL statements and queries, and manipulate data in different ways.

    Buy Download
  • SQL Formatter

    SQL Formatter

    Free on-line tool for SQL code formatting.

    Learn more
  • Developer Bundle for SQL Server

    Developer Bundle for SQL Server

    Take a full control over database development and management with dbForge Developer Bundle for SQL Server with sensational discount in comparison with bying tools separately.

    Buy Download
  • SQL Complete

    SQL Complete

    An add-in for SSMS and Visual Studio. The tool includes a wide range of code completion, formatting, and refactoring features for quick and high-quality coding.

    Buy Download
  • Source Control

    Source Control

    A powerful SSMS add-in for managing SQL Server database changes in popular source control systems, delivering smooth workflow in a familiar interface.

    Buy Download
  • Unit Test

    Unit Test

    An intuitive and convenient GUI for implementing automated unit testing based on the open-source tSQLt framework in SQL Server Management Studio.

    Buy Download
  • Data Pump

    Data Pump

    An SSMS add-in for filling SQL databases with external source data and migrating data between systems, supporting 10+ widely used data formats.

    Buy Download
  • Index Manager

    Index Manager

    A handy SSMS add-in for analyzing the status of SQL indexes, fixing issues with index fragmentation, and detecting databases that require maintanance.

    Buy Download
  • Search

    Search

    A FREE add-in for SQL Server Management Studio that allows you to quickly search SQL objects and data in your databases.

    Download
  • Monitor

    Monitor

    A FREE add-in for SQL Server Management Studio that allows you to track and analyze SQL Server performance.

    Download
  • dbForge Studio for MySQL

    dbForge Studio for MySQL

    MySQL and Maria DB management tool with well-designed GUI for easy database development and administration. Get the basic functionality of the MySQL and MariaDB front end management tool for free.

    Buy Download
  • Compare Bundle for MySQL

    Compare Bundle for MySQL

    Set of tools for comparison and deployment of any MySQL and MariaDB schema or data changes. Get dbForge Schema Compare for MySQL and Maria DB, and dbForge Data Compare for MySQL products and save about 25%.

    Buy Download
  • Schema Compare for MySQL

    Schema Compare for MySQL

    GUI tool for quick and easy MySQL and MariaDB database schema comparison and synchronization. It will help you analyze database structure differences, and effectively propagate changes to a required MySQL Server.

    Buy Download
  • Data Compare for MySQL

    Data Compare for MySQL

    MySQL and MariaDB GUI tool for quick and easy data comparison and synchronization. Get a convenient way to manage data differences in a well-designed user interface, and customize synchronization.

    Buy Download
  • Data Generator for MySQL

    Data Generator for MySQL

    A powerful GUI tool for generation of massive volumes of test data to populate MySQL database tables. The tool provides a great choice of meaningful generators that yield real-word data.

    Buy Download
  • Query Builder for MySQL

    Query Builder for MySQL

    Visual tool for creating queries of any complexity without code typing. The tool provides a great amount of options to extend query results management.

    Buy Download
  • dbForge Fusion for MySQL

    dbForge Fusion for MySQL

    Microsoft Visual Studio plugin for simplifying all MySQL and MariaDB database development and administration tasks in your favorite IDE.

    Buy Download
  • dbForge Studio for Oracle

    dbForge Studio for Oracle

    IDE for easy development and maintenance of Oracle databases. The tool provides capabilities to browse and edit database objects, debug PL/SQL statements, run SQL statements, edit and export table data, and sync databases.

    Buy Download
  • Compare Bundle for Oracle

    Compare Bundle for Oracle

    Set of tools for comparison and deployment of any Oracle schema or data changes. Get dbForge Schema Compare for Oracle and dbForge Data Compare for Oracle products and save about 25%.

    Buy Download
  • Schema Compare for Oracle

    Schema Compare for Oracle

    Tool for safe comparison and synchronization of database schemas, easy analysis of database structure differences and deployment of changes to a required Oracle server.

    Buy Download
  • Data Compare for Oracle

    Data Compare for Oracle

    Tool for safe and efficient comparison and synchronization of Oracle data, convenient data differences management in a well-designed interface. Get the basic functionality for free.

    Buy Download
  • Data Generator for Oracle

    Data Generator for Oracle

    A GUI tool for populating Oracle schemas with tons of meaningful test data. The tool includes a vast collection of meaningful generators and supports all Oracle versions.

    Buy Download
  • dbForge Fusion for Oracle

    dbForge Fusion for Oracle

    Microsoft Visual Studio plugin that allows you to accomplish all database development and administration tasks in your favorite IDE easily.

    Buy Download
  • Data Compare for PostgreSQL

    Data Compare for PostgreSQL

    The tool for PostgreSQL is intended for quick and safe data comparison and synchronization, convenient management of data differences in a well-designed user interface, and customizable synchronization.

    Buy Download
  • dotConnect for Oracle

    dotConnect for Oracle

    An enhanced ORM enabled data provider for Oracle with Direct connection mode (no need for OCI) and support for Entity Framework and LinqConnect ORMs.

    Buy Download
  • dotConnect for MySQL

    dotConnect for MySQL

    An enhanced enhanced ORM enabled data provider MySQL built over ADO.NET architecture. It supports Entity Framework and LinqConnect ORMs and includes its own ORM model designer – Entity Developer.

    Buy Download
  • dotConnect for PostgreSQL

    dotConnect for PostgreSQL

    An enhanced database connectivity solution for PostgreSQL built over ADO.NET architecture and a development framework with a number of innovative technologies and support for Entity Framework and LinqConnect ORMs.

    Buy Download
  • dotConnect for SQLite

    dotConnect for SQLite

    An enhanced database connectivity solution for SQLite built over ADO.NET architecture and a development framework with a number of innovative technologies and support for Entity Framework and LinqConnect ORMs.

    Buy Download
  • dotConnect for DB2

    dotConnect for DB2

    An enhanced data provider built on ADO.NET technology and IBM DB2 .NET Data Provider, that provides advanced Entity Framework support along with it's own ORM Model designer, and other useful tools and features.

    Buy Download
  • dotConnect for SQL Server

    dotConnect for SQL Server

    A database connectivity solution for SQL Server built over ADO.NET architecture and a development framework with number of innovative technologies.

    Buy Download
  • dotConnect Universal

    dotConnect Universal

    A universal ADO.NET provider for access to data of different databases for the Microsoft .NET Framework.

    Buy Download
  • ODBC Driver for SQL Server

    ODBC Driver for SQL Server

    Devart ODBC Driver for SQL Server provides high-performance and feature-rich connectivity solution for ODBC-based applications to access SQL Server databases directly, avoiding SQL Server Native Client, from Windows, MacOS, Linux, both 32-bit and 64-bit.

    Buy Download
  • ODBC Driver for SQL Azure

    ODBC Driver for SQL Azure

    Devart ODBC Driver for SQL Azure provides high-performance and feature-rich connectivity solution for ODBC-based applications to access SQL Azure databases directly, avoiding SQL Azure native client software, from Windows, MacOS, Linux, both 32-bit and 64-bit, directly via TCP/IP avoiding SQL Server Native Client

    Buy Download
  • ODBC Driver for Oracle

    ODBC Driver for Oracle

    Devart ODBC Driver for Oracle provides high-performance and feature-rich connectivity solution for ODBC-based applications to access Oracle databases directly, avoiding Oracle Client, from Windows, MacOS, Linux, both 32-bit and 64-bit

    Buy Download
  • ODBC Driver for MySQL

    ODBC Driver for MySQL

    Devart ODBC Driver for MySQL provides high-performance and feature-rich connectivity solution for ODBC-based applications to access MySQL databases directly, avoiding MySQL client library, from Windows, MacOS, Linux, both 32-bit and 64-bit

    Buy Download
  • ODBC Driver for PostgreSQL

    ODBC Driver for PostgreSQL

    Devart ODBC Driver for PostgreSQL provides high-performance and feature-rich connectivity solution for ODBC-based applications to access PostgreSQL databases directly, avoiding PostgreSQL native client software, from from Windows, MacOS, Linux, both 32-bit and 64-bit

    Buy Download
  • ODBC Driver for Firebird

    ODBC Driver for Firebird

    Devart ODBC Driver for Firebird provides high-performance and feature-rich connectivity solution for ODBC-based applications to access Firebird databases from Windows, MacOS, Linux, both 32-bit and 64-bit

    Buy Download
  • ODBC Driver for InterBase

    ODBC Driver for InterBase

    Devart ODBC Driver for InterBase provides high-performance and feature-rich connectivity solution for ODBC-based applications to access InterBase databases from Windows, both 32-bit and 64-bit

    Buy Download
  • ODBC Driver for SQLite

    ODBC Driver for SQLite

    Devart ODBC Driver for SQLite provides high-performance and feature-rich connectivity solution for ODBC-based applications to access SQLite databases directly, by linking SQLite library statically into application, from Windows, MacOS, Linux, both 32-bit and 64-bit. ODBC Driver for SQLite also provides SQLite DB encryption to protect your data from unauthorized access.

    Buy Download
  • ODBC Driver for ASE

    ODBC Driver for ASE

    Devart ODBC Driver for SAP Sybase Adaptive Server Enterprise provides high-performance and feature-rich connectivity solution for ODBC-based applications to access ASE databases directly, avoiding ASE client software, from Windows, MacOS, Linux, both 32-bit and 64-bit

    Buy Download
  • ODBC Driver for MongoDB

    ODBC Driver for MongoDB

    Devart ODBC Driver for MongoDB provides high-performance and feature-rich connectivity solution for ODBC-based applications to access MongoDB databases from Windows, MacOS, Linux. ODBC Driver for MongoDB fully supports MongoDB data types and allows using SQL queries to manipulate MongoDB data.

    Buy Download
  • ODBC Driver for xBase

    ODBC Driver for xBase

    Devart ODBC Driver for xBase provides high-performance and feature-rich connectivity solution for ODBC-based applications to access FoxPro and dBase databases from Windows, MacOS, Linux.

    Download
  • ODBC Driver for Salesforce

    ODBC Driver for Salesforce

    Devart ODBC Driver for Salesforce provides high-performance and feature-rich connectivity solution for ODBC-based applications to access Salesforce.com, Force.com cloud CRM and Database.com cloud databases from Windows, both 32-bit and 64-bit

    Buy Download
  • ODBC Driver for Salesforce MC

    ODBC Driver for Salesforce MC

    Devart ODBC Driver for Salesforce Marketing Cloud (formerly known as ExactTarget) provides high-performance and feature-rich connectivity solution for ODBC-based applications to access Salesforce Marketing Cloud databases from Windows, both 32-bit and 64-bit

    Buy Download
  • ODBC Driver for Dynamics CRM

    ODBC Driver for Dynamics CRM

    Devart ODBC Driver for Dynamics CRM provides high-performance and feature-rich connectivity solution for ODBC-based applications to access Dynamics CRM databases from Windows, both 32-bit and 64-bit

    Buy Download
  • ODBC Driver for SugarCRM

    ODBC Driver for SugarCRM

    Devart ODBC Driver for SugarCRM provides high-performance and feature-rich connectivity solution for ODBC-based applications to access SugarCRM databases from Windows, both 32-bit and 64-bit

    Buy Download
  • ODBC Driver for Zoho CRM

    ODBC Driver for Zoho CRM

    Devart ODBC Driver for Zoho CRM provides high-performance and feature-rich connectivity solution for ODBC-based applications to access Zoho CRM databases from Windows, both 32-bit and 64-bit

    Buy Download
  • ODBC Driver for QuickBooks

    ODBC Driver for QuickBooks

    Devart ODBC Driver for QuickBooks provides high-performance and feature-rich connectivity solution for ODBC-based applications to access QuickBooks cloud databases from Windows, both 32-bit and 64-bit

    Buy Download
  • ODBC Driver for FreshBooks

    ODBC Driver for FreshBooks

    Devart ODBC Driver for FreshBooks provides high-performance and feature-rich connectivity solution for ODBC-based applications to access FreshBooks cloud databases from Windows, both 32-bit and 64-bit

    Buy Download
  • ODBC Driver for MailChimp

    ODBC Driver for MailChimp

    Devart ODBC Driver for MailChimp provides high-performance and feature-rich connectivity solution for ODBC-based applications to access MailChimp cloud databases from Windows, both 32-bit and 64-bit

    Buy Download
  • ODBC Driver for BigCommerce

    ODBC Driver for BigCommerce

    Devart ODBC Driver for BigCommerce provides high-performance and feature-rich connectivity solution for ODBC-based applications to access BigCommerce cloud databases from Windows, both 32-bit and 64-bit

    Buy Download
  • ODBC Driver for Magento

    ODBC Driver for Magento

    Devart ODBC Driver for Magento provides high-performance and feature-rich connectivity solution for ODBC-based applications to access Magento cloud databases from Windows, both 32-bit and 64-bit

    Buy Download
  • ODBC Driver for NetSuite

    ODBC Driver for NetSuite

    Devart ODBC Driver for NetSuite provides high-performance and feature-rich connectivity solution for ODBC-based applications to access NetSuite cloud databases from Windows, both 32-bit and 64-bit

    Buy Download
  • SSIS Components for Salesforce

    SSIS Components for Salesforce

    A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor and advanced SQL support, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.

    Learn more
  • SSIS Components for Dynamics CRM

    SSIS Components for Dynamics CRM

    A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor and advanced SQL support, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.

    Learn more
  • SSIS Components for Zoho CRM

    SSIS Components for Zoho CRM

    A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor and advanced SQL support, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.

    Learn more
  • SSIS Components for SugarCRM

    SSIS Components for SugarCRM

    A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor and advanced SQL support, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.

    Learn more
  • SSIS Components for QuickBooks

    SSIS Components for QuickBooks

    A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor and advanced SQL support, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.

    Learn more
  • SSIS Components for MailChimp

    SSIS Components for MailChimp

    A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor and advanced SQL support, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.

    Learn more
  • SSIS Components for Salesforce Marketing Cloud

    SSIS Components for Salesforce Marketing Cloud

    A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor and advanced SQL support, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.

    Learn more
  • SSIS Components for BigCommerce

    SSIS Components for BigCommerce

    A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor and advanced SQL support, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.

    Learn more
  • SSIS Components for Magento

    SSIS Components for Magento

    A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor and advanced SQL support, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.

    Learn more
  • SSIS Components for FreshBooks

    SSIS Components for FreshBooks

    A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor and advanced SQL support, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.

    Learn more
  • SSIS Components for Oracle

    SSIS Components for Oracle

    A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.

    Learn more
  • SSIS Components for MySQL

    SSIS Components for MySQL

    A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.

    Learn more
  • SSIS Components for PostgreSQL

    SSIS Components for PostgreSQL

    A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.

    Learn more
  • SSIS Components for DB2

    SSIS Components for DB2

    A set of SSIS Data Flow components for SQL Server Integration Services (SSIS) packages that includes Source component with convenient editor, Lookup component with advanced caching for best performance, and Destination component with all DML operations support.

    Learn more
  • Excel Add-in Universal Pack

    Excel Add-in Universal Pack

    Devart Excel Add-ins Universal Pack includes Excel Add-ins that allow you to work with cloud and database data like with usual worksheets and save changes to these data back to the data source.

    Learn more
  • Excel Add-in Database Pack

    Excel Add-in Database Pack

    Devart Excel Add-ins Database Pack includes Excel Add-ins that allow working with database data like with usual worksheets. It includes add-ins for DB2, MySQL, Oracle, PostgreSQL, SQL Server, SQLite.

    Learn more
  • Excel Add-in for Oracle

    Excel Add-in for Oracle

    Excel add-in that allows you to connect Microsoft Excel to Oracle, quickly and easily load data from Oracle to Excel, instantly refresh data in an Excel workbook from the database, edit these data, and save them back to Oracle

    Learn more
  • Excel Add-in for SQL Server

    Excel Add-in for SQL Server

    Excel add-in that allows you to connect Microsoft Excel to SQL Server or SQL Azure, easily load data from SQL Server or SQL Azure to Excel, refresh data in an Excel workbook from the database, edit these data, and save them back to SQL Server

    Learn more
  • Excel Add-in for MySQL

    Excel Add-in for MySQL

    Excel add-in that allows you to connect Microsoft Excel to MySQL or MariaDB, quickly load data from MySQL or MariaDB to Excel, instantly refresh data in an Excel workbook from the database, edit these data, and save them back to MySQL

    Learn more
  • Excel Add-in for PostgreSQL

    Excel Add-in for PostgreSQL

    Excel add-in that allows you to quickly and easily connect Microsoft Excel to PostgreSQL, load data from PostgreSQL to Excel, instantly refresh data in an Excel workbook from the database, edit these data, and save them back to PostgreSQL

    Learn more
  • Excel Add-in for SQLite

    Excel Add-in for SQLite

    Excel add-in that you to connect Microsoft Excel to an SQLite database, quickly and easily load data from an SQLite database to Excel, instantly refresh data in an Excel workbook from the database, edit these data, and save them back to the database

    Learn more
  • Excel Add-in for DB2

    Excel Add-in for DB2

    Excel add-in that allows you to connect Microsoft Excel to DB2, quickly and easily load data from DB2 to Excel, instantly refresh data in an Excel workbook from the database, edit these data, and save them back to DB2

    Learn more
  • Excel Add-in Universal Pack

    Excel Add-in Universal Pack

    Devart Excel Add-ins Universal Pack includes Excel Add-ins that allow you to work with cloud and database data like with usual worksheets and save changes to these data back to the data source.

    Learn more
  • Excel Add-in Cloud Pack

    Excel Add-in Cloud Pack

    Devart Excel Add-ins Cloud Pack includes Excel Add-ins that allow you to work with data of various cloud apps like with usual worksheets and save changes to these data back to the cloud app.

    Learn more
  • Excel Add-in for BigCommerce

    Excel Add-in for BigCommerce

    Excel add-in that allows you to connect Microsoft Excel to BigCommerce, easily load data from BigCommerce to Excel, instantly refresh data in an Excel workbook from BigCommerce, edit these data, and save them back to BigCommerce

    Learn more
  • Excel Add-in for Dynamics CRM

    Excel Add-in for Dynamics CRM

    Excel add-in that allows you to connect Microsoft Excel to Microsoft Dynamics CRM, load data from Dynamics CRM to Excel, refresh data in an Excel workbook from Dynamics CRM, edit these data, and save them back to Dynamics CRM

    Learn more
  • Excel Add-in for FreshBooks

    Excel Add-in for FreshBooks

    Excel add-in that allows you to connect Microsoft Excel to FreshBooks, easily load data from FreshBooks to Excel, instantly refresh data in an Excel workbook from FreshBooks, edit these data, and save them back to FreshBooks

    Learn more
  • Excel Add-in for Freshdesk

    Excel Add-in for Freshdesk

    Excel add-in that allows you to connect Microsoft Excel to Freshdesk, easily load data from Freshdesk to Excel, instantly refresh data in an Excel workbook from Freshdesk, edit these data, and save them back to Freshdesk

    Learn more
  • Excel Add-in for G Suite

    Excel Add-in for G Suite

    Excel add-in that allows you to connect Microsoft Excel to G Suite, easily load data from G Suite to Excel, instantly refresh data in an Excel workbook from G Suite, edit these data, and save them back to G Suite

    Learn more
  • Excel Add-in for HubSpot

    Excel Add-in for HubSpot

    Excel add-in that allows you to connect Microsoft Excel to HubSpot, easily load data from HubSpot to Excel, instantly refresh data in an Excel workbook from HubSpot, edit these data, and save them back to HubSpot

    Learn more
  • Excel Add-in for Magento

    Excel Add-in for Magento

    Excel add-in that allows you to connect Microsoft Excel to Magento, quickly and easily load data from Magento to Excel, instantly refresh data in an Excel workbook from Magento, edit these data, and save them back to Magento

    Learn more
  • Excel Add-in for MailChimp

    Excel Add-in for MailChimp

    Excel add-in that allows you to connect Microsoft Excel to MailChimp, quickly and easily load data from MailChimp to Excel, instantly refresh data in an Excel workbook from MailChimp, edit these data, and save them back to MailChimp

    Learn more
  • Excel Add-in for Marketo

    Excel Add-in for Marketo

    Excel add-in that allows you to connect Microsoft Excel to Marketo, quickly and easily load data from Marketo to Excel, instantly refresh data in an Excel workbook from Marketo, edit these data, and save them back to Marketo

    Learn more
  • Excel Add-in for NetSuite

    Excel Add-in for NetSuite

    Excel add-in that allows you to connect Microsoft Excel to NetSuite, quickly and easily load data from NetSuite to Excel, instantly refresh data in an Excel workbook from NetSuite, edit these data, and save them back to NetSuite

    Learn more
  • Excel Add-in for QuickBooks

    Excel Add-in for QuickBooks

    Excel add-in that allows you to connect Microsoft Excel to QuickBooks Online, easily load data from QuickBooks to Excel, refresh data in an Excel workbook from QuickBooks, edit these data, and save them back to QuickBooks

    Learn more
  • Excel Add-in for Salesforce

    Excel Add-in for Salesforce

    Excel add-in that allows you to connect Microsoft Excel to Salesforce, quickly and easily load data from Salesforce to Excel, instantly refresh data in an Excel workbook from Salesforce, edit these data, and save them back to Salesforce

    Learn more
  • Excel Add-in for Salesforce Marketing Cloud

    Excel Add-in for Salesforce Marketing Cloud

    Excel add-in that allows you to connect Microsoft Excel to Salesforce Marketing Cloud, easily load data from Salesforce Marketing Cloud to Excel, instantly refresh data in an Excel workbook from Salesforce Marketing Cloud, edit these data, and save them back to Salesforce Marketing Cloud

    Learn more
  • Excel Add-in for Shopify

    Excel Add-in for Shopify

    Excel add-in that allows you to connect Microsoft Excel to Shopify, quickly and easily load data from Shopify to Excel, instantly refresh data in an Excel workbook from Shopify, edit these data, and save them back to Shopify

    Learn more
  • Excel Add-in for SugarCRM

    Excel Add-in for SugarCRM

    Excel add-in that allows you to connect Microsoft Excel to SugarCRM, quickly and easily load data from SugarCRM to Excel, instantly refresh data in an Excel workbook from SugarCRM, edit these data, and save them back to SugarCRM

    Learn more
  • Excel Add-in for Zendesk

    Excel Add-in for Zendesk

    Excel add-in that allows you to connect Microsoft Excel to Zendesk, quickly and easily load data from Zendesk to Excel, instantly refresh data in an Excel workbook from Zendesk, edit these data, and save them back to Zendesk

    Learn more
  • Excel Add-in for Zoho CRM

    Excel Add-in for Zoho CRM

    Excel add-in that allows you to connect Microsoft Excel to Zoho CRM, quickly and easily load data from Zoho CRM to Excel, instantly refresh data in an Excel workbook from Zoho CRM, edit these data, and save them back to Zoho CRM

    Learn more
  • EntityDAC

    EntityDAC

    EntityDAC is an ORM for Delphi with LINQ support. It provides a powerful framework that allows to perform object-relational mapping of database objects to Delphi classes with full support for encapsulation, inheritance, polymorphism and other OOP features. To retrieve data from a database, LINQ is used as a database independent query engine. In addition, there is a feature-rich ORM modeling tool available – Entity Developer, that allows to create and edit your ORM models visually, and generate Delphi entity classes by this model automatically.

    Buy Download
  • UniDAC

    UniDAC

    Universal Data Access Components (ODAC) is a powerful tool for developing cross-database client/server applications in Delphi, C++Builder, Lazarus (and Free Pascal) under Windows, Mac OS X, iOS, Android, Linux, and FreeBSD for both 32-bit and 64-bit platforms. UniDAC provides a unified interface to access popular database servers such as Oracle, Microsoft SQL Server, MySQL, InterBase, Firebird, PostgreSQL, SQLite, DB2, Microsoft Access, Advantage Database Server, Adaptive Server Enterprise, and more other databases.

    Buy Download
  • ODAC

    ODAC

    Being a feature-rich and high-performance library of components that provides native connectivity to Oracle from Delphi, C++Builder, Lazarus (and Free Pascal) under Windows, MacOS, iOS, Android, Linux, and FreeBSD for both 32-bit and 64-bit platforms, Oracle Data Access Components (ODAC) aims to assist programmers in developing of fast and native Oracle applications. It provides both possibility of connection to Oracle by means of native Oracle data access and directly via TCP/IP without involving Oracle Client.

    Buy Download
  • SDAC

    SDAC

    Being a feature-rich and high-performance library of components that provides direct and native connectivity to SQL Server from Delphi, C++Builder, Lazarus (and Free Pascal) under Windows, MacOS, iOS, Android, Linux, and FreeBSD for both 32-bit and 64-bit platforms, SQL Server Data Access Components (SDAC) aims to assist programmers in developing of fast and native SQL Server database applications. It provides both possibility of connection to SQL Server by means of native SQL Server data access and directly via TCP/IP without involving SQL Server Native Client.

    Buy Download
  • MyDAC

    MyDAC

    Being a feature-rich and high-performance library of components that provides direct access to MySQL from Delphi, C++Builder, Lazarus (and Free Pascal) under Windows, Mac OS X, iOS, Android, Linux, and FreeBSD for both 32-bit and 64-bit platforms, MySQL Data Access Components (MyDAC) aims to assist programmers in developing of fast and native MySQL applications. It provides an additional opportunity to work with MySQL directly via TCP/IP without involving MySQL client library.

    Buy Download
  • IBDAC

    IBDAC

    Being a feature-rich and high-performance library of components that provides native connectivity to InterBase and Firebird from Delphi, C++Builder, Lazarus (and Free Pascal) under Windows, Mac OS X, iOS, Android, Linux, and FreeBSD for both 32-bit and 64-bit platforms, InterBase and Firebird Data Access Components (IBDAC) aims to assist programmers in developing of fast and native Interbase and Firebird applications. IBDAC-based applications connect to the server directly using the InterBase or Firebird client.

    Buy Download
  • PgDAC

    PgDAC

    Being a feature-rich and high-performance library of components that provides native connectivity to PostgreSQL from Delphi, C++Builder, Lazarus (and Free Pascal) under Windows, Mac OS X, iOS, Android, Linux, and FreeBSD for both 32-bit and 64-bit platforms, PostgreSQL Data Access Components (PgDAC) aims to assist programmers in developing of fast and native PostgreSQL applications. It provides opportunity to work with PostgreSQL directly via TCP/IP without involving PostgreSQL Client.

    Buy Download
  • LiteDAC

    LiteDAC

    Being a feature-rich and high-performance library of components that provides native connectivity to SQLite from Delphi, C++Builder, Lazarus (and Free Pascal) under Windows, Mac OS X, iOS, Android, Linux, and FreeBSD for both 32-bit and 64-bit platforms, SQLite Data Access Components (LiteDAC) aims to assist programmers in developing of fast and native SQLite applications. LiteDAC provides an opportunity to work with SQLite directly by static linking of SQLite library in an application. To protect your data from unauthorized access, LiteDAC provides a powerful and customizable SQLite Database Encryption engine.

    Buy Download
  • VirtualDAC

    VirtualDAC

    VirtualDAC (formerly known as VirtualTable) consists of components - TVirtualQuery, TVirtualTable and TVirtualDataSet - that provide such capabilities as working with non-tabular data, performing SQL-queries to data in memory or to data from sources in different RDBMS'es etc., that are not available for standard data access components.

    Buy Download
  • dbExpress Driver for Oracle

    dbExpress Driver for Oracle

    dbExpress is a database-independent layer that defines common interface to provide direct access to Oracle from Delphi and C++Builder on Windows and Mac OS X for both 32-bit and 64-bit platforms. Direct Mode allows to avoid using Oracle Client, that increases developed application performance and simplyfies deployment process.

    Buy Download
  • dbExpress Driver for SQL Server

    dbExpress Driver for SQL Server

    dbExpress is a database-independent layer that defines common interface to provide direct access to SQL Server from Delphi and C++Builder on Windows for both 32-bit and 64-bit platforms. Direct Mode allows to avoid using SQL Server Native Client, that increases developed application performance and simplyfies deployment process.

    Buy Download
  • dbExpress Driver for MySQL

    dbExpress Driver for MySQL

    dbExpress is a database-independent layer that defines common interface to provide direct access to MySQL from Delphi and C++Builder on Windows and Mac OS X for both 32-bit and 64-bit platforms. Direct Mode allows to avoid using MySQL client library, that increases developed application performance and simplyfies deployment process.

    Buy Download
  • dbExpress Driver for InterBase and Firebird

    dbExpress Driver for InterBase and Firebird

    dbExpress is a database-independent layer that defines common interface to provide fast access to InterBase and Firebird from Delphi and C++Builder on Windows and Mac OS X for both 32-bit and 64-bit platforms

    Buy Download
  • dbExpress Driver for PostgreSQL

    dbExpress Driver for PostgreSQL

    dbExpress is a database-independent layer that defines common interface to provide direct access to PostgreSQL from Delphi and C++Builder on Windows and Mac OS X for both 32-bit and 64-bit platforms. Direct Mode allows to avoid using PostgreSQL client software, that increases developed application performance and simplyfies deployment process.

    Buy Download
  • dbExpress Driver for SQLite

    dbExpress Driver for SQLite

    dbExpress Driver for SQLite is a database-independent layer that defines common interface to provide direct access to SQLite from Delphi and C++Builder on Windows and Mac OS X for both 32-bit and 64-bit platforms. SQLite library is statically linked into developed applications, that increases application performance and simplyfies deployment process. dbExpress Driver for SQLite also has support for SQLite database encryption to protect your data from unauthorized access.

    Buy Download
  • Code Review Bundle

    Code Review Bundle

    Code Compare adds value to Review Assistant when tools are used together. That's why they are sold in code review bundle. Buying the bundle saves you money on both tools.

    Buy Download
  • Review Assistant

    Review Assistant

    A peer code review tool for Visual Studio. The tool includes lightweight support for formal code review, allows defect and discussion tracking, integrates with code comparison tools and version control systems to facilitate working with code changes.

    Buy Download
  • Code Compare

    Code Compare

    A popular comparison tool for file and folder comparison and merging, Code Compare takes into account specifics of programming languages (C#, Visual Basic, XML, XAML, etc.), supports two- and three- way comparison and merge.

    Buy Download
  • T4 Editor

    T4 Editor

    An advanced tool for Visual Studio, T4 Editor includes intellisense, syntax highlighting, code outlining and other features of a top-notch Visual Studio text editing add-in.

    Download
  • SecureBridge

    SecureBridge

    SecureBridge is a library of Delphi and C++Builder components for Windows, MacOS, iOS, Android, Linux, FreeBSD, both 32-bit and 64-bit, designed to protect connections between computers and trusted networks against unauthorized access.

    Buy Download
  • dbMonitor

    dbMonitor

    The tool provides visual monitoring of your database applications. It performs per-component tracing of database events: commit, rollback, SQL statement execute, creating and destroying components, connection pooling events etc.

    Download
  • TMetric

    TMetric

    TMetric is a time tracking web application for IT-professionals and companies. The tool will help individuals and organizations to be more productive. TMetric provides time tracking, work session monitoring, reporting tools, integrations and more.

    Learn more
  • Entity Developer

    Entity Developer

    A powerful modelling and code generation tool for ADO.NET Entity Framework, NHibernate, Telerik Data Access, LinqConnect, and LINQ to SQL

    Buy Download
  • LINQ Insight

    LINQ Insight

    A Visual Studio add-in that allows you to execute LINQ queries at design time directly from Visual Studio without starting a debug session and provides a powerful ORM profiler for Entity Framework, NHibernate, LINQ to SQL, and LinqConnect.

    Buy Download
  • LinqConnect

    LinqConnect

    A fast and easy to use ORM solution, developed closely to the Microsoft LINQ to SQL technology

    Buy Download
  • Data Integration

    Data Integration

    Wizard-based integration with no effort, no coding, and no need for special knowledge, performed completely in a cloud

    Learn more
  • Backup

    Backup

    Automatic daily and anytime manual cloud backup with search, view, and export of backed up data and one-click data restore.

    Learn more
  • Query

    Query

    Online SQL editor with visual Query Builder tool to query and manage data with SQL and view them in a grid or as charts.

    Learn more
  • Connect

    Connect

    Connectivity-as-a-service solution that provides standard OData interface to connect to various data sources.

    Learn more