Asp.net programming we consider all important topic for knowledge about controls,web Services, JSON, Ajax, database, and interview related Question. In this Asp.net and sql server tutorial blog we give many examples of jquery as like How Play YouTube Video in Your Asp.net Website by URL, How to Play YouTube Videos in Asp.net by using Jquery , Jquery Change div background on mouseover in asp.net , JQuery UI Datepicker (Calendar) etc.

Friday, November 7, 2014

SQL Server bulk copy and bulk import and export techniques

SQL bulk copy and bulk import and export techniques:



In this post we give a list of techniques for Import and export data in sql server.

Many times we want to export or import large amounts of data into or out of a database.
Then all operations that are use for this are called bulk export and import operations.

Bulk copy and bulk import and export techniques in Sql:

SQL Server gives many tools to perform bulk import and export and bulk copy operations these are:-
Bulk Import and Export of Data (SQL Server) techniques.

  • The bcp utility: A command-line utility (Bcp.exe) that bulk exports and bulk imports data and generates format files.
  • The OPENROWSET (BULK) function,
  • The SQL Server Import and Export Wizard,
  • The BULK INSERT statement: A Transact-SQL statement that imports data directly from a data file into a database table or nonpartitioned view.
  • The SELECT INTO statement.




Note :- SQL Server bulk-import operations do not support importing data from comma-separated value (CSV) files.



Sql Server Related Other Post:

No comments:

Post a Comment