Our Latest Insights

Insight Spotlight

Migrating from Oracle 19c to 26ai with AutoUpgrade: A real-world example

Migrating from Oracle 19c to 26ai with AutoUpgrade: A real-world example

By DBA Zone Team

Explore a practical, real-world example of using Oracle AutoUpgrade to migrate an Oracle Database 19c non-CDB database to Oracle Database 26ai. Understand the basic preparation required, configure AutoUpgrade, use the analyze utility to identify and resolve migration issues, and complete the migration with the deploy utility. In this post, we demonstrate that AutoUpgrade has matured into a practical option for DBAs facing major-version Oracle migrations and navigating the transition from non-CDB to CDB/PDB architecture.

Read more

More Insights from the DBA Zone

How to Change Microsoft SQL Server Instance Collation Without Reinstalling

How to Change Microsoft SQL Server Instance Collation Without Reinstalling

By: DBA Zone Team

Microsoft SQL ServerCollationSQL Server AdministrationDatabase Management

Explore two approaches for correcting a Microsoft SQL Server instance-level collation without performing a complete uninstall and reinstall. We cover the Microsoft-documented system database rebuild method as well as an alternative method using the -q startup parameter. Understand the impact of each approach, preparation considerations, and the importance of verifying both instance and user database collations after the change

Full article