Bài giảng Cơ sở dữ liệu nâng cao - Chapter 4: Transferring data and using service broker. Nội dung chính trong chương này gồm có: Introduction, performing a bulk load, performing a bulk insert task, importing bulk XML data, overview of SQL server integration services, using the import/export wizard, service broker. | CHAPTER 4 Transferring Data and using Service Broker Agenda Introduction Performing a Bulk Load Performing a Bulk Insert task Importing Bulk XML data Overview of SQL Server Integration Services Using the Import/Export Wizard Service Broker Introduction A common task when working with a database is importing data from other sources. One of the most frequently used methods of transferring data. There are different methods you can use to efficiently import files into SQL Server bulk copy program (bcp) the BULK INSERT Transact-SQL command the OPENROWSET Transact-SQL function the SQL Server Integration Services (SSIS) Import/Export Wizard Performing bcp utility Because bcp is a program, you do not execute it from within a query window or batch but rather from the command line. It is an external program, which means it runs outside of the SQL Server process bcp to bulk copy data either into or out of SQL Server. Performing bcp utility Two limitations of bcp: bcp has limited data-transformation capabilities. If the data that you are loading needs to go through complex transforms or validations, bcp is not the correct tool to use. bcp has limited error handling capabilities. bcp might know that an error occurred while loading a given row, but it has limited reaction options Performing bcp utility bcp {dbtable | query} {in | out | queryout | format} datafile [option] Option Description -S Instance name -T -T Indicates that you wish BCP to connect using a trusted connection -U login name when not using –T -P the password associated with the –U login name -c Use a character data file type -w Use a Unicode data file type -t Field terminator -r Row terminator Performing bcp utility bcp Command-Line Syntax bcp {dbtable | query} {in | out | queryout | format} datafile [option,n] Example about the simplest command bcp FileImportDBExam out "c:\FileImportPractice\" -T –w bcp FileImportDBExam in "c:\FileImportPractice\" -T -w BULK INSERT . | CHAPTER 4 Transferring Data and using Service Broker Agenda Introduction Performing a Bulk Load Performing a Bulk Insert task Importing Bulk XML data Overview of SQL Server Integration Services Using the Import/Export Wizard Service Broker Introduction A common task when working with a database is importing data from other sources. One of the most frequently used methods of transferring data. There are different methods you can use to efficiently import files into SQL Server bulk copy program (bcp) the BULK INSERT Transact-SQL command the OPENROWSET Transact-SQL function the SQL Server Integration Services (SSIS) Import/Export Wizard Performing bcp utility Because bcp is a program, you do not execute it from within a query window or batch but rather from the command line. It is an external program, which means it runs outside of the SQL Server process bcp to bulk copy data either into or out of SQL Server. Performing bcp utility Two limitations of bcp: bcp has limited .
