I believe that you will often encounter various business scenarios that require data migration in your daily development, and if you want to migrate quickly but don't want to type code hard, find a tool that can make this task easy and fast, only 3 simple steps, and novices can get started directly!
Prepare for data migration
SQLynx: A small, no-install database management development tool, free for the personal edition. It supports simultaneous access and management of multiple data sources, and the interface is simple and easy to use.
SQLynx, a graphical database management development tool
Data Migration Trilogy
Step 1:
Open the source table you want to migrate, call it table A for easy differentiation, and copy its DDL table creation statement.
Copy the DDL information of table A
Copy the DDL information of table A
Step 2:
Open the target database location to be migrated and create a new table based on the replicated DDL address, which we call table B here.
Create table B in the destination database
Step 3:
Select Table A, right-click Data Migration, simply set parameters such as the number of lines, OK, transfer it!
Data Migration
Just a few moments, 13 million rows of data can be transferred:
Data migration results
The table we tested this time is about 1.6GB, 12 fields and 13 million rows of data, without any settings or optimization, it can be migrated in 348s, and we also tested the migration to the database on the remote server in the same table, which takes 579s due to factors such as network transmission speed, which is still very worry-free overall.
Data Sheet
Transactional execution of data migration
In addition, SQLynx can support data operations, and you can choose whether to execute transactions during data migration, which can avoid checking the completed part of the data and ensure the consistency of the migrated data.
SQLynx supports transaction execution
*Of course, we can also choose to export the SQL file from table A, and then go to table B to import the SQL file.
Save the query results to the table
SQLynx supports direct migration and saving of query results to a new table, and we directly store the data returned by the query statement to other locations in the database through the [Save to Table] function, which can be exported to the local without the need to export to the local area, which further improves work efficiency.
Save the data of the query results to a new table
Finally, we can also use SQLynx for backup and recovery of the entire database, which can easily choose the entire database or some of its data tables to be backed up locally or restored, whether you are a DBA or a developer, tens of millions of data migrations will become more concise and efficient.