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

learn more… | top users | synonyms

0
votes
3answers
4k views

Export Postgres table on remote server to CSV file on local machine?

I have access to DB on remote server where I can do only select command, So, I can execute: COPY products TO '/tmp/products.csv' DELIMITER ','; But on that server I don't have permission to ...
0
votes
4answers
311 views

which one is the fastest way of moving database form local to live server in sql server

I am using SQL Server 2008, I have big database almost 500 MB of data there. Now I wanted to upload or deploy this DB to Live server. Currently I am generating script and then uploading script to live ...
2
votes
1answer
1k views

Better query to select multiple columns into a single output column?

I have the following query that sort of works, but I find it to be kludgy and inefficient. Is there a better way to write this query? I know this is a bit of an odd query, else I would probably have ...
0
votes
0answers
277 views

Understanding the time difference between data grid initial display and export/full display using Toad for Oracle

I am trying to run a query on a local Oracle DB and output the results to a .CSV file. The query runs in a decent amount of time (usually less than 5 minutes), but returns tens of thousands (possibly ...
3
votes
2answers
686 views

Import and Export database in Mongo just like MySQL

I am newbie to the Mongo.Before this I have worked only with MySQL.In MySQL we can import and export database easily.I want to know is there any option available in Mongo to import and export database ...
4
votes
1answer
804 views

Is there a way to export an Oracle database to a CREATE DATABASE command?

I have an existing Oracle 11 instance, I want to export the database (which was created via DBCA) to an equivalent "CREATE DATABASE" command, handling the character set, etc. I'd also like to get a ...
0
votes
1answer
265 views

SQL Server 2000 export database to csv

I need to move an SQL Server 2000 database to MySQL. I'm running into several complications. I'm no expert on SQL Server. To get going I'd like to have a csv-dump of structure and data. First issue, ...
9
votes
4answers
12k views

What is the fastest way to export a table to a text file

I will have a SQL Server 2012 database and a table with 3 million rows and maybe 50 columns. What will be the fastest way for an unattended background .net process (maybe issues some SQL or Powershell ...
1
vote
0answers
330 views

How to dump an advanced revelation database?

Retail store I work with has an ancient inventory/accounting/receiving system that is based off Advanced Revelation. They run the DOS and Windows clients. I'd like to get a dump of their data to ...
1
vote
1answer
42 views

I have deleted a table, by exporting over the same table, and selecting the 'drop destination table before insertion'

I understand this might not be the best forum, but I could sure use some help right about now. If not, please suggest a forum where I can. I was trying to backup a table, by using the export wizard. ...
1
vote
1answer
216 views

Imports & exports under storage constraints and preallocations

I have a 5GB oracle database that I want to export and then import on my own local database. Easy right? The point is, I use oracle XE 10g which allows me to use up to 4GB. I then decided to make the ...
0
votes
1answer
2k views

Import .pde file on PL/SQL Developer

How can I import my .pde file which I already exported from another database by PL/SQL Developer?
1
vote
1answer
236 views

PG_bulkload utility postgresql need help

i am using COPY command to export the data to the out file with changes made to the data before export using option ST_asBinary() using command COPY ( SELECT st_asBinary(geom) FROM n_america ) TO ...
3
votes
1answer
3k views

Export table without BLOB column

I have a big table with BLOB objects and some references from other tables to this one. I prepare dev and test schema for my app by making expdp (data pump) from production, then anonymizing data on ...
2
votes
1answer
794 views

How do I export data from Oracle 11.1 to 10.1?

I have a 11.1 oracle server and I need to export a dump file for a client who has a 10.1 server. While reading the documentation, I figured out I needed the 10.1 Export Utility. I searched the ...
2
votes
2answers
107 views

Resume download on DB exporting

I am attempting to export a large database and import it to another PC over the Internet. Sometimes my Internet connection fails resulting in a database export error, causing me to have to restart ...
0
votes
1answer
457 views

It is possible to export a MySQL database without BLOB fields?

If I have a MySQL database with some tables where one have a BLOB column, It is possible to export the whole database excluding the BLOB fields? If not, could you suggest a solution to work-around it? ...
2
votes
1answer
397 views

Database schema size result differs from file size when exported

I used this query to find out my database size SELECT table_schema "Data Base Name", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY ...
0
votes
0answers
459 views

Problem in exporting users from oracle database. (Oracle 10g express edition)

I am trying to export the user from database, but its showing export done in we8mswin1252 character set and al16utf16 nchar character set But if i am trying to export entire database then its ...
6
votes
2answers
4k views

How to extract Procedure, Function, etc. Source Code from an Oracle Export

I have generated an EXPDAT.DMP file of an Oracle database with the command: exp userid=usr/pass@db owner=own rows=n compress=n I then ran the following command to generate a file containing the ...
4
votes
4answers
1k views

Exporting\Importing a large MySQL data 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 ...
4
votes
1answer
918 views

Comments in EXPDB parameter file

Is there a way to put comments in a data pump export parameter file?
0
votes
2answers
2k views

oracle 10g xe to 11g xe upgrade

The oracle 10g DB that is being currently used has exceeded the limit of 4GB. For the application to continue the db needs to be upgraded to 11g. But the upgrade doc requires a data pump export to be ...
2
votes
1answer
1k views

Oracle, error while exporting schema

I'm using a command: $ exp userid=apex_public_user/apex_public_user OWNER=apex_public_user DIRECT=Y CONSISTENT=Y FILE=/home/oracle/apex_public_user.dmp and getting following output: Export: ...
0
votes
1answer
897 views

export SQL statements from Oracle 11g database via command line

I'd like to export an Oracle 11g database as a series of SQL statements via the command line. I'd like the functionality of SQL Developer (the process described here ...
2
votes
1answer
2k views

How to export mysql database based on a where condition

I need to export the data and structure of a table but the data must have a specific condition (WHERE status=0 and id>20). How to export mysql database based on a where condition from phpMyAdmin or ...
0
votes
1answer
173 views

Sensible data management tool for importing and exporting of large data files

I am looking for some sensible suggestions on data management tools for large data files. I have been experimenting aith excel and access only to find that access has limitations on import files size ...
3
votes
3answers
2k views

Can Oracle SQL developer export data as a set of Update commands?

Oracle SQL developer gives us the option of exporting data. But it only gives us the option to export as a set of Insert statements. I have two databases with a mirrored table. One of them has some ...
2
votes
1answer
1k views

export data from oracle 10g

I installed Oracle 11g on my computer. When I export data from Oracle 10g, I get the following error code. I have translated the error in parenthesis. EXP-00008: 遇到 ORACLE 错误 904 (encouter oracle ...
2
votes
2answers
848 views

Oracle 10g XE GUI

I've designed a database on Oracle 10g xe (Windows Platform) and I want to export the tables I created in a sql file. I've googled all night and didn't find anything. I also tried to install a Windows ...
1
vote
1answer
496 views

How to setup daily SQL server export to csv text file?

We are exporting 100,000+ rows from a SQL Server 2005 DB to a text file. We have a web script setup to read all rows and then write the text file and it takes over 5 minutes to complete that script. ...
4
votes
2answers
3k views

Export Oracle tables based on owner + all users from database

I would like to export all user and roles objects from Oracle 10g database to another. I googled it but I cannot find out how to do it. First I use this command: exp system/root@[DB_Name] ...
2
votes
1answer
2k views

Eliminate database fragmentation (export, drop and re-import tables)

I have one datafile that is highly fragmented. Its size is 10GB now and real size that is used is 2.5GB,so 7.5 is free. I decided to export data, drop that datafile, recreate it and import data. ...
1
vote
2answers
765 views

Access exporting to CSV is weirdly slow

I have searched but could not find anything similar. If I just run the query, I can get the result pretty quickly (~5 mins); but after I saved the query to export as CSV, the exporting part is ...
2
votes
3answers
410 views

What's the easiest way to re-format CSV exports from MySQL into Excel/ flat-file fields?

I've just had some database backup problems on a website I run containing some important lead data. Unfortunately, I've now lost one of the key MySQL tables, which means my data has lost its ...
7
votes
1answer
5k views

Does mysqldump export indices, by default?

I played around a little with mysqldump and I was wondering, if it does export indices (FULLTEXT, INDEX,...) by default. I read up on it and I found this option: --disable-keys, -K which suggests, ...
6
votes
2answers
2k 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
2answers
6k views

How to export a single huge table from SQL Server?

I'm given the task to export the content of a huge table from a production database and to import the data into a database at a remote location. The Table has about 45,000,000 rows. using about 4 GB ...
5
votes
3answers
883 views

How can a datapump export have its resource usage limited on windows?

Doing an export of a number of users causes high CPU and I/O usage. I can mitigate the effects of the CPU usage using Resource Manager and setting the export session to a low priority group, but how ...
8
votes
1answer
420 views

How can a datapump export have its resource usage limited on linux?

Doing an export of a number of users causes high CPU and I/O usage. I can mitigate the effects of the CPU usage using Resource Manager and setting the export session to a low priority group, but how ...