Importing and exporting data from a database is an essential skill to master for DBAs, but this needs some planning beforehand because it can alter your database. Discuss what planning might be needed prior to exporting / importing data via the Import and Export Wizard, such as backups that should be run prior to execution of an import operation or any other tasks.

 

Importing and exporting is the most needed skills for

database engineers and developers as the data handling is

the most important skill required to solve a problem or to

do processing on data . So there is need of proper planning

as data should not be lost at any point of time and data should not

be altered as well. So we have to handle this carefully.

Plannings done before -:

1) There should be a separate copy of data which is not altered

so if modified data is faulty we can use our previous data and this

is done using master slave architecture as slaves are modified and master

remain intact and updated at end after testing. So, older data is retained

at master at any point of time.

2) Data should be given in compressed form if exported so less data charges

will be there in between.

3) Data should be protected and encrypted as no one other can use use it

so it should have to be secure as well.

4) Code modification should be trusted and authenticated parties otherwise data

will destroy or misused by non authenticated source so handle that.

5) Backup of data and consistency of data that data should be retained at any

point of time no data losses it should be available at every point of time.

So these are the skills most web developers , Database engineers , Data architect

and most of the other engineers use to securely import and export safe transfer

of data . This is basic principal on which basically whole internet is dependent.

By the mechanism of data exchange only we are using the internet so it should be

safe