SQL Server Functions Question:
Do you know exporting and importing utility?
Answer:
BCP Utility
The Bulk Copy is a command utility that transfer SQL data to or from a data file.
This utility mostly used to transfer huge data to SQL server from other database.
With this, data is first exported from source file to a data file and then imported from the data file to SQL server table.
It is also used to transfer data from SQL server table to a data file.
You can use ‘Bulk Insert’ statement to transfer data from data file to SQL server table.
DTS Packages
It is a set of tools that allows you extract, transform, and consolidate data from disparate sources into single or multiple destinations. You can create custom data movement solution using DTS object model.
DTS packages can provide following services:
It can import or export data to or from text file or OLE DB data source.
It supports data transformation using DTS transformation which means that data can be operated using one or more functions before hitting the destination.
You can transfer database objects along with data using DTS package.
DTS package also notifies if package steps succeed or failed by sending mails to source and destination.
The Bulk Copy is a command utility that transfer SQL data to or from a data file.
This utility mostly used to transfer huge data to SQL server from other database.
With this, data is first exported from source file to a data file and then imported from the data file to SQL server table.
It is also used to transfer data from SQL server table to a data file.
You can use ‘Bulk Insert’ statement to transfer data from data file to SQL server table.
DTS Packages
It is a set of tools that allows you extract, transform, and consolidate data from disparate sources into single or multiple destinations. You can create custom data movement solution using DTS object model.
DTS packages can provide following services:
It can import or export data to or from text file or OLE DB data source.
It supports data transformation using DTS transformation which means that data can be operated using one or more functions before hitting the destination.
You can transfer database objects along with data using DTS package.
DTS package also notifies if package steps succeed or failed by sending mails to source and destination.
| Previous Question | Next Question |
| What do you know about Normalization and De- Normalization? | Explain how DTS is used to extract, transform and consolidate data? |