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

learn more… | top users | synonyms

0
votes
0answers
31 views

How to copy architecture of an existing database to a new database in SQL Server

I'm using Microsoft SQL Server 2012 (SP1) - 11.0.3153.0 (X64) Express Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1) (Hypervisor) and I need to copy the database ...
1
vote
3answers
921 views

How i can export just structure of mysql database

I use ubuntu 14.10 Phpmyadmin I have ''big'' mysql database, 900mb, I need just structure of this database, how i can export just database structure/empty database without remove data or download ...
1
vote
1answer
4k 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
299 views

Mysqldump from production database, every morning

Our Db is about 2GB in size. We run a scheduled job at 3am every morning, when traffic is pretty low, where we export the whole db and sftp it off site. Is it bad practice to do this on a production ...
0
votes
0answers
189 views

Import and export Excel data into a SQL server database

I have SQL Server 2008 64 bit Developer’s Edition installed on my machine, and Microsoft Office 2013 Professional 64bit. I have been trying to import and export some Excel data from an Excel sheet ...
3
votes
1answer
14k views

Difference between database dump (export) and database backup?

What is the drawback using only EXP or EXPDP command for a database dump (and considering it as a backup) instead of taking backups using BACKUP DATABASE command (via RMAN)? What is a difference ...
7
votes
2answers
5k 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 ...
1
vote
2answers
483 views

Export structure and data without a wizard [duplicate]

Using Sql Server 2008 R2 (but I could possibly upgrade if required). I want to generate scripts for the database structure as well as the data for a schema. The Generate Scripts wizard does what I ...
0
votes
1answer
125 views

Extract certain rows from table and import

I have a requirement to export / extract certain rows (matching some query) of some tables from one oracle database and import those rows in the respective tables of other database. both source and ...
0
votes
1answer
1k views

Export data tables from SQLPlus [duplicate]

Is there any way to export data from an Oracle SQLPlus console, without using the exp or expdp commands? I don't have sysdba privileges. I'm not a real Oracle guru so I'm using Navicat to export but ...
10
votes
5answers
28k 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
1answer
144 views

How to export mysql databases with different ENGINE?

I'm setting up MySQL Cluster. As it uses ENGINE=NDBCLUSTER, how could I export my databases from MySQL Server specifying the ENGINE? Is there a way to do this? All my tables are MYISAM
12
votes
3answers
4k 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 ...
0
votes
3answers
9k 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
3answers
3k views

Copy data from SQL Server 2000 to SQL Server 2014 Express

I need to copy only data (not tables) from a SQL Server 2000 database to a SQL 2014 Express database. I tried to do this using DTS but it loses keys and indices. Backup (2000) and restore (to 2014) ...
0
votes
1answer
138 views

Does PostgreSQL have a built in option for converting multi-line text to single line?

Does PostgreSQL have a built in option for converting multi-line text to single line? I need to store multiline text as Name=Value pairs, basically line .ini files, but need to convert Value back to ...
1
vote
2answers
436 views

How can I generate an .mdf file containing a subset of my tables and rows?

I need to provide some data to an organisation (lets call them DataCo) that we're working with. Since we're both SQL server shops, my counterpart at DataCo requested an .mdf file. However, our ...
0
votes
1answer
589 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: ...
0
votes
2answers
379 views

CSV data export to SQL Database with double quote problems [closed]

I am trying to import data from falt files (.CSV) into SQL table. I am able to import them no problem but the data is coming with double quotes. What is the best way of resolving this problem? ...
0
votes
1answer
2k views

Exporting scheduled jobs in Oracle

This is probably very simple but i already exported all but the scheduled jobs i created to subsequent schemas. How can I create a sql script of the scheduled jobs I created in Oracle? I know in SQL ...
1
vote
1answer
7k views

Oracle 10g dump file into Oracle 11g database

I went through this link for my answer to the same question. I was not sure if i could continue in the same link, so created a new question. Oracle 10g dump file push into Oracle 11g database Sorry ...
1
vote
1answer
892 views

Exporting data from Microsoft Access table file subsets to plain text

I have a problem in exporting data from Microsoft Access. I have an Access file made of several rows and columns, like this: Every row contains a subset of data, tha could be observed by clicking ...
0
votes
1answer
105 views

Select IDs according to CSV file

I have a CSV file with IDs of rows. I want to use that to make a SELECT statement selecting the IDs within that CSV file. There is 1 million rows and I want to select about 95,000 of those. I want ...
0
votes
3answers
2k views

What is the EXPORT privilege on ORACLE

I have created a user say A. I want to export some of my schemas using A user. For example, I have B and C users. I want to export B schemas using A user. Which grant do I have to use? I am using ...
0
votes
0answers
193 views

Export sql server table connections schema

i am using RazorSQL to connect to a Microsoft SQL Server database. I am looking for a way to visualize the tables connections schema. Do you have any idea how I can export such a view?
7
votes
1answer
56k views

How to transfer data using expdp and impdp commands?

I'm Oracle noob, and my intention is to transfer all data and metadata from one schema to another schema within an Oracle database. I'm planning to use datapump expdp and impdp commands. I have ...
0
votes
0answers
69 views

How best to export from Oracle Ent Ed (EE) to Oracle Express Edition (XE)?

I am aware that Oracle Ent Ed (EE) has more functionality than Oracle Express Ed (XE). But I would like to do a FULL export from EE to XE. Is this even possible? The only solution I can assume will ...
1
vote
1answer
272 views

Export synonyms content to tables

I have a distant database to replicate having huge data but I have access only to synonyms and I would like to use Oracle export/import tool to import these data into tables of local database. What ...
0
votes
2answers
3k views

Split a very large SQL table to multiple smaller tables [closed]

Is it possible to search a column within a table for a numerical value range of 1-2000 and then copy each full row into a different table? By doing so technically splitting the table into smaller ...
4
votes
1answer
15k views

Create dump file using Oracle SQL Developer

I think I'm missing a simple point, but I couldn't find a way to use Oracle export (exp/expdp) and Oracle import (ipm/impdp) with Oracle SQL Developer (version 1.5.5)? Is there a way for it? If ...
4
votes
3answers
5k 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
2answers
2k views

EXP-00085 warnings while doing full backup

During a full export of my Oracle 10.2.0.2 database, I encounter the following warnings [...] . exporting post-schema procedural objects and actions EXP-00008: ORACLE error 6502 encountered ...
6
votes
2answers
6k 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 ...
5
votes
2answers
10k views

Oracle - Automate Export/Unload of Data

Oracle SQL Developer has an option to export the contents of a query result to various formats (CSV/fixed width/Excel/XML). Is there any way to automate it? If not, what free tools are available ...
0
votes
1answer
577 views

How to export oracle 11g database partially

I have a huge oracle test database whose size is more than 100 GB. I want to export only 1% of all the data and import it into my local database to have a local replica of that application. Is it ...
0
votes
0answers
841 views

Export to csv using db2 v10 for z/os

in db2-luw, I can create a csv using the export command. However, running the same command in z/os results in: SQL1325N The remote database environment does not support the command or one of ...
1
vote
3answers
5k views

how to Export a document contain tables name, columns names and column description from SQL Server 2008?

I created a db in sql server 2008 and I wrote for some columns description to describe them, What I want now is to find a way to export these tables design including the description for each column ...
3
votes
2answers
2k views

Oracle imp crashes without error

I have Oracle 10g XE database locally. I export schema with something like exp %USER%/%PASSWD%@XE statistics=NONE owner=%USER% file=dump.dmp Exp is 10.2.0.1.0 version - so is the DB. Than I take ...
0
votes
2answers
192 views

I can't import my database into mysql

I have a website based on drupal and I tried to export its database via both Backup wizard and phpmyadmin. the database was exported but I can't import it on my localhost database.this the error ...
0
votes
1answer
121 views

How can I normalize this database?

I've got legacy ecommerce database, which is awfully designed and I need to move all products from it to new solution. But I stuck with how product properties stored. So it basically has tens of ...
1
vote
0answers
173 views

ORA-01115 error with data pump export [closed]

I exported DMP file but the end of the logfile displays this message: 0 rows ORA-31694: master table "CREG_OP"."EXPDP_TAMIN" failed to load/unload ORA-02354: error in exporting/importing data ...
1
vote
1answer
2k views

Creating a USER using the imp command [duplicate]

I was told I can use exp to export a certain USER, then DROP the user and with the imp command I can recreate that USER with all of its tables. Is it true? How do I do it? I already have an ADMIN ...
1
vote
1answer
221 views

Using a PostgreSQL tablespace from two different servers

I have a PostgreSQL database living on an external hard disk (RAID0 via Thunderbolt). So far I accessed it from a PostgreSQL server running on my MacBook Pro. As my work on this database is getting ...
3
votes
2answers
2k views

Export as csv or xsl file from SQL Server 2008 express R2

I am basically LAMP developer got some assignment where SQL Server is required. I have installed SQL Server 2008 R2 Express and imported backup file in it. Now, I want to export user table in excel ...
1
vote
1answer
192 views

Is there a way to export Oracle's UNDO?

I tried exp utility to dump all database. Looks like this exports only the last version of data skipping undo log. Using flashback queries I see: 01466. 00000 - "unable to read data - table ...
1
vote
1answer
475 views

SQL Import/Export defaults to byte stream on export

So, I've done some research and I can't seem to figure this out. I'm not sure if it's some setting that I'm missing or what. For the basic info, running SQL2012, 64 bit, all that good stuff. I ...
1
vote
1answer
972 views

MySQL - Export two columns from large table without causing a lock

I am a sysadmin who doesn't do a ton of dba stuff. For a project, I have access to a production server--which I am not the sysadmin for--with an enormous 40,000,000 row >10 GB MySQL InnoDB table. I ...
2
votes
1answer
2k views

Using Workbench to export. Views no longer work

I'm using Workbench 5.2 from my production DB machine (Ubuntu Linux). I've been trying to export. First try.. I had the entire schema selected including all tables and views in the right hand ...
0
votes
1answer
1k views

Exporting and importing a database

I have setup an Oracle 11g Database and have a question about exporting and importing a database. I am using Enterprise Manager and have browsed to the following: Data Movement->Export to Export ...