Audience
Application developers seeking a tool to manage their database migration operations
About Alembic
Alembic is a lightweight database migration tool that can be used with the SQLAlchemy database toolkit for Python. Alembic is written by the author of SQLAlchemy. While Alembic can be installed system-wide, it’s more common that it’s installed locally in a virtual environment, as it also uses libraries such as SQLAlchemy and database drivers that are more appropriate for local installations. Can emit statements to a database in order to change the structure of tables and other constructs. Provides a system whereby "migration scripts" may be constructed; each script indicates a particular series of steps that can "upgrade" a target database to a new version, and optionally a series of steps that can "downgrade" similarly, doing the same steps in reverse. Very open-ended and transparent configuration and operation. A new Alembic environment is generated from a set of templates which is selected among a set of options when setup first occurs.
Other Popular Alternatives & Related Software
AWS Database Migration Service
AWS Database Migration Service helps you migrate databases to AWS quickly and securely. The source database remains fully operational during the migration, minimizing downtime to applications that rely on the database. The AWS Database Migration Service can migrate your data to and from most widely used commercial and open-source databases. AWS Database Migration Service can migrate your data to and from most of the widely used commercial and open source databases. It supports homogeneous migrations such as Oracle to Oracle, as well as heterogeneous migrations between different database platforms, such as Oracle to Amazon Aurora. Migrations can be from on-premises databases to Amazon Relational Database Service (Amazon RDS) or Amazon Elastic Compute Cloud (Amazon EC2), databases running on EC2 to RDS, or vice versa, as well as from one RDS database to another RDS database. It can also move data between SQL, NoSQL, and text-based targets.
Learn more
Flyway
Robust schema evolution across all your environments. With ease, pleasure, and plain SQL. Version control for your database, so you can migrate it with ease and confidence. Flyway lets you regain control of your migrations with ease. Flyway migrates your database, so you don't have to worry about it. Releases have never been this easy. Plain SQL scripts (including placeholder replacement). No proprietary XML formats, no lock-in. Java-based migrations for advanced data transformations and handling with LOBs. All you need is Java 7+ and your Jdbc driver and you're good to go! Filesystem and classpath scanning to automatically discover SQL and Java migrations. Safe for cluster environments. Multiple machines can migrate in parallel. Ship migrations together with the application and run them automatically on startup using the API. Inconsistent database or failed migration prevents app from starting.
Learn more
Ispirer Toolkit
Ispirer Toolkit performs automated cross-platform database and application migration. Regardless of whether you need to modernize an application or a database, Ispirer Toolkit is able to do both. The toolkit includes SQLWays Wizard to migrate databases and nGLFly Wizard for application migration.
We offer migration of data, as well as schema, including SQL objects.
We have experience working with more than 20 deviating and trending RDBMS, cloud platforms as a source or target respectively.
We perform modernization of legacy applications, e.g. COBOL, Progress 4GL, Informix 4GL, Delphi, PowerBuilder to modern technologies, including WEB architecture, provided by the .NET and Java ecosystems.
A key feature of Ispirer Toolkit and at the same
time an advantage over our competitors is the power to customize the tool to better suit requirements of every particular conversion project.
Learn more
Phinx
Most database migration tools are framework dependent, complicated, confusing to install/configure and a pain in the ass to write migrations for. In less than 5 minutes you can install Phinx, create and execute your first migration. Phinx supports migrations written in both PHP and SQL. Use the PHP syntax to make your migrations portable between different database vendors or hand-code advanced queries. It's your choice. As Phinx executes from the command-line, it is painless to integrate with your deploy, build or CI tool. Phinx is and will always remain completely free, open-source software. Developers are encouraged to fork, hack and modify Phinx. If you use Phinx commercially then please consider making a donation or purchasing the screencast provided. Buy the introductory screencast and help support Phinx development. Phinx has extensive documentation available.
Learn more
Pricing
Starting Price:
Free
Free Version:
Free Version available.
Company Information
Alembic
Founded: 2010
United States
alembic.sqlalchemy.org/en/latest/
Videos and Screen Captures
Other Useful Business Software
AestheticsPro Medical Spa Software
AestheticsPro is the most complete Aesthetics Software on the market today. HIPAA Cloud Compliant with electronic charting, integrated POS, targeted marketing and results driven reporting; AestheticsPro delivers the tools you need to manage your medical spa business. It is our mission To Provide an All-in-One Cutting Edge Software to the Aesthetics Industry.
Product Details
Platforms Supported
Cloud
Windows
Mac
Linux
Training
Documentation
Support
Online
