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
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
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
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
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
$300 in Free Credit Towards Top Cloud Services
Start your project in minutes. After credits run out, 20+ products include free monthly usage. Only pay when you're ready to scale.
Product Details
Platforms Supported
Cloud
Windows
Mac
Linux
Training
Documentation
Support
Online
