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
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
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
Yandex Data Transfer
The service is easy to use, you don’t need to install any drivers, and the entire migration process is configured via the management console in just a few minutes. The service lets you keep your source database running and minimize the downtime of the apps that use it. The service restarts jobs itself if any problems occur. If it can’t continue from the desired point in time, it automatically returns to the previous migration stage. A service for migrating your databases from other cloud platforms or local databases to Yandex cloud-managed database services. You need to start a transfer, which is the process of transmitting data between two endpoints. The endpoints contain the settings of the source database you’re going to transfer the data from and those of the target database for your data. The Yandex Data Transfer service allows you to perform various types of transfers between source endpoints and target endpoints.
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
Powerful App Monitoring Without Surprise Bills
Tired of monitoring tools that punish you for scaling? AppSignal offers transparent, predictable pricing with every feature unlocked on every plan. Track errors, monitor performance, detect anomalies, and manage logs across Ruby, Python, Node.js, and more. Trusted by developers since 2012 with free dev-to-dev support. No credit card required to start your 30-day trial.
Product Details
Platforms Supported
Cloud
Windows
Mac
Linux
Training
Documentation
Support
Online
