Questions tagged [import]

The import of data is the automated or semi-automated input of data sets between different software applications.

Filter by
Sorted by
Tagged with
0
votes
1answer
33 views

Building and analyzing trends in a database [closed]

I am quite new to working with databases but have spent a few hours reading about XML and trying to understand the use of CML for building databases and find myself completely at a loss. Here is what ...
1
vote
2answers
797 views

Dumping and importing with backslash

Background I have a MySQL database, from which I run mysqldump for backups. In this database, I have some fields that will contain some backslashes, and when dumping this, it will contain something ...
1
vote
4answers
3k views

Bulk table creation and import of data

I have a around 400 CSV files which have been exported from an old Paradox database, with each CSV representing a table within the old database. Each CSV has a different number of columns and ...
3
votes
3answers
17k views

Easiest way to import access db (.accdb) into SQL Server 2016?

I have a .accfb file from an access 2016 database and am trying to import this database into a SQL Server 2016 developer edition instance. While I found posts online discussing using import/export ...
3
votes
2answers
6k views

Not displaying special characters imported from a file

The scenario is a SQL Server instance, a database which is data fed using BULK INSERT operations mainly, and some of the texts inserted contain special characters like ñ because I am working in a ...
2
votes
1answer
361 views

Postgres 9.6: tune for one time import

I'm using pgloader to perform a one-time migration from MySQL to Postgres. For that purpose, I want to temporarily configure Postgres specifically for that workload. reduce WAL as much as possible: ...
5
votes
3answers
1k views

Azure SQL Warehouse - Data Ingestion - Convert a huge fixed width (with commas) file to delimited

I am not even sure if I am framing this question right, but I will try - I have a bunch of huge text files generated from an Oracle export on a Linux system. Each file is about 30 GB in size, and I ...
2
votes
1answer
4k views

Import .frm and .ibd files into a new instance of MySQL

I have the .frm and .ibd files from an old, non-working MySQL server (on Windows). I took out the hard drive and was able to get the data directory copied to my machine. How would I get them into ...
1
vote
1answer
113 views

Can I lookup my Primary Key in SQL Server from Excel Spreadsheet?

Disclaimer: I'm a database novice teaching myself for a research project. Background: I am querying an electronic medical record (EMR) system for information pertinent to my project and I do not ...
4
votes
1answer
1k views

No data in Azure SQL after importing bacpac file

I've created a bacpac file of my database for transfer to Azure. The file is uploaded and imported successfully but there's no data in the imported database. What did I do wrong? There don't seem to ...
0
votes
1answer
2k views

Field Terminator Problem in Format Files

I have a data file in txt format and I used to load it with Bulk Insert in the following command: Bulk insert [table1] FROM 'data.txt' WITH ( FIELDTERMINATOR ='|', ROWTERMINATOR ='...
8
votes
3answers
13k views

Import in postgres json data in a csv file

I'm trying to import into postgres a csv file containing the data for a table. One of the column of the table has jsonb type. One line of my csv file contains something like 1,{"a":"b"} Suppose the ...
0
votes
2answers
2k views

Commands creating format files to import txt file into sql server

I'm trying to create a format file using bcp utility following the instructions on this page: Using a format file to bulk import data https://technet.microsoft.com/en-us/library/ms178129(v=sql.105)....
-1
votes
1answer
45 views

MsSql secondary database synchronisation to Online Master MsSql database [closed]

I have application that is talking to a Offline (local) database that is a replica of a (Online in-house db). The app is using this (local) database to keep new data that is being inputed when the ...
-1
votes
1answer
31 views

Unable to import the excel data for only 'User' table creation in SQL Server 2012

During import of excel data into SQL Server 2012 Express for User only i am getting the error. The Error is as mention below Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'User'...
0
votes
1answer
46 views

I want to import tables from one sql server to another server using SSIS with loop

I want to import table via SSIS, This package will execute like first it'll import first 10 tables once its imported then it'll start to import 10-20 tables, like a loop. Can anyone explain me how ...
1
vote
0answers
125 views

Postgres 9.4 importing csv file causes connection abort

I have very simple database which i would like to import data from a csv file, so far i tested with a file with a few rows, and it worked. So tried to upload the real data to the database, which ...
1
vote
1answer
6k views

Error code 1290 and inability to import data on table

I am running a 5.7.16 version of MySQL on my Windows 8 operating system. I am facing troubles when trying to load datas into a table. I tried with the script LOAD DATA INFILE 'C:\Users\xxx\Dropbox\...
3
votes
1answer
70 views

How to create a custom view (using lookup) from aggregated data

I have data imported into a postgresql database: groups (data import) id | csv_user_ids 1 | 1,2,3 2 | 4,5,6 3 | 3,1,4 ... and a lookup table for user names: users (lookup) id | name 1 | one 2 ...
0
votes
1answer
10k views

import .db files/tables into sqlite database

I have a zip file containing several .db files (~ 30 files). Each of these .db files correspond to a table, e.g., the "fuel_transaction.db" file contains a "fuel_transaction" table, "...
1
vote
1answer
15 views

Is there a way to input field information by cvs file?

I am importing a new database. I am asked to input field information in MS Access manually. Is there a simpler way? For example, import a cvs version field information into the following
1
vote
1answer
39 views

MS Access fail to recognize correct field width

I am trying to import a very large text file (200 fields +) into MS Access. The text file is not comma separated. I am not sure if it can be called fixed length, since each field has it own length. ...
-1
votes
2answers
312 views

Are there any other ways to import server data to MS SQL server? [closed]

My Task: move data (1.on remote server 2.text file) to MS SQL server. Create a table for hosting the data. My Solution: Download data from remote server to local machine Import to MS Access Use ...
0
votes
2answers
2k views

mysql says “too many open files” when importing large *.sql file

I have a large database dump I want to import with MariaDB / MySQL. mysql -u DBUSER DBNAME < DUMP.sql The process goes on for a while, and then I get this: ERROR 23 (HY000) at line 11304: Out of ...
6
votes
1answer
11k views

MySQL settings useful to speed up a mysqldump import

Recently I had to import a 7 Gb MySQL dump file to a MySQL 5.6 server. The import took around 7 hours on a mono-core CPU with 1 Gb of RAM. Someone else tested the import on a MySQL server which has, ...
5
votes
3answers
1k views

Export to format compatible with SQL Server

I need to provide data in a format that could be imported into a Microsoft SQL Server database; however, I do not have Windows or access to a SQL Server instance. The data is currently in several CSV ...
1
vote
0answers
50 views

Better mode in export datapump

I'm a complete newbie in oracle databases. I'm just curious on what mode is better when you want to migrate your database to another host by using data pumping. Lately, I'm having a problem on import ...
1
vote
2answers
1k views

Does export in schema mode also includes tablespaces?

I am executing an expdp command in schema mode. I'm just curious if it also exports tablespaces. I'm total newbie in oracle databases. What if I want to export schemas and tablespaces? What mode do I ...
1
vote
0answers
246 views

How to import sqlite from plain text dump?

This excellent XKCD article about color-poll data at the very end mentions: If you have ideas and want to analyze these results further, I’ve posted the raw data as an SQLite dump here (84 MB .tar....
0
votes
1answer
780 views

Oracle export not importing correctly (missing more than half of the tables)

I have an export of a 75gb database broken up into 2gb files. When I run imp utility after creating the tablespaces and users to match the original database, I don't think all tables are created. I ...
4
votes
1answer
2k views

Bringing web service data into SQL server

I need to retrieve a data set daily from a hosted Web service. I can retrieve the XML "column names" in an SSIS package. But I need to retrieve all the data in the data set in csv format or bring ...
4
votes
2answers
1k views

Why MySQL Database is Bigger After Dump/Import?

I have 2 VPS and plan to migrate the DB from first to second. The original DB is taking around 15GB of storage and I manage to dump out a 7GB SQL. However, when I imported the SQL to second VPS, it ...
3
votes
2answers
2k views

mysql export with partial data

How do I export the structure of a mysql database I have, keeping the structure for all the tables but only exporting the data for some of the tables? After exporting how do I import it into another ...
-2
votes
1answer
94 views

Post DB users into replica users the Synonyms still point to Source DB users

I have exported users HR,Fin AND imported into new users HR1,FIN1 in the same DB. The expdb is used for this purpose.The synonyms still point to the source users (HR,FIN) Example : Synonym def in ...
1
vote
1answer
1k views

Informix Specific Table export

I'm busy trying to migrate data between informix databases using the dbexport and dbimport utilities. I know that in PostgreSQL I can use the following pg_dump –a –t table database > /destination/...
2
votes
2answers
5k views

SQL Server 2012 import/export wizard not showing at all

So I have access of two databases that are stored in Azure, and using SQL Server 2012 to access them. All I need to do is copy a table from one db and duplicate and create it in another. I keep ...
0
votes
1answer
550 views

How can I (re-)create the Entity Relationship Diagram (ERD) of an existing hidden Oracle database?

More precisely, I wan't to re-create the database model / schematics / the Entity Relationship Diagram (ERD) showing all the links between the tables of this existing hidden Oracle Database. In my ...
2
votes
2answers
3k views

No tables found after running Expdp and Impdp in Oracle 12c

I am trying to export a schema which only contains one table with one row on it. It has a table called "product" and resides in a tablespace called "tbs_data". Here's the expdp command I ran which ...
1
vote
0answers
46 views

SOLVED - How to import a text file with “,” value to Mysql

I have data in a text file that have value like this : _______________________________________ |id|name_item |value| _______________________________________ | 1|Luas ...
1
vote
0answers
305 views

Modification of the sql loader control file

I am working on a script which uses Oracle SQL *Loader to load data into a table. However, anywhere I search about the control file of an sql loader I am seeing only statements like: "load data into ...
1
vote
1answer
3k views

MongoDB/Mongochef: import from JSON changed dates to string

I have a huge JSON file (about 5 GB) with several fields in all rows. this is what one document looks like: { "_id" : ObjectId("55f0105346c5110dfc6b8760"), "patient" : "198", "concept" ...
1
vote
0answers
152 views

Mysql InnoDB relations vanish when exporting/importing to online database

My issue is the following : I have a local database running on EasyPhp server : WEB server : Apache/2.4.7 (Win32) PHP/5.5.8 DB server : 5.6.15-log - MySQL Community Server (GPL) PHPMYADMIN : version ...
1
vote
0answers
271 views

Is there a faster way of importing 8m+ rows?

I'm creating a new feature on my website in order to provide player locations (my website is for a multiplayer gaming service), and am going to use a simple IP lookup in my database. For this I need ...
4
votes
1answer
3k views

INSERT INTO inserting multiple times

I have a table that contains all information about user called 'DataSource'. I have columns called 'First Name', 'Surname', and 'Address' (there's more but as an example). I have two tables called '...
2
votes
2answers
1k views

Importing from CSV file, is crashing mysql server

I am facing a problem with importing large data into single mysql table. Basically I assume it is happening because limited machine resources but, I am having troubles to proof it. this is my CSV ...
1
vote
1answer
212 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
0answers
2k 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
2k 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 ...
0
votes
1answer
68 views

Is there an equivalent of 'FORMATFILE' in MySQL?

I'm looking for a way to import data from a text file to a MySQL database, the text file used to be imported in a SQL SERVER db via BCP and FORMATFILEs option for exemple : BULK INSERT [MyTable] ...
47
votes
2answers
24k 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 2 3
4
5
11