dbeaver / dbeaver/dbeaver

Exporting multiple table data via Database using Bulk option misses inserting data for random tables

Open
#36,170 2 comments 0 reactions 0 assignees View on GitHub
xf:datatransfer
Dominant language
Java
Stars
51.8k
Forks
4.4k
Avg merge
3d 13h
Merged PRs (30d)
183

Description

### Description

I'm trying to copy data from multiple tables to another PostgreSQL instance, so I've:
1. selected the tables to copy
2. right click -> Export Data
Options:
- Export Target: Database
![image](https://github.com/user-attachments/assets/c925b0a4-e1df-48f3-a0c8-ef20556679cf)
![image](https://github.com/user-attachments/assets/765ce56f-6955-4c1d-87cf-2f6abe090839)

Upon proceeding, it goes through the motions and the status updates look correct, however when it opens up each table after it's finished with each table, some of them have no data in them. _Note: I'm exporting the data into new tables that don't yet exist on the target SQL instance, and all of the tables themselve do get created, it's just some are missing their data_

If I run it again, deselecting the tables that completed successfully, again, for the tables that are successful, it will copy all of the table's data in, but other tables do not get _any_ of their data copied... it seems to work successfully every time if I do it 1-by-1.

### DBeaver Version

Community Version 24.2.4.202411031831

### Operating System

Windows 10

### Database and driver

PostgreSQL 42.7.2

### Steps to reproduce

_No response_

### Additional context

_No response_

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.