Episode 102 – Mobatek’s MobaXterm

MobaXterm

Enhanced terminal for Windows with X11 server, tabbed SSH client, network tools and much more

MobaXterm is your ultimate toolbox for remote computing. In a single Windows application, it provides loads of functions that are tailored for programmers, webmasters, IT administrators and pretty much all users who need to handle their remote jobs in a more simple fashion.

MobaXterm provides all the important remote network tools (SSH, X11, RDP, VNC, FTP, MOSH, …) and Unix commands (bash, ls, cat, sed, grep, awk, rsync, …) to Windows desktop, in a single portable exe file which works out of the box. More info on supported network protocols

There are many advantages of having an All-In-One network application for your remote tasks, e.g. when you use SSH to connect to a remote server, a graphical SFTP browser will automatically pop up in order to directly edit your remote files. Your remote applications will also display seamlessly on your Windows desktop using the embedded X serverSee demo

You can download and use MobaXterm Home Edition for free. If you want to use it inside your company, you should consider subscribing to MobaXterm Professional Edition: this will give you access to much more features and the “Customizer” software.

They have a live demo ( short screencasts) on their website to highlight some of the key features of the application:

https://mobaxterm.mobatek.net/demo.html

MobaXterm Features

MobaXterm tabbed terminal

From this console window, you will be allowed to run the Unix commands you need: ls, cd, grep, awk, tail, cut, sed, wget, rsync, telnet, ssh, rlogin, rsh … All the essential Unix tools are present. If you need a program that is not available in the basic MobaXterm file, you can download the free plugins.

MobaXterm tabbed terminal

Sessions management

MobaXterm allows you to launch remote sessions. You can choose to create SSH, Telnet, Rlogin, RDP, VNC, XDMCP, FTP, SFTP or Serial sessions. Every session you start is automatically saved and displayed in the left sidebar.

Sessions manager

Graphical SFTP browser

When you log to a remote server using SSH, a graphical SFTP browser pops up on in the left sidebar. It allows you to drag and drop files directly from/to the remote server using a secure SFTP connection.

Graphical SFTP browser


Portable and Light Application


MobaXterm has been packaged as a single executable which does not require admin rights and which you can start from an USB stick

X11 server

When you run a SSH, TELNET or RLOGIN/RSH session you will be able to display your remote applications directly on your local Windows PC. In a SSH session, there is no need to set the “DISPLAY” variable as MobaXterm uses X11-forwarding in order to ease and secure your work.

X11 server

Enhanced X extensions

The embedded X server based on X.org provides the latest features available in recent X server implementations: extensions such as OpenGL, Composite or Randr are included. Xdmcp protocol is also supported.

Enhanced X extensions

Easily Exported Display Variable


DISPLAY is exported from remote Unix to local Windows

Multi-execution

Write once, execute everywhere: this tool allows you to execute the same commands on many different servers at the same time.

Multi-execution

Embedded servers

MobaXterm allows you to start network daemons for remote access. No extra tool or runtime is needed in order to use these daemons.

Embedded servers

Embedded tools

MobaXterm brings some useful tools for sysadmins, developers, webmasters and all users who need to work efficiently with their computer.

Embedded tools

Remote Unix desktop (XDMCP)

Thanks to MobaXterm you can work on your remote Solaris desktop as if you were working locally on your Windows computer using the XDMCP protocol.

Remote Unix desktop (XDMCP)

Remote Windows desktop (RDP)

Take control of your remote Windows computers/servers using the RDP protocol. Many RDP configuration settings are available in the session manager.

Remote Windows desktop (RDP)

SSH gateway

In ssh, telnet, RDP, VNC sessions, you can select a “SSH-gateway” (a.k.a. “jump host”) in order to tell MobaXterm to connect first to a SSH server before connecting to the end-server you want to reach in the end. This allow you to reach some servers behind a firewall and to secure your connection.

SSH gateway

SSH tunnels (port forwarding)

The graphical SSH tunnels manager allows you to create your SSH tunnels using an intuitive graphical tool.

SSH tunnels (port forwarding)

MobApt package manager

MobaXterm package manager (MobApt / apt-get) allows you to download and use much more Unix tools directly into MobaXterm terminal.

MobApt package manager (apt-get)

Text Editor

When you connect to a remote server using SSH, you will be able to edit remote files directly using the embedded text editor “MobaTextEditor” by just double-clicking on them!

Direct edition through SSH / SFTP

Macros support

You can record macros in MobaXterm terminal: everything you type in the terminal will be recorded in order to replay it later on other servers.

Macros support

Passwords management

MobaXterm is able to save your session passwords and to keep them secure by using a “Master password”.

Passwords management

Syntax highlighting in terminal

MobaXterm embedded terminal can highlight syntax or use coloration for keywords, even if you are connected to a remote server which does not support colors. This is useful especially when analyzing log files, editing code or trying to detect important keywords. You can even build your own syntax definitions easily.

Terminal syntax highlighting

Professional Customizer

MobaXterm Professional Edition gives you access to the “Customizer” software. This program allows you to generate customized copies of MobaXterm with your own logo and default settings.

MobaXterm Professional Customizer

MobaXterm plugins

In order to install these plugins, just download them and put them in the same directory than MobaXterm executable.
If you need to enhance MobaXterm with extra tools and commands, you can also use the MobApt package manager: type “MobApt” (or “apt-get”) inside MobaXterm terminal.

CygUtils.plugin: Collection of core UNIX tools for Windows

 Corkscrew: Corkscrew allows to tunnel TCP connections through HTTP proxies

Curl: Curl is a command line tool for transferring data with URL syntax

CvsClient: A command line tool to access CVS repositories

Gcc, G++ and development tools: the GNU C/C++ compiler and other development tools

 DnsUtils: This plugin includes some useful utilities for host name resolution: dig, host, nslookup and nsupdate.

E2fsProgs: Utilities for creating, fixing, configuring, and debugging ext2/3/4 filesystems.

Emacs: The extensible, customizable, self-documenting real-time display editor

Exif: Command-line utility to show EXIF information hidden in JPEG files.

FVWM2: A light but powerful window manager for X11.

File: Determines file type using magic numbers.

Fontforge: A complete font editor with many features

GFortran: The GNU Fortran compiler.

Git: A fast and powerful version control system.

 Git v2.17.2: A fast and powerful version control system.

 Gvim: The Vim editor with a GTK interface

 Httperf: A tool for measuring web server performance.

 Joe: Fast and simple editor which emulates 5 other editors.

Lftp: Sophisticated file transfer program and ftp/http/bittorrent client.

 Lrzsz: Unix communication package providing the XMODEM, YMODEM ZMODEM file transfer protocols.

Lynx: A text-mode web browser.

MPlayer: The ultimate video player

Midnight Commander: Midnight Commander is a feature rich text mode visual file manager.

Multitail: Program for monitoring multiple log files, in the fashion of the original tail program.

NEdit: NEdit is a multi-purpose text editor for the X Window System.

Node.js: Node.js is a platform built on Chrome’s JavaScript runtime for easily building fast, scalable network applications. This plugin does not include NPM.

OpenSSL: A toolkit implementing SSL v2/v3 and TLS protocols.

PdKsh: A KSH shell open-source implementation.

Perl: Larry Wall’s Practical Extracting and Report Language

Png2Ico: Png2Ico Converts PNG files to Windows icon resource files.

Python: An interpreted, interactive object-oriented programming language.

Ruby: Interpreted object-oriented scripting language.

Screen: Screen is a terminal multiplexer and window manager that runs many separate ‘screens’ on a single physical character-based terminal.

Sqlite3: Software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.

 SquashFS: mksquashfs and unsquashfs tools allow you to create/unpack squashfs filesystems from Windows.

 Subversion (SVN): Subversion is a powerful version control system.

 Tcl / Tk / Expect: Tcl is a simple-to-learn yet very powerful language. Tk is its graphical toolkit. Expect is an automation tool for terminal.

 X11Fonts: Complete set of fonts for X11 server.

 X3270Suite: IBM 3270 terminal emulator for Windows.

 XServers: Xephyr, Xnest, Xdmx, Xvfb and Xfake alternate X11 servers.

 Xmllint: A command line XML tool.

 Zip: Zip compression utility.

Snaphat also bundled some other plugins (Python, Cmake, Graphviz, Lua, Readline and CGDB) that you can download from his website.
Rthomson also bundled a “Tmux” plugin that you can download from his website.

Sources for each plugins are available here.
Each license can be found in the corresponding source package.
 If you want to be informed as soon as a new plugin is available, you can Follow @mobatek on Twitter.

Editions

Home Edition
Free
  • Full X server and SSH support
  • Remote desktop (RDP, VNC, Xdmcp)
  • Remote terminal (SSH, telnet, rlogin, Mosh)
  • X11-Forwarding
  • Automatic SFTP browser
  • Master password protection
  • Plugins support
  • Portable and installer versions
  • Full documentation
  • Max. 12 sessions
  • Max. 2 SSH tunnels
  • Max. 4 macros
  • Max. 360 seconds for Tftp, Nfs and Cron

Download now

Professional Edition
$69 / 49€ per user*

* Excluding tax. Volume discounts available

  • Every feature from Home Edition +
  • Customize your startup message and logo
  • Modify your profile script
  • Remove unwanted games, screensaver or tools
  • Unlimited number of sessions
  • Unlimited number of tunnels and macros
  • Unlimited run time for network daemons
  • Enhanced security settings
  • 12-months updates included
  • Deployment inside company
  • Lifetime right to use

https://mobaxterm.mobatek.net/subscription.html

My Story with MobaXterm

I wish it was available for Linux and Mac OS X. It is a great tool for IT Professionals and Serious hobbysts/enthusiasts who need to handle various type of connections all at once without leaving a single application. Unfortunately it is not the case just now and You will see later in this article that while it installs and runs OK under Wine and Crossover most of the protocols do not work in an emulated layer/environment. The good news is that MobaXterm even alerts you with a popup that you are using it under an emulation layer such as Wine when you try to do certain things which makes me believe the developers are aware that a multi platform application ( Linux and perhaps Mac OS X ) is indeed many peoples wish and dream.

I used the free version previously in the past but I have never really started to appreciate it until I made it my go to choice at work in a Windows based laptop where I have to do sysadmin tasks all day long for a living.

I was using 5 different apps throughout the day to get work done as an IT System Administrator. I had separate app / tool for SSH connections ( I used SolarPutty) for RDP I was using the old and now unsupported version of 2.7 of RDCMAN – Remote Desktop Connection Manager 2.7 , for FTP/SFTP I had Filezilla open most of the time while a separate Chrome browser window was sitting on my desk to access GUI interfaces like Synology DSM or Fortigate Firewall Admin Console and I nearly forgot having various command prompt Shell (cmd) open for pings, tracert and for other type of fun .

Sometimes for the best compatibility ( f.e for Synology DSM webpage ) I had to switch from Internet Explorer default browser engine to experimental Chrome engine to get it 100% perfect. I had no issues whatsoever even with the experimental browser engine in my use case. #YMMV

All of the above I do now in one single application in a tabbed interface where I can focus on one screen and one app and I have all the things I need for my work inside this one application in a tabbed fashion.

It leaves the rest of my screen real estate and a second monitor free for other tools like MS Outlook or MS Teams to handle corporate communications ( or just to keep an eye on those) while everything else happens inside MobaXterm.

Under Wine and Crossover v21

Under Mac OS X Monterey 12.0.1 with Crossover v21:
The Preview3 version installs correctly after installing all pre-requisites. 🙂
as its based on wine I will try under Linux and see what happens.

MobaXterm v21.5 (Preview3) installed under Crossover v21 under Mac OS X Monterey 12.0.1

Not all of the protocols I tried works under MobaXterm for the moment
However MobaXTerm detects its running under Wine / CrossOver v21 and informs You that certain functions not implemented or supported yet


SSH: YES
Telnet: YES
Rsh: Could not try — will update with result
Xdmcp: Could not try — will update with result
RDP: NO
VNC: Could not try — will update with result
FTP: YES
SFTP: YES
Serial: Could not try — will update with result
File: Could not try — will update with result
Shell: Tried Bash, Got popup showing feature not implemented yet under Wine
Browser: NO
Mosh: Could not try — will update with result
AWS S3: Could not try — will update with result
WSL: N/A – Under Linux/Mac OS X with Wine and CrossOver there is No Windows Subsystem for Linux



Episode 101 – Devart DbForge Studio

List on dbForge Products
( I will try to be comprehensive )

Paid Products

SQL Server Database Tools

  • dbForge Studio for SQL Server
  • dbForge SQL Complete
  • dbForge Index Manager for SQL Server
  • dbForge Data Pump for SQL Server
  • dbForge Fusion for SQL Server
  • dbForge Data Generator for SQL Server
  • dbForge Transaction Log
  • dbForge Documenter for SQL Server
  • dbForge Source Control for SQL Server
  • dbForge SQL Tools
  • dbForge Compare Bundle for SQL Server
  • dbForge Query Builder for SQL Server
  • dbForge Data Compare for SQL Server
  • dbForge Schema Compare for SQL Server

MySQL Database Tools

  • dbForge Data Compare for MySQL
  • dbForge Fusion for MySQL
  • dbForge Documenter for MySQL
  • dbForge Studio for MySQL
  • dbForge Compare Bundle for MySQL
  • dbForge Query Builder for MySQL
  • dbForge Data Generator for MySQL
  • dbForge Schema Compare for MySQL

ORACLE Database Tools

  • dbForge Compare Bundle for Oracle
  • dbForge Studio for Oracle
  • dbForge Data Generator for Oracle
  • dbForge Schema Compare for Oracle
  • dbForge Documenter for Oracle
  • dbForge Fusion for Oracle
  • dbForge Data Compare for Oracle

POSTGRESQL Database Tools

  • dbForge Data Compare for PostgreSQL
  • dbForge Studio for PostgreSQL

ADO.NET Providers

  • dotConnect for Oracle
  • dotConnect for Zoho CRM
  • dotConnect for SugarCRM
  • dotConnect for Magento
  • dotConnect for QuickBooks
  • dotConnect for Dynamics CRM
  • dotConnect for BigCommerce
  • dotConnect for MailChimp
  • dotConnect for Salesforce Marketing Cloud
  • dotConnect for SQLite
  • dotConnect for Salesforce
  • dotConnect for SQL Server
  • dotConnect for DB2
  • dotConnect for PostgreSQL
  • dotConnect for MySQL
  • dotConnect Universal

Delphi Data Access Components

  • EntityDAC
  • Universal Data Access Components
  • PostgreSQL Data Access Components
  • Oracle Data Access Components
  • SQL Server Data Access Components
  • MySQL Data Access Components
  • Virtual Data Access Components
  • SQLite Data Access Components
  • InterBase Data Access Components
  • SecureBridge

EXCEL Add-Ins

  • Excel Add-in for NetSuite
  • Excel Add-in for Mailchimp
  • Excel Add-in for QuickBooks
  • Excel Add-in for BigCommerce
  • Excel Add-in for Magento
  • Excel Add-in for SQL Server
  • Excel Add-in for SQLite
  • Excel Add-in for HubSpot
  • Excel Add-in Database Pack
  • Excel Add-in for Zendesk
  • Excel Add-in Cloud Pack
  • Excel Add-in Universal Pack
  • Excel Add-in for Salesforce Marketing Cloud
  • Excel Add-in for Freshdesk
  • Excel Add-in for SugarCRM
  • Excel Add-in for Oracle
  • Excel Add-in for Dynamics CRM
  • Excel Add-in for PostgreSQL
  • Excel Add-in for Zoho CRM
  • Excel Add-in for MySQL
  • Excel Add-in for Shopify
  • Excel Add-in for Salesforce

SSIS Data Flow Components

  • SSIS Integration Database Bundle
  • SSIS Integration Universal Bundle
  • SSIS Data Flow Components for PostgreSQL
  • SSIS Data Flow Components for MySQL
  • SSIS Data Flow Components for Google BigQuery
  • SSIS Data Flow Components for Salesforce
  • SSIS Data Flow Components for MailChimp
  • SSIS Data Flow Components for Amazon Redshift
  • SSIS Data Flow Components for Stripe
  • SSIS Data Flow Components for Freshdesk
  • SSIS Data Flow Components for Freshdesk
  • SSIS Data Flow Components for Zoho Desk
  • SSIS Data Flow Components for Zoho Invoice
  • SSIS Data Flow Components for Zoho Inventory
  • SSIS Data Flow Components for Shopify
  • SSIS Data Flow Components for Zoho Books
  • SSIS Data Flow Components for Streak
  • SSIS Data Flow Components for Pipedrive
  • SSIS Data Flow Components for Insightly CRM
  • SSIS Data Flow Components for HubSpot
  • SSIS Data Flow Components for Freshworks CRM
  • SSIS Data Flow Components for Snowflake
  • SSIS Data Flow Components for NetSuite
  • SSIS Data Flow Components for ActiveCampaign
  • SSIS Data Flow Components for Oracle
  • SSIS Integration Cloud Bundle
  • SSIS Data Flow Components for QuickBooks
  • SSIS Data Flow Components for Zoho CRM
  • SSIS Data Flow Components for Dynamics CRM
  • SSIS Data Flow Components for Magento
  • SSIS Data Flow Components for SugarCRM
  • SSIS Data Flow Components for Salesforce Marketing Cloud
  • SSIS Data Flow Components for DB2
  • SSIS Data Flow Components for Twitter Ads
  • SSIS Data Flow Components for Google Analytics
  • SSIS Data Flow Components for Google Ads
  • SSIS Data Flow Components for Zoho People
  • SSIS Data Flow Components for WordPress
  • SSIS Data Flow Components for Podio
  • SSIS Data Flow Components for Jira
  • SSIS Data Flow Components for Asana
  • SSIS Data Flow Components for ShipStation
  • SSIS Data Flow Components for DEAR Inventory
  • SSIS Data Flow Components for Slack
  • SSIS Data Flow Components for SurveyMonkey
  • SSIS Data Flow Components for SendPulse
  • SSIS Data Flow Components for EmailOctopus

ODBC Drivers

  • ODBC Driver for MailChimp
  • ODBC Driver for HubSpot
  • ODBC Driver for Amazon Redshift
  • ODBC Driver for Salesforce
  • ODBC Driver for Oracle
  • ODBC Driver for Dynamics CRM
  • ODBC Driver for xBase
  • ODBC Driver for Zoho CRM
  • ODBC Driver for Dynamics 365
  • ODBC Driver for SQL Server
  • ODBC Driver for NexusDB
  • ODBC Driver for MongoDB
  • ODBC Driver for Salesforce Marketing Cloud
  • ODBC Driver for PostgreSQL
  • ODBC Driver for MySQL
  • ODBC Driver for SQLite
  • ODBC Driver for SQL Azure
  • ODBC Driver for BigCommerce
  • ODBC Driver for Magento
  • ODBC Driver for SugarCRM
  • ODBC Driver for FreshBooks
  • ODBC Driver for QuickBooks
  • ODBC Driver for InterBase
  • ODBC Driver for Firebird
  • ODBC Driver for NetSuite
  • ODBC Driver for Google BigQuery
  • ODBC Driver for ASE
DB-Express Drivers
  • dbExpress Driver for SQLite
  • dbExpress Driver for Oracle
  • dbExpress Driver for MySQL
  • dbExpress Driver for PostgreSQL
  • dbExpress Driver for InterBase
  • dbExpress Driver for SQL Server
Productivity tools
  • Code Review Bundle
  • Code Compare
  • Review Assistant
  • Entity Developer


Free Products / Tools

  • dbForge Studio for SQL Server Express / MySQL Express / Oracle Express / PostgreSQL Express ** Free Edition **
  • dbForge DevOps Automation for SQL Server
  • dbForge Schema Compare for PostgreSQL
  • dbForge SQL Complete Express / SQL Decryptor
  • dbForge Event Profiler for SQL Server
  • dbForge Search / Monitor
  • SQL Formatter for SQL Server
  • Excel Add-ins (some)
  • ADO.NET Data Providers (some)
  • Delphi Data Access Components (some)
  • Other Products ( Code Compare, Review Assistant, T4 Editor, dbMonitor)

===========================================================

PROLOGUE

Honestly it is overwhelming. I mean a lot of products. Maybe its just broken into smaller chunks to create more individual items to be able to sell maybe it is necessary to have this many products this specifically packaged.

Sure I would not want to be on their sales department cause just to learn all the different products they sell and develop let alone the bundles and the way you can combine them together its a huge undertaking in my opinion so kudos for their sales department I am sure it is not an easy job.

Apart from the amount of tools and products once you overcome this generic shock the sheer amount of the different items cause once the dust settle you probably can figure out your way how to navigate through their different product offerings and categories.

I would split in my mind as below but feel free to disagree or do it a better way which suits You.

Tools for Developers like ODBC Drivers, DBExpress Drivers, SSIS Data Flow Components, Delphi and ADO.NET providers so they can program the desired applications or user interfaces to join the pieces together for the End Users.(( I would call them Data Visualizers later it makes sense )) They make the Database Engines / Servers and the Custom Applications or Web Apps on the users computer work in a seamless and easy to use manner without the need for them to know a line of code or get into configuring different pieces to work together to achieve the desired results.
(( need to know programming and not necessarily need to know data ))

Tools for Data Scientists like the Studio products and Database Tools (Compare, Schema, Data Generators, Query Tools) so they can work and mold the data inside the databases ( not necessarily working with special applications and for example websites built by the developers but working with the data on the Database Engine directly)
(( need to know data but not programming 🙂 )

Tools for Data Analysts whom are in my opinion one step above a generic End User whom might be using the Custom Applications or Web Apps developed by the Developers but perhaps not doing that much in depth analytics or deep dive into the data and its meaning or trends than Data Analysts. I might be mistaken tough … Its just my intuition . With the Excel-Add-Ins They are the end users who are neither programmers (developers) nor Data Scientists working with the Data directly on the Database Severs but they make sense and meaning out of the data from the databases via Excel and these Excel Add-Ins or perhaps PowerBI to present it in a Visually Pleasing and Humanly Understandable Manner while they are obviosuly more tech savvy then a generic end user who perhaps open a report from PowerBI or Excel to look at some data already present there but not actually getting into analyzing it or digging deep and customize it any further that is why I referred to them as Data Visualizers above kind of like they are using it with a R/O access the data available to them while the Data Analysts I see more someone with a Limited – R/W access and with a much broader toolset to achieve his/her goal.

Today I want to talk about some of Devart’s paid products

They just had big Black Friday and Cyber Monday sales / deals with up to 50% off on certain products.

A New Year Sale is coming up

If you were unable to pick anything up or missed it completely you can use the below coupon code to get 10% discount for Studio and SQL Tools

Coupon code:

10TSTPODCAST
(( thats TSRPODCAST spelled wrong 🙂 ))

Two key reasons why choose dbForge products ahead of the competition:

  • Perpetual Licenses
    No Subscription here.. You buy it once and You use it / own it
  • Discount Programs
    Can save money participating in many Devart Discount Programs

dbForge Studio for MySQL

dbForge Studio for MySQL is a powerful GUI tool for MySQL and MariaDB for database administration, management, and development.

It is a full-fledged IDE that helps create and execute queries, develop and debug stored routines, automate database object management, compare and synchronize databases, analyze table data, and much more. Its rich functionality is delivered under an intuitive interface.

It is the perfect tool to transition to from MySQL Workbench for those who are looking for a broader set of features and increased performance.

It contains everything you need to work with MySQL databases more effectively.

Let me talk about some of its features. For a complete and exhaustive list of features and information please visit:
https://www.devart.com/dbforge/mysql/studio/features.html

Compare the different Editions:
https://www.devart.com/dbforge/mysql/studio/editions.html

Database Development

Code Snippets and Code Formatting are the most precious features of the dbForge Studio for MySQL tool.

  • Extensive code snippets library
  • Ample formatting options
  • Formatting profiles to suit any taste
  • Formatting code from the Command Line

https://i0.wp.com/devartcdn.azureedge.net/views/content/products/dbforge/mysql/studio/images/code-completion.png?w=840&ssl=1
MySQL Code Completion
https://devartcdn.azureedge.net/views/content/products/dbforge/mysql/studio/images/code-completion.png
MySQL Code Snippets

Snippets are small reusable chunks of code that can be easily inserted in scripts when needed.

The Code Snippets functionality facilitates entering repetitive code patterns and thus saves substantial time and effort. You can use the pre-defined snippets supplied with dbForge Studio for MySQL, or create your own. The use of snippets puts you in the driver’s seat – you code faster and make fewer typos. Handy MySQL Snippets Manager
Studio’s Snippets Manager allows adding new snippets and deleting or modifying the existing ones. In the Manager, you can add and modify snippet shortcuts, literals, and the snippet text itself.

MySQL code snippets manager
Snippets Manager https://devartcdn.azureedge.net/views/content/products/dbforge/mysql/studio/images/snippets-manager.png

Database Compare and Sync

When modifying MySQL database structure, transferring data between servers, analyzing differences between databases, you will:

Database Compare and Sync
https://www.devart.com/dbforge/mysql/studio/images/schema-compare.png

Import/Export Data

Fill MySQL databases with external data using our export and import tools. They support more than 10 popular data formats and allow customizing the whole process. Templates, automating data import and data export tasks through command line are also available.

Copy Database

Transfer MySQL Server databases from one server instance to another with a handy Copy Databases tool. The tool allows you to:

  • Customize copying settings
  • Copy databases together with data
  • Drop a database if it already exists on a target server

Database Designer
Database Diagram
https://devartcdn.azureedge.net/views/content/products/dbforge/mysql/studio/images/database-diagram.png

Use database diagram for creating, analyzing, reverse-engineering, printing and customizing your MySQL databases and for:

  • Viewing foreign key relations
  • Displaying DB objects with properties
  • Execution of stored routines
Visual Query Builder


Visual query creation with diagram and expression editor. Queries of any complexity can be created in several seconds. The GUI tool automatically adds joins between tables and allows working with INSERT, UPDATE, DELETE statements.

Visual Query Builder
https://devartcdn.azureedge.net/views/content/products/dbforge/mysql/studio/images/query-builder.png
Data Generator


Populate your MySQL tables with thousands of rows of realistic test data. Data Generator supports all MySQL data types, includes a large number of meaningful generators with customizable settings, and allows generating data via the command-line interface.

Sophisticated MySQL Formatter

Level-up your scripting abilities with the advanced formatting tool that allows beautifying your code to get it exactly as you like it. The tool is highly customizable and MySQL formatting behavior can be easily configured to fit even the most demanding needs.

Let dbForge Studio for MySQL take care of formatting your queries and spend the freed up time on what really matters – making your code work flawlessly. MySQL Formatter Wizard allows formatting SQL code in multiple files or even folders in the wink of an eye. With the bulk formatting option, you can quickly and easily enforce common coding standards within a team or organization.

MySQL beautifier - formatting options
MySQL Formatter
https://devartcdn.azureedge.net/views/content/products/dbforge/mysql/studio/images/mysql-formatter.png
Built-in formatting profiles

dbForge Studio for MySQL boasts the ability to add new and customize the existing formatting profiles. The default profile can be easily modified up to your needs. On top of that, you can create any number of your own profiles that would comply with the required formatting standards.

Switch between profiles in one click
With this option, you can work in the style you prefer and then easily switch to your team profile when you are ready to deliver. Hundreds of users report the MySQL formatting functionality to be irreplaceable in their everyday work.

MySQL beautifier - formatting profiles
Built-in formatting profiles
https://devartcdn.azureedge.net/views/content/products/dbforge/mysql/studio/images/formatting-profile.png

MySQL Debugger
MySQL Debugger
https://devartcdn.azureedge.net/views/content/products/dbforge/mysql/studio/images/sql-debugger.png


The first debugger for MySQL offers step-by-step code execution, breakpoints, watches, a call stack, a variables evaluation mechanism to automate debugging of MySQL stored routines and triggers, and keeps MySQL server’s logic during the execution of the stored procedure.

Database Administration

Tools for MySQL database administration and management include means for:

  • Managing user privileges
  • MySQL service control
  • Managing server variables
  • Table maintenance
  • Managing server sessions

Database Projects

The Database Project is a collection of SQL scripts and query files which allows you to logically organize them in one place and in an offline mode. With this technology you can compare a database project with a database, by receiving a synchronized script, and deploy database changes.

Table Designer

Visual Designer
https://devartcdn.azureedge.net/views/content/products/dbforge/mysql/studio/images/table-designer.png

Visual designer for modifying or creating table structure, indexes, primary keys, defaults, and CHECK constraints. Get full control over the changes you have made. The heuristics feature will suggest a column type on creating a column based on the name you enter.

Documenter

A tool for generation of MySQL and MariaDB database documentation. Documenter allows you to:

  • Retrieve an overview of the database structure
  • View inter-object and inter-database dependencies
  • Customize documentation with style templates
  • Generate documentation files in the HTML, PDF and Markdown formats
Formatting from
the Command Line

dbForge Studio for MySQL supports a command-line interface thus allowing you to quickly and easily automate and schedule your formatting tasks.

This option lets you automatically format multiple MySQL scripts as a pre-commit hook or as a Continuous Integration (CI) step, which can significantly simplify time-wasting and laborious DevOps operations.

MySQL Formatting from the Command Line
Formatting from the Command Line
https://devartcdn.azureedge.net/views/content/products/dbforge/mysql/studio/images/format-from-cml.png
Intelligent SQL Coding

Intelligent code completion, formatting, MySQL prompt, and code snippets bring convenience and effectiveness to your SQL code writing. Code navigation, obtaining quick object information, and syntax check are performed instantly.

Working on a Test MySQL Database
Random Data inside the Table

Data Generator for MySQL

Generating Meaningful Random Data for the Tables in the Database


I mention Data Generator cause for me it is as useful as any other tool in devart’s products to be able to fill my test tables and databases with meaningful real-life like data to able to test and fine tune a design before it even considered to be discussed as a candidate for a production environment.

Database tools
(SQL tools, mysql tools, oracle tools, postgresql tools)

SQL Tools product from devart when looking at the comparison at devart’s website there are only a few differences here and there what one tool can or can not do compared to the other ( Database Tools Vs Studio products). When I tried to sum the differences up in a clear manner in a couple of words I could not do it so I suggest you check it out for yourself to see which one has or does not have the given function you require.

While in the case of SQL Tools there is an option as much as I can see to get the 15 tools together as SQL Tools Vs the individual items ( such as Query Builder or Schema Compare) there is no Tools’ set grouping the individual items of the same for the other Database Engines ( MySQL, Oracle, PostgreSQL) unfortunately.

Probably it is because of SQL being more popular than the other platforms or engines?

I think it could be nice to buy like in the case of SQL Tools to have all the tools in one package for a discounted price instead of the need to purchase them piece by piece ( Data Generator, Data Compare , Schema Compare, Query Builder, Documenter , Fusion) except the occasional mini bundles of 2-3 items of the tools here and there for Oracle and PostgreSQL and MySQL tools as well.

I feel there is a fine line and certain overlap in features and possibilities between these two product families.

https://www.devart.com/dbforge/mysql/

For many the individual tools or in case of SQL Tools ( the set of tools) are enough for their need/s but for Database Development I think the Studio tools are the best suited as they offer most probably everything you might need.

Closing thoughts

I think if you work or study anything related with Databases these tools can be very useful for you to get things done quicker and in a more efficient manner from a leading developers of database management software, ALM solutions and data providers for most popular database servers.

I wish their apps or at least the main Studio ones were available for Linux as well. It would be a great alternative to Jetbrains Datagrip and Navicat Premium 16 both of which run under Linux and one of the only applications which does close to what devart’s Studio does.

Links

Free SQL Courses


https://www.freecodecamp.org/news/learn-sql-free-relational-database-courses-for-beginners/

  1. Relational Database Curriculum (freeCodeCamp)
  2. SQL Tutorial – Full Database Course for Beginners (freeCodeCamp)
  3. Learn SQL In 60 Minutes (Web Dev Simplified)
  4. SQL For Beginners Tutorial (Amigoscode)
  5. MySQL Database – Full Course (freeCodeCamp)
  6. MySQL Tutorial for Beginners – Full Course (Programming with Mosh)
  7. MySQL Crash Course | Learn SQL (Traversy Media)
  8. SQL for Data Science (UC Davis)