|
Define Bulk Copying and Distributed Queries of SQL Server.Bulk copying:
- It is used to transfer large amount of data.
- It allows for the efficient transfer of large amounts of data.
- It transfers data into or out of one table at a time.
Distributed Queries:
- Distributed queries in SQL server are used to reference heterogeneous data source such as a Microsoft Access database or Oracle database.
- It allows to reference data in an OLEDB data source.
- It can be another instance of SQL server.
- It exports data from a SQL Server database to an OLEDB data source.
- It imports data from an OLEDB data source into SQL server.
|
