Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [export]

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

0
votes
1answer
29 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
79 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 ...
-1
votes
0answers
12 views

How to Select and Filter Child Array

I have a data as below Data { "Status" : "Pending", "ComEnv" : [ "prod" ], "ComTenant" : [ "us" ], } when i try to export the it into csv, it will show ["prod"]...
2
votes
1answer
32 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
21 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
14 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
100 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 ...
0
votes
1answer
90 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
78 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
64 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 ...
0
votes
1answer
126 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
58 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
82 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 ...
0
votes
0answers
31 views

Import MySQL Dump into Database Table with Another Table Name [duplicate]

I have exported the selected records from a table using mysqldump using --no-create-info and --where options. But the dump contains a statement like INSERT INTO `table_name` VALUES I cannot ...
1
vote
0answers
44 views

exporting live data from mongodb [closed]

I am storing measures of 350 photovoltaik modules in mongodb. The following data represent the actual current of the modules. This is how I did it: { "_id" : ISODate("2018-05-20T00:00:00.000+0000"), ...
7
votes
2answers
528 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
0answers
29 views

Data Types :Exporting/Importing between SQL and Excel (Using Wizard).

I have some data tables in Excel that I am trying to export into SQL Server. and I wonder what types are needed when creating or selecting AFAIK, the data types in Excel are CDLNT : Currency, ...
0
votes
1answer
38 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
30 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
67 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
166 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
0answers
37 views

“fast” way to export oracle database remotely

this is first time i use Oracle database, and i want to export database in my vps remotely to my local computer, i just try to export with Navicat, but it seem's take too long for large data (4M Rows),...
0
votes
2answers
47 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
216 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
227 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
144 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
96 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
225 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
3k 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
38 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 ...
1
vote
3answers
3k 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
326 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
187 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
269 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
5k 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||'...
6
votes
2answers
838 views

Very large SQL Server 2016 result sets (over 75 GB) to a CSV file?

What is the best way to get very large SQL Server 2016 result sets (over 75 GB) to a CSV file? The engineers need this output to look for correlations. The bcp route for a 73.5 GB file filled up ...
2
votes
1answer
2k views

Import Oracle .dmp with error 1659, unable to allocate MINEXTENTS beyond 3 in tablespace SYSTEM

I'm trying to importing an Oracle DUMP file (v10.2) into Oracle Express 11.2.0.2.0. I was getting some schema errors and resoled them by following other posts here. Now I'm getting this error and I'm ...
0
votes
0answers
787 views

Exporting Bulk or Large data set in SQL Developer

I am using SQL Developer, Oracle 11g client I need to export result of below query into a csv or excel file, issues is when I execute the query and do right click export, then if I select as excel, ...
-1
votes
2answers
2k views

ORA-01555:Snapshot too old error during execution of expdp command [duplicate]

After performing expdp command in production database (Oracle 11g - linux): expdp abc/123 DIRECTORY=data_pump DUMPFILE=SA10_%u.dmp LOGFILE=SA10.log TABLES="abc"."/1FE/019" PARALLEL=4 CONTENT=...
1
vote
0answers
31 views

Copy Table Data [closed]

In Oracle, What is the efficient way of copying data from one table to another within the same database? Columns are the same in both the tables. Im used to to Data pump so it'll help dozens if you ...
0
votes
2answers
288 views

MySQL Import & Replace via CSV

I have a MySQL database table named items with 10,000+ records. Of these records, I would like to export only records where item_isbn IS NULL. SELECT * FROM Items WHERE item_isbn IS NULL produces a ...
0
votes
1answer
270 views

Any program / command to see a preview of .sql dump file?

If I have [multiple] .sql dump files, is there a command or tool that would allow me to see a preview of the file ? e.g: db-preview backup.sql tables (40) ---------- - users (1200) -...
6
votes
1answer
859 views

Postgres 9.6 export the database structure as pdf [closed]

Is there any tool/software the can export all the tables structure (column names , its datatype ) in the database as a pdf/excel/word. additional diagram export will be added advantage.
0
votes
3answers
420 views

How to export some rows of multiple tables linked between them according to one column value?

I'm not sure my question is clear so let's me rephrase it. I have three tables organized like that: I want to make a dump of these tables but I'm not interested by all the rows, I just want those who ...
1
vote
1answer
61 views

Objective, SQL Server 2005 and exporting data using **bcp**

I was tasked w/ getting data out of an obsolete document management system running on top of an instance of MS SQL Server. Trying to export > 30000 documents through the app is not an option, as it ...
5
votes
1answer
702 views

Informix DB export to Microsoft SQL Server 2016

I have an Informix Database and a Microsoft SQL Server 2016. My task is to dump the whole Informix Database and export it to the Microsoft SQL Server Database. I installed the Informix SDK 4.5. I ...
2
votes
0answers
229 views

Export SQL View to CSV flat file. SSIS job stuck

I created a database view with the desired data and format. I used SQL Server Import and Export wizard to create a flat file export procedure and saved it to SSIS package. The data exports correctly ...
-3
votes
1answer
85 views

How to view and export database content? [closed]

I'm trying to view the actual entries, not the backend identifiers. > db.<collection>.find({"_id": "486b4ca55b144b119f4551417c5798c8"}).pretty() { "_id" : "...
1
vote
1answer
637 views

Microsoft Access database to FileMaker Pro

I have all my customer details in Microsoft Access. I want to transfer all this data to FileMaker Pro. I hope there is a way to do this. If so please help me.
4
votes
1answer
2k views

How to export database structure from Firebird?

I'm doing replication and I need to export db structure from one Firebird db (dialect 3) into another. I've seen a couple tools like IBPump and FBExport, however all I can find is how to export all ...