数据库结构智能迁移服务
DB SMART MIGRATE SERVICE
Server software V2.0.0
After comparing the differences in database tables, fields, and indexes in different environments, manually select the change items for the differences. Make changes such as adding, deleting, and renaming, generate SQL files for inspection and migration, and automatically generate SQL file history. Very simple and convenient. No longer do we need a single SQL record.
USD 10
Applicable scenarios
⚪ Resolve the issue of multiple people modifying table structures in parallel to address the problem of mutual influence when publishing to the target environment. ⚪ When making collaborative changes to MySQL table structures, I want to synchronize and migrate the structural changes in the dev environment library to the test environment for intelligent migration. And archive the changed SQL records as required. Download for online execution after checking. ⚪ We want to unify the management of SQL changes on fixed release dates to reduce the workload of multiple developers and people recording SQL.
ThumbsUp
0
Bookmark
0
Target user group
Suitable for developers of enterprise infrastructure teams and business systems, as well as software practitioners in database operations and maintenance.
Computer/Mathematics/Data Analysis
unlimitedCore Features and Functions
Supports multiple languages including Chinese, English, German, French, and Japanese. Display tables, columns, and indexes with differences and decide how to handle them. On the page, users can rename tables and fields to the source table or field names. If the attribute of the field is not null, COMMENT will be automatically generated into the SQL file without any conflict prompts. Every time you click to start comparing, a new version of the SQL file is generated. Available for download and verification. Do not make changes to the data records of columns or tables that are not deleted to ensure data security. Currently, only MySQL is supported. The content items that support migration include: database tables, table properties, column names, column properties, index names, and index properties. Currently, foreign keys are not supported.
The pain points addressed by this product/the shortcomings of competing software products
When competing software performs table synchronization, it adopts a direct synchronization strategy without selecting columns, which will result in the loss of more tables and columns in the target library than in the source library; Competitive software cannot solve the usage scenarios of table renaming and field renaming to tables and fields in the source library; Competitive software cannot manually select and decide how to handle it. Competitive software cannot intuitively perceive which changes have been made, and cannot generate SQL files of the changed content for backup and manual editing and execution. Row data may also be overwritten, causing problems with different environments and string data.
Partners and Successful Cases
The usage scenario of this project in the developer's company is: Every time dev sends the test environment, the testing engineers use it to synchronize the table structure of the dev environment to the test, avoiding errors caused by non-existent table fields and improving communication efficiency between testing and backend developers; Every time the UAT environment is tested, the testing engineers use it to synchronize the table structure of the dev environment to the test, avoiding errors caused by non-existent table fields and improving communication efficiency between testing and backend developers; Every time the UAT environment is released online, only the function of generating migration SQL files is used. Verify accuracy and execute the SQL file directly without using the tool for direct migration to the production environment.
Technical Support and Services
1. Provide free 3-day centralized Q&A and occasional Q&A services afterwards. 2. Provide secondary development services for functions and negotiate payment. 3. If you choose to deploy+download, we will contact you for remote installation. Choose to download only, detailed deployment steps can be implemented, or you can install it yourself. 4. Deliver source code
Deployment/usage prerequisites
1. Local or deployed servers with Java 8 or higher version environment are required 2. Local or deployed servers can access the database to be operated on