Updating from an Innoslate 4.5 or Older Database
Your Guide to Updating Your Database Before Upgrading to Innoslate
To upgrade your Innoslate Enterprise instance from version 4.5 or earlier, you must modify the database for compatibility. Updating the `author` field is critical to avoid upgrade issues. Please follow the steps below to update the `dbo.DATABASECHANGELONG` table using SQL Server Management Studio (SSMS).
Steps to Update the Database
1. Open SQL Server Management Studio (SSMS):
- Launch SSMS and connect to the database instance hosting your Innoslate Enterprise database.
2. Modify the `dbo.DATABASECHANGELONG` Table:
- Execute an SQL command to update the `author` column in the `dbo.DATABASECHANGELONG` table.
- Change the `author` value from `'Chris Ritter'` to `'Innoslate'`.
Run the following SQL query in SSMS to make the change:
UPDATE dbo.DATABASECHANGELONG
SET author = 'Innoslate'
WHERE author = 'Chris Ritter';
3. Verify
Once the database change is complete, verify the update by querying the table:
SELECT * FROM dbo.DATABASECHANGELONG WHERE author = 'Innoslate';
Then proceed with the Innoslate Enterprise upgrade as planned.