This Article will show you How to Import and Export a MS SQL database using SQL Server Management Studio (SSMS) 1. In SQL Server Management Studio, connect to an instance of the SQL Server Database Engine. 2. Expand Databases. 3. Right-click a database. 4. Point to Tasks. 5. Click one…
This guide will take you through the steps of restoring a database in phpMyAdmin. 1. Log in to cPanel. 2. Click on “phpMyAdmin”. 3. Click on a database that will be used to take on the tables of the backup database. If you do not have a database listed, then…
If you are into web development then you no doubt work with databases a lot. Most of us create databases in cPanel without even thinking about what we need to use it for. As a result, we hardly give any thought to which database engine (or storage engine) to use for our…
This quick guide will take you through the steps of changing the password to a database user in cPanel. Step 1. Log in to cPanel. Step 2. Click on “MySQL Databases”. Step 3. Scroll down to the “Current Users” section and click on “Change Password”. Step…
This guide will take you through the steps of creating a database in Website Panel (.Net). Step 1. Log in to Website Panel (.Net). Step 2. Click on “Databases”. Step 3. Select the type of database you would like to create. Step 4. Click…
This guide will take you through the steps of creating a user for a database in Website Panel (.Net). Step 1. Log in to Website Panel (.Net). Step 2. Click on “Databases”. Step 3. Select the database type for which a user needs to be created. Step…
This Article will show you How to generate a MSSQL database backup from WebsitePanel Login to WebsitePanel. Navigate to your user. Select the database type SQL Server 2008. Click on the database name for which you want to generate the backup e.g. accu_test_DB. Expand the Maintenance Tools option, click on…
If you use MySQL or Microsoft SQL Server, you can manage permissions for database users through the Plesk UI, such as the permissions to perform operations on table structure and data. For MySQL these permissions are Select, Insert, Create, Drop and so on, and for Microsoft SQL Server these permissions…
This article provides you with information on how to access your database using ODBC connection. If your application needs to access external databases through ODBC, you can create the necessary ODBC connection in Plesk. After you have created the ODBC connection, you can customize the application to…
Our Plesk environment allows you to host MySQL as well MSSQL database. In the article below we will cover how to access your MSSQL databases hosted on Windows Plesk To access your MSSQL database you will require the following: 1. A static IP address (To be whitelisted…