Upsert^® Migrator is a powerful development framework that empowers developers to manage database migrations, schema changes, and data transformations across SugarCRM environments with precision and reliability.

Streamline your development workflow

Schema management

Create, modify, and deploy database schema changes with confidence. Generate migration files that handle table creation, column modifications, index management, and updates across all your SugarCRM environments. Built specifically for SugarCRM upgrades, Migrator ensures changes are preserved and properly managed in your Sugar deployment.

Intelligent data transformations

Execute complex data migrations with PHP logic that understands your SugarCRM structure. Transform records, update field values, and maintain data integrity during environment promotions and Sugar upgrades.

Environment synchronization

Keep your development, staging, and production environments perfectly synchronized. Deploy schema changes and data updates with version-controlled migration files that can be safely executed in any environment.

Key developer benefits

Version-controlled migrations

Every database change is captured in version-controlled migration files, ensuring your database schema evolves alongside your code. Track changes, rollback when needed, and maintain a complete audit trail of all database modifications.

SugarCRM-aware operations

Leverage SugarCRM's SugarBean classes and relationships within your migrations. Perform complex operations that understand your CRM's data structure, ensuring migrations work seamlessly with your existing SugarCRM configuration.

Flexible execution options

Run migrations as standalone scripts or integrate them directly into your SugarCRM instance. Choose the execution method that best fits your deployment pipeline and development workflow.

Query capture and replay

Capture SQL queries during development and automatically convert them into reusable migration scripts. Perfect for promoting complex data transformations and ensuring consistent results across environments.

Advanced decision logic

Implement sophisticated migration logic with full PHP capabilities. Create conditional migrations, perform data validation, and execute complex business rules during your database transformations.

Collaborative development workflow

Independent migration development

Each developer can create and manage their own migration files without conflicts. The framework automatically handles migration ordering and ensures that each developer's changes are applied in the correct sequence, even when working on different features simultaneously.

Team coordination

Multiple developers can work on different aspects of the same SugarCRM instance without stepping on each other's toes. Each migration is timestamped and versioned, allowing team members to develop database changes independently and merge them seamlessly.

Conflict-free deployments

Deploy migrations from multiple developers in a single operation. The framework intelligently resolves dependencies and ensures that all team members' database changes are applied in the correct order, maintaining data integrity across all environments.

Isolated development environments

Developers can test their migrations in isolation before sharing with the team. Run individual migrations, test complex data transformations, and validate schema changes without affecting other team members' work.

System requirements

Upsert^® Migrator is compatible with:

• Sugar Sell, Serve, Ent, and Pro products
• Versions 12.0 and higher
• Hosted on-site