Questions tagged [export]

The process and means of extracting data from a database for use elsewhere.

Filter by
Sorted by
Tagged with
0
votes
0answers
52 views

Exporting SQL query very slow in Oracle SQL Developer

I have written a query and I'm able to run it successfully. When I try to export it, its exporting speed is very slow i.e. 50 rows per 10-15 mins. I managed to export it around 50k data in 10 hours....
1
vote
0answers
18 views

MS Azure remote back up with SqlPackage

I wanted to do an export of a .bacpac file from MS Azure database, from local machine, with command like this: sqlpackage.exe /Action:Export /ssn:tcp:<ServerName>.database.windows.net,1433 /sdn:...
0
votes
1answer
29 views

DB2: how to export data file and own by db2inst1 via ADMIN_CMD

There is some requirement that I need to run the export command in Java via JDBC. Hence below is the command I execute CALL SYSPROC.ADMIN_CMD('EXPORT TO /tmp/header.csv OF DEL SELECT * FROM MYTABLE');...
0
votes
0answers
21 views

MongoDB Move data to another shard

I have a MongoDB with 3 shards: A, B, C. B's disk is full so everytime I start mongod it eventually stops. However, A and C still have GB of space. Hiring a new server with more space than B and ...
0
votes
0answers
191 views

exceeds the maximum allowed database size when export database oracle 18c

I have worked on Oracle Database 18c Express Edition, while I try to export database schema by using expd command, I have an issues ORA-12954: The request exceeds the maximum allowed database size ...
0
votes
1answer
51 views

deadlock detected during oracle expdp

I have an Oracle 11g and I wanted to export all my shcema objects, with this command: expdp as '/ as sysdba' directory=DIR dumpfile=DWH%U.dmp logfile=DWH.log filesize=40000m parallel=32 schemas=DWH ...
0
votes
0answers
33 views

ORACLE timed Datapump on Linux? (No crontab)

what is the best way to create a timed Datapump Dump of a PDB on a Linux System? No Crontab. And how do I implement it?
0
votes
0answers
24 views

Postgresql, export to xml, <row> rename

When exporting to xml, I have this output. "<product><table xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"" xmlns=""test""> <row> ... </row> <row> ... etc ...
0
votes
1answer
160 views

Postgresql, export to json

Version: PostgreSQL 11.4 (Ubuntu 11.4-1.pgdg19.04+1). Question: Is possible export to json file? Something like csv export. COPY ( SQL ) TO stdout DELIMITER '"' csv; Thanks. Update: Or can I add ...
1
vote
1answer
454 views

exporting a sql view to a csv file

Whilst I can just about script to pull data via queries, I'm finding it very difficult to figure out how to export the results of a query to a .csv file and save in a network storage location (novice ...
0
votes
1answer
28 views

Will exporting tables in one db server to another db server release space in server?

Our production db server mount points are 95% full.There are a few tables which are not required. Hence if I export those tables to our test db server and drop those tables, will it release space in ...
0
votes
0answers
42 views

Mysqldump is not exporting the full table (phpmyadmin and sqlyog neither)

When I export the table from PhpMyAdmin it downloads a .sql file with just a small part of the database (like 2 or 3% my table is 84M rows) I have tried with SQLYog and mysqldump with a similar result....
0
votes
0answers
43 views

How to copy/export part of my SQL database

So I have this huge live SQL database. I want to do some testing so I thought to export it, however, it is around 200 GB which is impossible to export. I thought maybe I export the schema of it and ...
3
votes
1answer
49 views

What kind of database is this schema for, and how can I open it?

For sentimental reasons, I'm trying to export my text messages from an old feature phone (LG Cosmos 2, circa 2011) to a flat file (CSV or the like). I was able to successfully transfer the entire ...
1
vote
0answers
15 views

Custom Export from power BI service

I'm trying to make a custom button that exports filtered tables to a csv and downloads them to my computer. I am aware that you can do this with the '...' button but this functionality is for other ...
0
votes
2answers
899 views

MongoDB CSV Export: One Array/Column & Array Index on rows, or vice versa

I have a MongoDB schema that looks like this: const batchSchema = mongoose.Schema({ _id: mongoose.Schema.Types.ObjectId, time: {type: [Number]}, tmp: {type: [Number]}, hum: {type: [Number]}, ...
0
votes
1answer
112 views

Use data from Mysql to ElasticSearch with Logstash

I'm using logstash for use my mysql database in ElasticSearch My conf is the next. input { jdbc { jdbc_connection_string => "jdbc:mysql://[ip]:3306/nextline_dev" jdbc_user =&...
1
vote
0answers
56 views

All columns of all views defined as “1” in phpmyadmin export

MySQL 5.7.24, phpmyadmin 4.8.3 phpMyAdmin appears to export corrupted definition on all views of one of my MySQL database. Eg: show create view v_contacts returns CREATE ALGORITHM=UNDEFINED DEFINER=`...
-1
votes
1answer
436 views

What are the advantages and disadvantages of using a embedded sql database? [closed]

What are the advantages and disadvantages of using an embedded SQL database instead of MySQL server? I am a web developer and I'm planning to develop an application for the shop, without investing my ...
3
votes
0answers
134 views

Does Google CloudSQL Export function lock tables?

In order to create more 'data recovery' points than the standard automatic backup policy allows, I'm going to run a cron which will export sql dumps out of my CloudSQL instances at intervals ...
0
votes
1answer
47 views

Copy Table from one MySQL server to another

Is there a way to copy or export a large table from MySQL server to postgres without affecting servers performance. I mean the table is very large and using mysqldump or any select query has bad ...
0
votes
2answers
157 views

Get Headers from SQL Table

I am looking for a way to dynamically get the headers from a table without having to write them (select 'header1' as "header1"...., 'header50' as "header50" from MyTable) It doesn't work above a ...
2
votes
1answer
313 views

How to copy a tablespace to another database without using Data Pump in Oracle 11G

I have a database on a legacy system that has some data that needs to be exported to another environment. Everything I need is contained in one tablespace. Unfortunately, I am unable to use Data Pump ...
1
vote
0answers
95 views

Can pg_dump be broken into batches for large DBs?

I have a fairly huge DB and pg_dump croaks on me when I try to export it to a single file. Is there a way to do it in batches, whereby each batch would cover a segment of tables and export the schema/...
1
vote
0answers
31 views

How to fully dump mySQL database via workbench?

I am exporting database in SQL file using workbench. Export is done successfully, but when I import data and compare record counts with older database, some of the records are missing. Not all records ...
1
vote
1answer
5k views

How to automate CSV-exports of queries in PL/SQL Developer (Oracle)?

I'm no pro in Oracle or PL/SQL Developer (I mostly use and admin mySQL and MS SQL Server). I'm not an admin of any sort, but have read access to many tables in Oracle via PL/SQL Developer. I need ...
-1
votes
1answer
1k views

Export all SSIS packages from SSISDB

We have quite a few SSIS packages on SQL Server 2012 deployed to SSISDB, you can right-click on a project and select 'Export' saved as an *ispac file, however, is there a script to Export All Projects ...
1
vote
1answer
1k views

How to export user with tables and tablespace oracle

I'm a newbie to Oracle World. I have to export, from computer A, tables and their data, to computer B. So, my question is: is there a way to export user, tablespace, tables and their data with one ...
-1
votes
1answer
93 views

How to update the first row in the exported query from sqlcmd

I am trying to find an easy way of updating the first row in the export of a sqlcmd query to CT_EVENT,,,,,,,,,,,,,,,,,,,,,,,,. I found this article in stack overflow which builds the csv format. I've ...
-1
votes
1answer
344 views

MySQL user export PASSWORD is showing up as <secret>

I am trying to export all users from old MySQL server to new. All the methods that I tried shows the PASSWORD as <secret> pt-show-grants phpMyAdmin 4.8.1 https://serverfault.com/questions/...
2
votes
1answer
61 views

How to export base and discover its structure

We are with a small problem at work. Our DBA decided to go around the world on a journey of self-discovery. I really love the idea and wish the best for him. The only detail is that he left without ...
0
votes
1answer
371 views

Exporting a Database schema and triggers

I have a small problem at work. Our DBA went on a journey of self-discovery ... I am very happy for him and I hope he finds what he is looking for. But he left us without any information about how the ...
7
votes
2answers
2k views

How to back up an entire database to text files

If it’s stupid and it works, it’s still stupid. The hullabaloo about GDPR got me thinking - if you had to go into your backups and modify/delete data, how would you do it? Cracking open a .bak file ...
0
votes
1answer
57 views

Is there any scenario where a exported (.sql) database dump could be bigger in size, than the database itself?

I'm a developer in a local company, and I'm currently working on a project which involves migrating a website to my company's server, from some other hosting provider. For some reason this other ...
1
vote
0answers
35 views

Replace oldSchema with newSchema in functions

I exported a database called oldDatabase using pg_dump in directory format. This database contains a schema, tables and functions owned by oldRole. These functions contain SQL statements like ...
1
vote
1answer
190 views

How to query large sets of data using server resources to the max

I am planning of retrieving large amounts of data (100+ million rows) from SQL Server to Azure Data Lake Store and I need it to be done in shortest time possible. I would like to ensure that when I ...
0
votes
1answer
287 views

Import database from MSSQL export dump on Ubuntu localhost

I have an export file from an online database server that I need to use to generate the database locally on my system. I'm running MSSQL 2017 on Ubuntu 16.04. The export file has Program(application/...
0
votes
2answers
54 views

Filesystem copying inactive DBs on active MySQL server

My question is related to this question and answer: Copying datadir directory enough for backing up a database with InnoDB tables? I want to use a filesystem copy on a whole DB without shutting down ...
1
vote
1answer
469 views

Pass .csv file as parameter file for expdp Oracle 11.2.0.4.0

Can we use .csv file as parameter file for expdp ? Ex: expdp scott/xxx@dev parameter=table_full.csv Thanks
0
votes
1answer
525 views

ORA-31114: XDB configuration has been deleted or is corrupted

ORA-31114: XDB configuration has been deleted or is corrupted How to recreate the XDB configuration? Do I need to remove the existing component first? By the way I can't run UTLRP scritp for the ...
1
vote
2answers
467 views

Partial copy of huge database

I have started working in a project which has a big database, around 300GB. For security reasons I can not access database from my local web app. So I need to copy last 100,000 from each table. To ...
0
votes
3answers
179 views

Error while exporting data to flat file from database using sqlplus in UNIX

Trying to export data from a table to .dat file in a unix script using the SPOOL command. However on execution only ~17k data is exported to file out of 91K data with an error in end of the file : ...
2
votes
1answer
391 views

Storing the last updated date of a row in a different table

I need to do a daily export of all of the new rows or updated rows from a legacy database into the new database. The problem I am running into is that not all of the tables on the legacy database ...
2
votes
1answer
6k views

Oracle 12c export and import schema with different data tablespace and index tablespace

Suppose that I exported the schema objects from my Oracle 12c database using the original export utility as below: exp userid=<export_schema_name>/<export_schema_password>@<db_string&...
1
vote
1answer
77 views

MS Access: Issue with Autonumbers in the export

I have a question that might be trivial to solve, but I have spent some time on it and didn't manage to solve it. I am working on a database in MS Access, in which I keep track of the specifications ...
2
votes
5answers
9k views

SQL Server: SSMS “Save Results As” creates CSV that Excel mangles

Using the Save Results As option, shown below. CSV looks good! But when Excel opens/imports it: Long strings are mangled as numbers (if the data is largely numeric) Dates are not detected properly ...
0
votes
2answers
647 views

How to export data from a SQL Server database with hundreds of tables and timestamp columns?

I have a SQL Server database with hundreds of tables and they all have timestamp columns. I don't have access to backups or the server's file system. To use the export data wizard, I have to go into ...
1
vote
1answer
454 views

What is the 131072 in the call to lo_open()

ByteA to BLOB conversions typically make a call to lo_open(), CREATE OR REPLACE FUNCTION make_lo(bytea) RETURNS oid AS $$ DECLARE loid oid; fd integer; bytes integer; BEGIN loid := lo_creat(-...
0
votes
2answers
365 views

update table with data from other table in remote oracle db

I have table X from remote Oracle DB A, and table Y in local Oracle DB B. The data in Y is a partial copy of the data in X (X has some columns that aren't needed in Y; the columns I need in Y have ...
0
votes
2answers
10k views

Oracle: spool data to different files depending on where condition (loop)

I am trying to get my way around something like this declare filename varchar2(100); begin for condition in (select fieldN from mytable) loop filename := 'data_for_value'||condition.fieldN||'...