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

learn more… | top users | synonyms (1)

4
votes
3answers
13k views

How to export an image column to files in SQL Server?

I will migrate from a database. There is one column of type image that I would like to export to binary files on the file system. One file for each record. How can I do this with SQL Server?
1
vote
2answers
13k views

exporting oracle tables on command line as sql files

I use exp and expdp to export database tables on command line but it generates binary .dmp files. I want to export/import tables as .sql* files on command line like pl/sql developer app can do. Is ...
1
vote
1answer
4k views

How to run DB2 export command in shell

I am trying to run the following DB2 command through the Python pyodbc module: DB2 export to C:\file.ixf of ixf select * from emp_hc I am successfully connected to the DSN using the pyodbc module in ...
0
votes
1answer
1k views

How to export an Access database and import to MySQL?

I am working on a Java project that sources data from an MS Access database, but I want to use MySQL because I have found it to be very easy to manage. How can I export an Access database that has ...
0
votes
1answer
2k views

Expdp with metadata_only gives way too large dump. Why?

There is an oracle 11g schema with amount of data about 700 Gb. There are tables/indexes only in that schema, no procedures/packages. Doing expdp on that schema expdp schemas=TheSchema directory=dir ...
0
votes
1answer
2k views

Export, based on query, into INSERT text file

I need to export some data into a file. The data are selected with a query that will often be made of multiple joins. I want the import operation to be as easy as possible. I was thinking of building ...
2
votes
0answers
30 views

export data from postgresql

I have some text like xml -code in a field of table. I want to export the data from my field into file without any changes. I've tried to use a lot of variants but all of them changes the text. The ...
5
votes
4answers
3k views

Exporting/Importing a large MySQL database without mysqldump

I'm attempting to export about 150GB of data from a database with hundreds of tables, and have found mysqldump to be very buggy. After running a simple --all-databases dump succeeds, but the import ...
0
votes
1answer
899 views

Running Oracle Export Utility within a Shell script

I have wasted a lot of time on this. Any ideas of what I am doing wrong here? Script in bash #!/usr/bin/bash . . . /export/home/app/oracle/product/10.2.0/bin/exp $uname/$passw \ FILE="$...
1
vote
0answers
25 views

MySQL dump only has SET commands, no data

I've done an export of a Wordpress database. The MySQL file that was exported only contains the Host, Database name, server version and SET commands. Pastebin: http://pastebin.com/pFgdPDRa Another ...
1
vote
1answer
17 views

Run lo_export as client through psycopg2

Python 2.7 psycopg2 When I run: cur.execute("SELECT lo_export(123456, '/tmp/test.jpg')") Produces error - need to be superuser to do this. This makes sense as it is running a server side ...
30
votes
8answers
119k views

MySQL DB import/export command line in Windows

How to export / import a database in MySQL through the command line? MySQL system configuration, WampServer server installed. OS: Windows The advice for my local host, not an live hosting...
1
vote
1answer
40 views

I'm seeing inconsisntecies in table data after exporting from one server and importing to another, why is this?

I'm quite new to the process of importing/exporting databases. I'm using Maria DB, and HeidiSQL to run queries, etc. I exported an entire database from our dev server, and loaded it into our live ...
1
vote
2answers
99 views

Create a monthly job to export from SQL Server 2014 to Excel

There are a lot of questions here asking "how to export from SQL Server to Excel", but every answer, together with stuff I know, is giving me problems (64bit system here). We have a developer that ...
1
vote
0answers
41 views

How to export views and import it in other DB?

I am trying to export the database and everything is fine but I am not able to export the VIEWS. Is it possible to export the views from sql queries and import it?
3
votes
1answer
74 views

Importing and exporting data from a database to another using SyBase is taking a long time

In order to update a database(Sybase Adaptive Server Anywhere 8) I'm taking all the data from one database on clients computer and using SELECT * FROM tabelName OUTPUT TO 'C:\path' FORMAT ASCII ...
1
vote
1answer
58 views

Copying Partitioned table data to another table on different SQL Server

We have a partition table on Production environment with 2338117620 rows and 206 partitions. Now we have to copy only last 2 year data in Test environment. But the problem is that , Import Export ...
0
votes
2answers
82 views

How to export own objects using expdp without special privileges?

As per this post on Oracle forums expdp can be used to export your own schema without any special privileges: It all depends on what you want that user to be able to export/import. If all that ...
2
votes
5answers
48k views

Oracle Export using EXPDP gives ORA-06512 SYS.UTL_FILE error on Windows 7

I am using Oracle 11g and want to export a table using below statement C:\>expdp SYS/sys@MYDATABASE DIRECTORY = Mydir DUMPFILE = Customer.dmp LOGFILE = Customer.log TABLES = PERSON.CUSTOMER ...
7
votes
1answer
588 views

Why is a .bacpac file so small compared to a .bak file of the same database?

I've been doing backups of my SQL Server 2014 Express databases for import to other servers and noticed a difference in file size between .bacpac and .bak. Why is a .bacpac file so small compared to ...
1
vote
0answers
37 views

How can I create a Web-service to share data from SQL Server?

Our organization has an externally hosted website that displays data from a monitoring system. Data is currently provided by FTPing csv files. The data is stored in a SQL Server Database. The ...
3
votes
0answers
82 views

File size when extracting from SQL Server to CSV

I am attempting to extract a table to CSV using BCP from SQL Server 2014 and the size of the file once the data is extracted is actually larger than the size of the database itself. One thing to note ...
0
votes
0answers
424 views

SQL server export wizard gets stuck

I'm using the SQL server export wizard to export data to text flat file or Access file. The wizard gets stuck at 92960/92945 rows of about 153000 thousands. Nothing happens. Only after hours it ...
1
vote
1answer
101 views

Can we export data from PostgreSQL to xlsx file?

I want to export the result of a query to xlsx file format. I know we can export it to csv file, but I want to export it to xlsx file. Like the following: copy(select name_related from ...
3
votes
1answer
1k views

How to restrict MySQL user to not import and export database

I have created a read only MySQL user but this user have an option to export the database through phpmyadmin. How can I disable the options Export and Import?
0
votes
0answers
21 views

What is Fastest way to export 400m rows DB2 table

I want to export table data in a file to load it in memcached. This table has 400m rows. Right now I am running db2 export command and it takes 1hr 10min. This table has 8 columns, 1 int, 2 timestamp ...
1
vote
0answers
54 views

ERROR 1 (HY000): Can't create/write to file (Errcode: 13 - Permission denied)

I've been struggling for a couple of days with this now and have been trying to use this thread amongst other google searches to resolve it but can't seem to get it to work. When I run this SELECT ...
0
votes
1answer
31 views

How to download or place a copy of original tables with locked-permissions via remote connection in Oracle SQL Developer?

N00b question here: I'm still learning Oracle SQL Developer. Although I understand how to query databases/tables remotely, I'm unable to manipulate the data due to permissions-basically I would like ...
1
vote
1answer
62 views

SQL Server 2014 Not recognizing 64 bit drivers for Office

I have a SQL Server 2014 virtual machine. It is a 64 bit version of SQL Server or a 64 bit Windows Server. The SQL Server software was installed before I was hired by the Sysadmin. He choose to have ...
0
votes
0answers
13 views

exporting selective data to excel in php

I have a table called tbl_order which has three columns: credit_card debit_card selected_payment_method i want to export to excel value of column 1 or 2 only depending upon the selected payment ...
2
votes
4answers
5k views

How can I export just the structure of a MySQL database?

I use Ubuntu 14.10 and PhpMyAdmin. I have a 'big' MySQL database, the size is 900MB. I need just the structure of this database, to use it on my local machine. How can I export the structure only?
1
vote
2answers
2k views

Change permissions of postgres copy to exported file

I have asked this question on SO but perhaps that was the wrong location. Apologies for double posting but the question may have a better audience here. The original question is: http://stackoverflow....
3
votes
1answer
342 views

Apply settings to multiple output columns in SSIS flat file source

Is there an easier way to apply property settings to multiple output columns in a SSIS flat file source, rather than manually applying to each output column? (SQL Server 2014.) I am attempting to ...
-1
votes
1answer
145 views

How to fix invalid length in all tables of MS SQL Server 2008 (R2) database

Task is simple: I want to export all SQL Server database tables using SQL Server Management Studio 2008 R2 to MySQL (or any other format that MySQL can take, e.g Excel, CSV). I have tried the ...
7
votes
2answers
10k views

Export Postgres table as json

Is there a way to export postgres table data as json to a file? I need the output to be line by line, like: {'id':1,'name':'David'} {'id':2,'name':'James'} ... EDIT: postgres version: 9.3.4
0
votes
1answer
71 views

SQL Anywhere 12 - exporting data to Excel

Do I need to install MS Office Excel on machine where is SQL Anywhere 12 server for below code to work? Or SA 12 or Windows have MS Excel Driver builtin? SELECT * FROM SalesOrders; OUTPUT USING '...
4
votes
3answers
7k views

How to compare two SQL Server 2008 configurations

I have a problem with my application that works on my dev SQL Server 2008 (Developer Edition), but not on a production SQL Server 2008. Is there an easy way to export the settings from the production ...
5
votes
1answer
582 views

mongoexport not exporting all possible data

I have a collection with documents similar to the following: { _id: 'p_123456', id: 123456, kind: 'person' data: [...] } id field can contain either positive or negative integers. This ...
6
votes
3answers
13k views

How to export all the security-related information from a SQL Server database

As you guys probably know, SQL Server does not provide an out-of-the-box solution to export all the security related statements that are declared for each element in the database (both at the database ...
0
votes
2answers
3k views

SQL Server to Oracle export using Microsoft OLEDB Provider for Oracle

I am trying to Export Data from SQL Server to Oracle using the "Microsoft OLEDB Provider for Oracle". I am using "Export Data..." option from Task menu. I get to connect to the source database (SQL ...
0
votes
1answer
101 views

Migrating data from Firebird to CSV on OSX

I have a .gdb Firebird database file that I would like to partially transform to .csv. From the CLI tool, I'm able to do the following: CONNECT "/Users/jpmonette/Desktop/file.gdb"; OUTPUT /Users/...
3
votes
2answers
757 views

Best way to export excel table into MySQL db

I'm trying to export an Excel table which contains about 400 records of HR stuff (e.g. name, surname, age, job, ecc.) into a MySQL db. I'm actually using mysql for excel and started reading a db book,...
0
votes
1answer
44 views

How to import a single table in Windows environment

I am running Windows 7 with xampp. I can easily import a database with the following command: mysql -u user -p database < backup.sql The problem is that I have a database around 8.5 GB, which ...
16
votes
4answers
6k views

Is it possible to backup and restore part of a database in sql-server?

We have a sql-server 2005 database that we regularly transfer from our client site to ours. This takes a long time because we don't have a direct connection and have to transfer the file over their ...
4
votes
0answers
92 views

Nothing to do, no schemas or tables selected on export

I'm using MySql Workbench 6.3.6, on Windows 10, which has all updates. I have previously been able to get a data dump from this database. Now I can't get any from any of the schemas I have open in ...
1
vote
2answers
678 views

Oracle DB export, possible charset conversion if NLS_LANG not set

I need to export an Oracle database from one server and import it on another server. But I am getting the following information message at the beginning: Connected to: Oracle Database 10g Release ...
0
votes
1answer
31 views

Set Default Maximum Rows for Export

I am more of a Vertica database user than admin, so I'm not even sure if what I'm asking is absurd, but here goes nothing... Could I, as an admin, put default restrictions on the number of rows that ...
1
vote
1answer
487 views

Powershell Restore Azure SQL Database to local with Restore-Database

I have written a powershell script that uses Start-AzureSqlDatabaseExport & Get-AzureStorageBlob to export my Azure DB to a bacpac and download it locally, the next step is to restore the bacpac ...
2
votes
1answer
125 views

In SQL Server, are there any other options of data Import and Export

I've been working with SQL Server since SQL Server 7. So I know about BCP, Bulk insert, openrowset and SSIS. My question is a simple one: Do you know of any other ways to Import/Export data using ...
0
votes
1answer
21 views

Export Wizard never starts Pre-executing

I'm using the Import/Export Wizard in SSMS 2012 to store some data into a flat file, as I have to move these data from one SQL server to another. I've tried with direct connecting to the server ...