Upsert® Migrator is a powerful development framework that empowers developers to manage database migrations, schema changes, and data transformations across SugarAI (formerly 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 SugarAI environments. Built specifically for SugarAI 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 SugarAI 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.
SugarAI-aware operations
Leverage SugarAI'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 SugarAI configuration.
Flexible execution options
Run migrations as standalone scripts or integrate them directly into your SugarAI 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 SugarAI 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
- Sugar Sell, Serve, and Enterprise products
- Versions 14.x and higher
- Hosted on-site