The 2020 version of dbSQWare offers a new graphical interface to its users.
Completely redesigned and updated, it is now much more fluid and intuitive.
You can consult it on our demo site and choose your connection profile by following the instructions in the tooltip (i).
Then, all you have to do is navigate …

Demo on: http://webdba.dbsqware.com

The version 2020.01 of dbSQWare which has just been released, presents many new features.
Completely redesigned, the software now offers a much lighter, fluid and intuitive graphical interface.
Many features have been added, such as:
– the choice of navigation language
– cvs, pdf and excel exports on filtered and sorted data from reporting tables
– management of access rights on menus
– asynchronous feedback of indicators
– encryption and decryption of connection files
Without forgetting that dbSQWare is the only DBMS management and maintenance software, capable of managing in a homogeneous way, 11 different types of database engines, thus offering to its users, a similar approach and vision, whatever the DBMS concerned.

We are very happy to announce the release of the new version 2020.01 of our software, dbSQWare.
Expected by our users, this version offers a new web interface, UX / UI Design, which makes navigation much more fluid and intuitive.
There are also many new features such as asynchronous indicator feedback, encryption / decryption of connection files, management of menu rights, …
All the changes are available on the “Release Notes” page, “Technical” section of our website.

Relational databases are manipulated with SQL (Structured Query Language), while NoSQL databases (Not Only SQL) are characterized by a logic of non-relational data representation and do not (or rarely) offer query interface in SQL.
Some differences :
– Structure: In a relational database, the data schema (tables, keys, procedures, …) must be designed to be able to manipulate data. With NoSQL, data can be added anywhere and at any time (in most cases).
– SQL normalization / NoSQL denormalization: In SQL, the data are not duplicated and are linked together by foreign keys. In NoSQL, they can be duplicated and copied into several different records.
– Join: SQL queries allow the JOIN clause. NoSQL generally has no joins.
– Scalability: Following an increase in load, relational side, it is often chosen to increase the size of the server rather than putting clusters on the instances. With NoSQL, data organization allows partitioning and scaling up of the database on current deployed hardware.
Their common point: dbSQWare!

– “Do you know what the job of DBA is?”
A DBA (DataBase Administrator) is responsible for the design, implementation and management of DBMS.
He also ensures the maintenance by adapting them according to the technological evolutions and the needs of the company.
The database administrator is responsible for the accessibility, quality and security of the data.
He also acts as technical support and support for IT developers and users.

– “What is the benefit of dbSQWare for a DBA?”
Thanks to our software of SGBD management and maintenance, backup, restore, environment copy and indicator collection tasks become easy and are followed.
DBA teams can free up time and focus on higher value-added tasks.

The 2019.05 version of dbSQWare has just been released!
With 2 new features:
– for Sybase: the addition of tracing of changes on structures (tables, columns and indexes) and the ability to compare the structures of two schemas;
– for MariaDB: the integration of the MariaBackup backup system.

For more information, all changes are available on the “Release Notes” page of our website (“Technical” tab).

Relooking sessions for our software thanks to UX / UI Design’s mission, from atrioom company (Service Design / UX Strategy).
Developments are underway to modify our platform and soon offer our users a smoother and more ergonomic navigation.
A big thank you and congratulations to the designers: Aurélien Beguet, Alexis Sadowski and Marie Vacher for their listening, their involvement and their creativity!

dbSQWare is the only software in France, able to exploit and maintain, in a completely homogeneous way, 11 types of database engines (R & NoSQL).
But we will not stop there!
A 12th engine will soon be coming in … This is Tibero, a relational database management system developed by the South Korean publisher TmaxSoft and designed to support complex and large-scale systems.

I’m still talking about our dbSQWare software, but do you know the main features it offers for DBMS operation and maintenance?
Here is a recap:
Copy environments – Backup and restore – Reorganization – Update Statistics – Dashboard / Vision 360 ° – Customization
Very flexible, dbSQWare adapts to all companies, whatever their size and activity.

dbSQWare is an operating and maintenance software for DBMS.

– “But by the way, what is a DBMS?”
To put it simply, a database is a set of files in which data are stored.
A Database Management System (DBMS) is system software designed to create and manage databases.
It allows to read, write, modify, sort or restore the information of the database, according to the requests made by the user.
Existing DBMS are many, varied and most of the time, of different design.

– “And dbSQWare, in all this ?”
dbSQWare is used to operate, in a homogeneous and uniform way, all the DBMS installed on a computer park.

With dbSQWare, the user manages all of his DBMS with one tool.