Alter Database Collation

Author: Kepion Product Team

Introduction

You can alter the collation of a Kepion database by performing the following steps:

Steps

Step 1. Backup your application database.

Step 2. Script out the application database, including both schema and data. Take a look at the following article to see the detailed steps.

Step 3. Include in the script a default database collation. For example:

ALTER DATABASE [NEW] COLLATE Modern_Spanish_CI_AI;

You can insert the collation setting right after the compatibility level settings. See the highlighted region below:

Step 4. Drop your application database.

Step 5. Run the script and ensure you wait for it to fully complete.