Database

Types of Database Supported

The Application supports multiple Databases like SQL, Oracle and Cloud. The commonly used Database in our application is MS SQL Server.

Create Database

The user has to create a database before going to Login into Application. Creating a New Database includes Entering the Database name, Choosing the Server type and connecting to Server.

Upgrade Database

Upgrading the Database means that bugs, internal errors and other technical issues can be identified and resolved as soon as possible, thereby reducing downtime.

Backup Database

To prevent data loss, the User has to create a backup of the Database on an external device.

Backup and Detach Database are different in the sense that, Backup creates a copy of the Database in an external device and Detach Database will disengage the Database from the instance. In the Detachment, the Database is unavailable to use but the underlying Database files remain and the user can re-attach the Database any time later.

Restore Database

Restore is the process of copying data from a backup file.

Restore and Attach Database are different in the sense that, Restore is copying the data from Backup and Attach Database is Attaching the underlying files into the instance that was previously detached.

Detach Database

Detach Database is a process of disengaging the files from the instance. The Database will be unavailable to use but the underlying Database files remain and the user can re-attach the Database anytime later.

Attach Database

Attach Database is re-attaching the underlying Database files to the existing instance that were previously detached.

Export and Import Using BACPAC Package

In the Backup and Restore mechanism, the user has to copy a whole Database and then Restore it completely which is time-consuming. When the user wants to backup some particular Tables from the Database and then Restore those Tables, it can be done using BACPAC Package.