Devart dbForge Studio for SQL Server/MySQL/Oracle/SQL Complete AIO

This article is the original content of AppNee. All rights reserved. To repost or reproduce, please make a footnote with our article link!

Devart dbForge Studio for SQL Server/MySQL/Oracle/SQL Complete AIO

Devart's dbForge Studio is a series of database server all-in-one software from Czech Republic. It can help database developers and administrators efficiently fulfill any complex routine tasks on three primary RDBMS (relational database management system): Microsoft SQL ServerMySQL and Oracle Database.

Because this is a collection type of post, AppNee can not show you the every detail of Devart dbForge Studio's these three products. Instead, we only make the following simple introduction:

ProductDescription
dbForge Studio for SQL Serverprovides comprehensive solutions to perform effective exploration and analysis to the large data sets in SQL Server database, and allows to design/generate all kinds of report forms to help make reasonable decisions
dbForge Studio for MySQLis specially designed to automate and simplify the tasks on MySQL. It provides an easy manner to explore and maintain existing databases, to design compound SQL statements, to query and manipulate data in different ways, etc.
dbForge Studio for Oraclehelps Oracle SQL developers to increase PL/SQL coding speed, provides versatile data editing tools for managing in-database and external data
dbForge SQL Completeprovides a wide range of code completion features that relieve users from remembering long and complex object names, column names, SQL operators, etc., but instead allows concentrating on writing high-quality SQL code with proper formatting that is easy to understand and interpret.

Here, AppNee will share the full setups, unlock patches/unlocked files along with installation notes for Devart dbForge Studio's 3 most important database server products: dbForge Studio for SQL Server, dbForge Studio for MySQL and dbForge Studio for Oracle, as well as dbForge SQL Complete.

// Key Features //

dbForge Studio for SQL ServerdbForge Studio for MySQLdbForge Studio for Oracle
  • SQL Coding Assistance
  • SQL Source Control
  • Index Manager
  • Unit Test
  • Table Designer
  • Database Diagram
  • T-SQL Debugger
  • Query Profiler
  • Schema Compare
  • Data Compare
  • Data Generator
  • Documenter
  • Query Builder
  • Data Export and Import
  • Database Administration
  • Server Event Profiler
  • Data Editor
  • SQL Server Reporting
  • Master-Detail Browser
  • Pivot Table
  • Broad Compatibility Options
  • Intelligent SQL Coding
  • Database Compare and Sync
  • Visual Query Builder
  • Database Designer
  • Import/Export Data
  • Database Backup
  • Database Administration
  • MySQL Debugger
  • Table Designer
  • Database Refactoring
  • Query Profiler
  • Report and Analysis
  • PL/SQL coding assistant
  • Database Project
  • Oracle Database Management
  • Object Manager
  • Oracle PL/SQL Debugger
  • Query Profiler
  • Schema Import/Export
  • Database Administration
  • Database Designer
  • Import/Export Data
  • Report and Analysis
SQL Complete-/--/-
  • SQL completion and code suggestion
  • Code Refactoring
  • Code Formatting
  • Document management
  • Data Grid commands
  • Connection management
  • Extended menu options
  • UI/User experience capabilities
n/an/a

// Connectivity //

ProductConnectivity
Microsoft SQL Server
  • SQL Server 2016
  • SQL Server 2014
  • SQL Server 2012
  • SQL Server 2008, 2008R2 (including Express edition)
  • SQL Server 2005 (including Express edition)
  • SQL Server 2000 (including MSDE edition)
  • Local DB
  • SQL Azure
  • Working with SQL Server on Amazon RDS
MySQL
  • Support for all MySQL server versions 3.23-5.x
  • Support for all MariaDB server versions 5.5-10.0
  • Secure connections via SSL/SSH
  • HTTP connections via PHP tunnel
  • Support for UTF-8 databases
  • Work with MySQL embedded server
  • Direct access to MySQL server without client libraries
  • MySQL pluggable authentication and Windows authentication on connecting to MySQL server (PAM)
  • Support for Windows authentication when creating connection to MySQL server
  • Working with MySQL on Amazon RDS and on Amazon Aurora
  • Percona PAM Authentication for MySQL
  • Sphinx Search Engine
Oracle
  • Support for all Oracle versions, from 8i to 12c
  • Using different Oracle Homes in single application
  • Support for Oracle Real Application Clusters
  • Instant Client support
  • Direct server access
  • Working with Oracle on Amazon RDS
SQL Complete
  • SQL Server 2016 (including Express edition)
  • SQL Server 2014 (including Express edition)
  • SQL Server 2012 (including Express edition)
  • SQL Server 2008, 2008R2 (including Express edition)
  • SQL Server 2005 (including Express edition)
  • SQL Server 2000
  • SQL Azure
  • SQL Server Compact
  • Visual Studio 2017/2015/2013/2012
  • SSMS 2016
  • SSMS 2014 (including Express edition)
  • SSMS 2012 (including Express edition)

// Official Demo Video //

// System Requirements //

  • Microsoft Windows 7+
  • Windows Server 2008+
  • Microsoft .NET Framework 4.5.2+

// Edition Statement //

AppNee provides the Devart dbForge Studio for SQL Server/MySQL/Oracle and SQL Complete Professional/Enterprise Edition full installers, unlock patches and unlocked files for Windows 32-bit and 64-bit.

// Installation Notes //

for v5.4/v5.5/v7.4/v4.7:

  1. Download and install dbForge Studio for SQL Server/MySQL/SQL Complete
  2. Copy the unlocked file(s) to installation directory and overwrite
  3. Done!

for v3.10:

  1. Download and install dbForge Studio for Oracle
  2. Copy the unlocked file to installation directory and overwrite
  3. Delete the native image from cache:
    • Command Prompt (x32): C:\Windows\Microsoft.NET\Framework\v4.0.30319\ngen.exe uninstall "C:\Program Files\Devart\dbForge Studio for Oracle\dbforgeoracle.exe"
    • Command Prompt (x64): C:\Windows\Microsoft.NET\Framework64\v4.0.30319\ngen.exe uninstall "C:\Program Files\Devart\dbForge Studio for Oracle\dbforgeoracle.exe"

*** To generate the native image again:

  • Command Prompt (x32): C:\Windows\Microsoft.NET\Framework\v4.0.30319\ngen.exe install "C:\Program Files\Devart\dbForge Studio for Oracle\dbforgeoracle.exe" /NoDependencies /ExeConfig:"C:\Program Files\Devart\dbForge Studio for Oracle\dbforgeoracle.exe"
  • Command Prompt (x64): C:\Windows\Microsoft.NET\Framework64\v4.0.30319\ngen.exe install "C:\Program Files\Devart\dbForge Studio for Oracle\dbforgeoracle.exe" /NoDependencies /ExeConfig:"C:\Program Files\Devart\dbForge Studio for Oracle\dbforgeoracle.exe"

for v5.3/v7.1/v3.9:

  1. Download and install dbForge Studio for SQL Server/MySQL/Oracle
  2. Do not run it
  3. Apply the unlock patch
  4. That's all!

* The unlock patch requires Microsoft .NET Framework 4.0+ to run

** The 32-bit and 64-bit patches of dbForge Studio for Oracle are all suitable for both 32-bit & 64-bit Windows. But, on Windows 64-bit, the corresponding 32-bit/64-bit Oracle client may be required.

Devart dbForge Studio for SQL Server/MySQL/Oracle/SQL Complete AIO

Devart dbForge Studio for SQL Server/MySQL/Oracle/SQL Complete AIO

// Related Links //

// Download URLs //

LicenseVersionDownloadSize
dbForge Studio for SQL Server
Enterprise Editionv5.3Devart dbForge Studio for SQL Server/MySQL/Oracle/SQL Complete AIO109 MB
v5.4Devart dbForge Studio for SQL Server/MySQL/Oracle/SQL Complete AIO106 MB
v5.5Devart dbForge Studio for SQL Server/MySQL/Oracle/SQL Complete AIO110 MB
Professional Editionv3.0reservedn/a
v4.0reservedn/a
dbForge Studio for MySQL
Professional Editionv6.0reservedn/a
v6.3reservedn/a
v7.1Devart dbForge Studio for SQL Server/MySQL/Oracle/SQL Complete AIO28.8 MB
Enterprise Editionv7.4Devart dbForge Studio for SQL Server/MySQL/Oracle/SQL Complete AIO109 MB
dbForge Studio for Oracle
Professional Editionv3.1reservedn/a
v3.8reservedn/a
v3.9Devart dbForge Studio for SQL Server/MySQL/Oracle/SQL Complete AIO40.0 MB
v3.10Devart dbForge Studio for SQL Server/MySQL/Oracle/SQL Complete AIO38.8 MB
dbForge SQL Complete
Standard Editionv4.7Devart dbForge Studio for SQL Server/MySQL/Oracle/SQL Complete AIO10.5 MB

(Homepage)

If some download link is missing, and you do need it, just please send an email (along with post link and missing link) to remind us to reupload the missing file for you. And, give us to some more time to respond.
If there is a password for an archive, it should be "appnee.com".