Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What's the Simple way of importing into Database?

user-image
Question added by Babatunde Adenrele , MIS/IS Support Executive , Globacom Telecoms -Victoria Island
Date Posted: 2013/06/13
Saad Mohamed Naguib Saad
by 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
by 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
by 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
by 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
by ahmed sayyed , Management Information Systems Department Manager- IT , Alexandria Petroleum Maintenance Co. (Petromaint)

copy and paste

alireza hoseini
by 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
by 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
by 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
by 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
by 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