DBMS: Environment copy

– “The environment copy, what is it for?”

The environment copy allows you to duplicate an environment and thus have 2 identical environments (same structure, same tables, same data) on 2 different servers.

The interest is to have, for example, a development environment identical to that of production (in the case where the prod environment is copied in dev) and to provide developers with a working base reliable and up-to-date before they start coding (Caution, it may be necessary to anonymize the data!).
In other cases, the environment copy can make it possible to put a test environment into production, if it has successfully passed all the validation stages, or to set up a DRP (Disaster Recovery Plan) on D-1.

Finally, if the duplication is done through backups, this makes it possible to validate their viability.

Incontournable CIP Nice-Sophia Antipolis

This evening, afterwork “Incontournable Nice – Sophia Antipolis” organized by the Club Informatique Provence Méditerranée – CIP.

dbSQWare will be present during this unique event which will begin in Le Muy, with a visit to the company Mecatech, which specializes in the machining of industrial parts, and will continue in Les Arcs-sur-Argens with a visit to the Domaine de Font du Broc and its remarkable vineyard.

Exchanges, conviviality and networking will be there.
Good Indispensable to all the participants who will have the chance to be present and a big congratulations to the CIP for the organization of this exceptional event!

CIP NETWORK SHOW: M-1

The CIP Network Show is in 1 month!

On June 8, dbSQWare will be one of the exhibitors at this Business IT event in the southern region, organized by the Club Informatique Provence Méditerranée – CIP.

Meet at the Palais des Congrès du Parc Chanot, in Marseille, to share about the management and maintenance of database management systems!

MOTION DESIGN VIDEO

The dbSQWare team is proud to present its new Motion Design video.

A big thank you to Damien Dalmasso of Mooovie Studio for his listening and his remarkable work.
And this is only the beginning of our collaboration, since other small videos will soon come to complete this one.

Back to IT & CYBERSECURITY Meetings 2022

IT and Cybersecurity Meetings 2022 are over!

A big thank you to all the decision-makers who came to meet our team during this show.
Discussing the management of database engines is always a pleasure for Séverine Payan and Michel Payan

Congratulations to Carole Jardon and her team for the organization and the quality of the event.
dbSQWare will be present for the next edition, in 2023.

And thank you to our colleagues and partners for their great sympathy!

IT & CYBERSECURITY Meetings 2022

The IT & Cybersecurity Meetings in Cannes is now!
After setting up the stand last night and the welcome meal, the show opens its doors to visitors from 9:00 a.m. this morning until tomorrow evening, 6:00 p.m.

The dbSQWare team is in place and waiting for you on stand G14 to discuss the management and maintenance of database management systems. It will present its software with many features (backup, restore, copy of environments, update statistics, etc.) which supports 12 types of DBMS (Oracle, PostgreSQL, MySQL, MariaDB, Sybase, SQLServer, MongoDB, etc.).
Do not hesitate to come and meet him.

And above all, a very good show to all the participants!

Incontournable CIP Nice-Sophia Antipolis_03/2022

This evening, afterwork “Incontournable Nice – Sophia Antipolis” organized by the Club Informatique Provence Méditerranée – CIP.

Michel Payan from dbSQWare will be present at this event which will take place at the Mercure Antibes Sophia Antipolis hotel and which will start at 6:30 p.m.
Exchanges, conviviality and networking will be there.

Good Essential to all!

DBMS : Restoration

– “Restoring a database, what does it consist of? »

To be able to restore a database, you must already have made a backup (full, incremental, log, hot or cold).
Then, restore consists of recovering the backed up files that make up the database.

A well-planned backup and restore strategy helps protect databases from data loss.
It is therefore essential to regularly check your strategy, restoring a set of backups to recover your database.
 

CANDLEMAS

Today is Candlemas!
The opportunity to share a good time with colleagues, friends or family!

Happy pancakes everyone!!

DBMS: Backups

– “By the way, what’s the point of making database backups? »

As its name suggests, a database is a structured collection of data. It consists of files in which the data is stored.
It is created and managed by a database management system (DBMS) which, among other things, allows data to be recorded, searched for, sorted and modified.

Data is at the heart of business activity. It is extremely valuable and its loss can be devastating when there is no copy.
This is why it is essential to make backups of the databases.

There are several types of backup:
– the “full backup”: all the files of a database are copied
– the “incremental backup”: only the blocks of files that have been modified since the last backup are copied
– the “log backup” (redo log, transaction log, wal or xlog): transaction log files are copied. These files are used to memorize all the modifications carried out on a database.

Backups can be made:
– cold: when the database is stopped
– or hot: when the database is active.

Once the backups have been made, it is then possible to recover the data if necessary.

And since trust does not exclude control, it is a good idea to check compliance with the backup policy on a daily basis across the entire database.