Can we achieve DB2 to MSSQL Pega data Upgrade using BIX Schema- schema Load ?
We are trying to upgrade Pega from 8.4 to 24.1.2 and needs to migrate data from DB2 to MSSQL schemas. Will pega support this type of Schema to Schema ?
@SambasivaRaoP BIX is designed for exporting data from Pega to flat files or external databases for reporting or archiving—not for full platform data migration or schema-to-schema upgrades across different database types. In your case, since you’re migrating from DB2 to MSSQL while upgrading from Pega 8.4 to 24.1.2, you’ll need a proper database migration and platform upgrade strategy. This usually involves exporting data using BIX or a similar tool, then transforming it (due to DB differences), and importing it into a clean MSSQL-based Pega instance that’s already upgraded to 24.1.2. Pega doesn’t officially support a direct “schema load” between different DB engines like DB2 to MSSQL. You should also consult with Pega Global Customer Support for best practices and tools like Data Migration Pack (DMP) if available.