Author: Kepion Product Team
You can alter the collation of a Kepion database by performing the following 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.