Questions tagged [export]
The process and means of extracting data from a database for use elsewhere.
310
questions
0
votes
0
answers
24
views
How can I export PostgreSQL data from multiple tables joined by foreign keys, preferably as insert statements?
I'd like to automate exporting data from one database to be inserted to another.
The data is stored in multiple tables joined by foreign keys, so rows from the parent table need to be inserted by for ...
- 101
0
votes
1
answer
55
views
Export-DbaScript: How can I make it make a directory if it doesn't already exist?
I like to use Export-DbaScript to export to folders that are named C:\TargetFolder\Database\Schema. Often, I don't already have a Database\Schema folder, which will cause Export-DbaScript to fail to ...
- 545
0
votes
1
answer
32
views
Microsoft SQL Server Import Export Wizard on Remote SQL Server
Is it possible to run the SQL Server Import/Export Wizard purely on a remote server (e.g., from one database to another on the same remote server)?
If I setup the source/destination connections in the ...
- 103
0
votes
1
answer
104
views
Export from DB2 table to CSV with minimal client memory
How can I export a large volume of data from a DB2 database to a CSV file
without consuming much client memory?
Data volume : The result-set contains 100 Million Records, 14GB in size when written to ...
- 1
1
vote
1
answer
35
views
How to import MySQL RAW Database files without connection error
unfortunately I did not create a 'dump' file with the backup (Data Export) process on MySQL Workbench 8.0.26.
When I copy the old database files to the new Data directory, the server fails to start ...
0
votes
0
answers
36
views
import db and users from mysql 5
There's a working Mysql 5 database that I want to import into a MariaDB on another machine, including tables, data, users and privileges.
Is There a pretty simple way to do that? I'm not so expert in ...
- 1
0
votes
0
answers
13
views
What is a good mechanism to get production database data into other environments along with de identifying it
I am sure this is a solved problem and many people would have a great process already in place.
How do I easily get data in my production server to other environments like staging and testing. We ...
0
votes
1
answer
106
views
How to export db file from SQLLite
I have uploaded my csv file to https://sqliteonline.com/ and it is currently available as a table. I need to export this data to .db file to use it elsewhere. I tried exporting the table, but I only ...
- 103
0
votes
0
answers
36
views
Dump postgres table into a directory structure?
I have a table "templates" with about 150 records. Each record has various attributes, but the one of greatest interest is the "template" column, which is a text field that ...
- 588
1
vote
1
answer
487
views
TablePlus exporting without error but can not import it back
Exporting a table with 22,245 rows using TablePlus, after which TablePlus tells me "Export completed successfully".
If I create a new database and try to import the file I just exported, I ...
- 141
1
vote
1
answer
823
views
How to export PostgreSQL database structure while ignoring objects created by PostGIS
I want to export the database structure from a PostgreSQL database. I want to include all tables, functions, etc., created by me but exclude everything created by database extensions like PostGIS. ...
- 111
0
votes
1
answer
267
views
How difficult and how much time should it take to export a DB to a flat file?
How difficult of a process is it to export a database to a flat-file? Should it take seconds, minutes, hours, or days to complete an export?
I have no knowledge of the database structure, beyond the ...
- 11
0
votes
1
answer
233
views
Exporting via Phpmyadmin Charset
MySQL 5.7
I am exporting my db from my web host using phpmyadmin. This produces a single .sql file.
When I check the export with Notepad+, there are special characters in the file.
e.g. in my source ...
- 177
1
vote
0
answers
189
views
How to export MySQL in a format accepted by DigitalOcean database clusters?
I am struggling with importing my databases to Digital Ocean database clusters. They have a setting that requires the primary key to be defined in the CREATE TABLE statement, but all my tools (...
- 141
1
vote
0
answers
191
views
How to use mongoexport with a dynamic variable for date on windows batch file?
Here is my working script:
mongoexport --db db1 --collection Transaction --out C:\Users\Admin\transactionstats.json --query="{"PaymentDate":{"$gte":{"$date":"...
- 149