From the course: SQL Server 2014 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Exporting data

Exporting data - SQL Server Tutorial

From the course: SQL Server 2014 Essential Training

Start my 1-month free trial

Exporting data

“

- In this section, we're gonna look at exporting data from SQL Server 2014. Here in Management Studio, I've opened up the list of tables in AdventureWorks2014. I'd like to export data from the HumanResources.Department table; however, if I right-click on that, I don't see an option for Export Data. In order to get to the Export Wizard, I'm gonna need to launch it from the database level, not the table level. I'll go up to AdventureWorks2014. I'll right-click on the database, and under Task, one of the tasks will be Export Data. This brings up the SQL Server Import and Export Wizard. It's one wizard whether you're importing data or exporting data; you get the same wizard. I'll click Next on the first page. Then I'm presented with a dialogue to choose the data source. The source will be my local SQL Server, so in the drop down I'll scroll all the way to the bottom and choose SQL Server Native Client and it'll ask me my server name, how I would like to authenticate, and what database I…

Contents