The import of data is the automated or semi-automated input of data sets between different software applications.
2
votes
1answer
178 views
Can I monitor the progress of importing a large .sql file in sqlite3 using zenity --progress?
I'm trying to monitor the progress of a sqlite3 command importing a large .sql file into a database using zenity --progress.
I've tried the following which will import the file, however progress is ...
1
vote
1answer
40 views
SQL Server Import Job Removed Data After Job Failed
I have a SQL Server Job set up to import data from a table to a table on another server, using the Import/Export data wizard.
In one instance, the job failed (with, I believe a SQL connection issue), ...
0
votes
1answer
54 views
Why would SequelPro only import 23k rows out of 130k?
I use SequelPro for mysql on a Mac OS X -- and I used the import function to upload a 130k .csv file to my database. Everything seems to work fine, then I get the message File Read Error: An error ...
0
votes
1answer
98 views
Oracle schema import is not importing all the tables present in the schema dump file
I have exported an existing oracle schema from another machine and then imported it in my local machine. Import was successful, but some tables which are present in the export dump file are not ...
0
votes
1answer
179 views
Import batches of rows from Excel in parallel
We receive an Excel file weekly currently containing about 250k rows. The file grows by about 300 rows each week.
In SSIS I've hooked up an Excel source to an OLE DB destination to import the file ...
3
votes
0answers
105 views
Database describing databases and references to tables
Context
The company I work for makes a number of different softwares each with its own database. As they're all about related things (accounting) a good amount of data is theoretically the same among ...
2
votes
0answers
2k views
Oracle 11g .DMP viewer
I have received a dump of a Oracle 11.2.0.2.0 db, which I'd like to export to some readable format like plain text, CSV, excel...
Is that possible in some sort of a simple way? I've found a few ...
1
vote
0answers
527 views
ORA-01460 during Data Pump Import
While migrating data from Oracle 11.2.0.1 RAC to Oracle 11.2.0.3 RAC using Data Pump, the import failed with ORA-01460:
ORA-39097: Data Pump job encountered unexpected error -12801
ORA-39065: ...
1
vote
0answers
830 views
Import/export wizard code page error
Using the import/export wizard I end up with an annoying problem:
Error 0xc02020f4: Data Flow Task 1: The column "pinNumber" cannot be processed because more than one code page (874 and 1252) are ...
0
votes
0answers
51 views
How to clone a database from one environment to a database on another environment?
OS: RHEL
DB: Oracle 11g version 11.1.0.7.0
I am trying to clone a database on one environment (environment A) to another database on a separate environment (Environment B). Environment B's database ...
0
votes
0answers
58 views
Writing with multiple psql processes to database seems to damage data
I have a couple terabytes of CSV data that I am trying to import into a PostgreSQL 8.4 database (on a RedHat 6.2 server), whose data directory is initialized on a multipath hardware RAID. There are ...
0
votes
0answers
142 views
MySQL import file with no column delimiter
Is there a way to use the mysqlimport command on a file that has no column delimiters?
I would like to import the ctl file used with the sqlloader for Oracle
0
votes
0answers
797 views
How to bulk import multiple CSV files into master tables with variable field names?
As a learning exercise, I am trying to map several data files into a few master tables. Right now, I have a file hierarchy as follows:
<Root>
- Client 1
- CustomerInfo.csv
- ...
