Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

What's the Simple way of importing into Database?

user-image
Question ajoutée par Babatunde Adenrele , MIS/IS Support Executive , Globacom Telecoms -Victoria Island
Date de publication: 2013/06/13
Saad Mohamed Naguib Saad
par Saad Mohamed Naguib Saad , Software Applications Developer , Amreya Factory For Feed

IN SQL server :By using SQL server integration service and create a package to import data from any database engine to SQL server

Sajjad Ahmad
par Sajjad Ahmad , Deputy Director (IT) , PITC

if the same db is on both side, then simple exp/imp is the easiest way. if two different dbs then if the exported file is a txt file then it can easily be iported in the target db, if not a txt file then there r severl other ways..

NASIR KHAN
par NASIR KHAN , Database Administrator , K-Electric

The simple way to import into database is the "IMP" import database command execute from command prompt.

dina fathy
par dina fathy , oracle Database Administrator , Information Center

Oracle Data Pump is the replacement for the original Export and Import utilities.
Available starting in Oracle Database10g and consider as simple way

ahmed sayyed
par ahmed sayyed , Management Information Systems Department Manager- IT , Alexandria Petroleum Maintenance Co. (Petromaint)

copy and paste

alireza hoseini
par alireza hoseini , PHP & Python back-end developer , Fax.ir

PHPMyAdmin is a simple way to import data from a MySQL database into your DBs.

Saad Nayef
par Saad Nayef , IT Project Manager - Database Administrator , National Bureau of Statistics

First, you have to mention what database (and what version) you are using Second, you have to specify what do you want to import (format of data you want to import).
Saad,

Waqas Ahmed
par Waqas Ahmed , Database & Middleware Admin , NAMAA TECH.

Dear User, By using conventional import we will use the following command: imp system/password file=(file_name).dmp log=(file_name).log full=y statistics=none

Abdul Ghaffar
par Abdul Ghaffar , Manager Databases & Infrastructure , DPL Limited

Universally, the most simplest way to import data into a database is using a text / csv file as source and destination as of your DBMS.
This method is valid for all modern DBMS

Ubaidullah Nubar
par Ubaidullah Nubar , Information Systems Consultant , Al-Ebdaa for Development

1) What database are you importing into ?

2) What is the format of the data that you want to import?

More Questions Like This