Export and import data
Being able to import and export data is useful when you move data between databases that are used for different purposes but need to share some data. For example, between development and production databases.
IntelliJ IDEA has an engine to export and import data in various formats. You can select a predefined format or create your own.
For more information about export and import operations, see the following topics:
Export: see how to generate DDL for objects and export data in different formats.
Import: import CSV, TSV, or any other text files that contain delimiter-separated values. Also, learn how to restore the dump file by using mysql, pg_restore, or psql.
Run migrations: learn how to use migration tools in IntelliJ IDEA.
Data extractors: learn about default extractors and creating custom extractors.