> ## Documentation Index
> Fetch the complete documentation index at: https://docs.bytebase.com/llms.txt
> Use this file to discover all available pages before exploring further.
# Limitations
While migration-based workflow is powerful and flexible, be aware of these considerations:
## Version Conflicts
**Issue:** Multiple developers creating migrations with the same version number.
**Solution:** Use timestamp-based versioning (`YYYYMMDDHHmmss`) to avoid conflicts.
## Migration Order Dependencies
**Issue:** Complex dependencies between migrations can be hard to manage.
**Solution:**
* Keep migrations small and focused
* Use descriptive names
* Document dependencies in comments
* Consider state-based workflow for pure schema changes
## Rollback Complexity
**Issue:** Reverting migrations requires writing reverse scripts.
**Solution:**
* Plan rollback strategy before deploying
* Test rollback scripts in staging
* Consider using Bytebase's data rollback feature for DML changes
Automatic rollback for INSERT/UPDATE/DELETE operations
## Large-Scale Deployments
**Issue:** Deploying to hundreds or thousands of databases takes time.
**Solution:**
* Use database groups for fleet management
* Configure parallel execution limits
* Enable sampling for validation (check N random databases)
Production-ready workflow patterns and optimizations
***
## Next Steps
Learn about the declarative alternative
Production-ready workflow patterns
Solutions for common issues
Return to GitOps overview