Entries with Blog Categories Database .

Column level Encryption and Decryption in MSSQL

Information is a very confidential thing in today's era to protect that from unauthorize and unauthenticated access to secure that data we should encrypt and decrypt that data. Here are the steps to encrypt and decrypt your data in the database at a column level.
Read More About Column level Encryption and Decryption in MSSQL

Table Trigger In MySQL

Want to perform an action in the database before/after INSERT, UPDATE, and DELETE statement? Here are the steps to create a table trigger in the database.
Read More About Table Trigger In MySQL

MySql Event Scheduler

MySql provides the facility to execute events on a specific time, it can be repetitive and can be single, this is called scheduled events. Here is the way to execute and create event schedulers in MySql.
Read More About MySql Event Scheduler

Liferay Database migration from 6.2 to 7.1/DXP

Now, ready to upgrade database Liferay 6.2 to 7.1, Liferay 7.1/DXP gives upgrade tool to upgrade everything. It’s the best, most comprehensive thanks to upgrade tool provided by Liferay. Please follow below steps to upgrade database(Steps are given for both Ubuntu/Window). Steps Create a new database for Liferay 7.1/DXP in MySQL server e.g. create database ...
Read More About Liferay Database migration from 6.2 to 7.1/DXP

Database Replication

As we all know, Replica is nothing but just a copy of something and the process to create a replica of something is called Replication. Now let’s define the term Database Replication. Database Replication Database Replication is a technique to transfer the exact replica of each database instances from a database to other databases located in the same or different server to provide ...
Read More About Database Replication
Showing 5 results.
contact-us Request a callback