From the course: SQL Server 2014 Essential Training

Unlock the full course today

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

Importing and exporting Unicode data

Importing and exporting Unicode data - SQL Server Tutorial

From the course: SQL Server 2014 Essential Training

Start my 1-month free trial

Importing and exporting Unicode data

- Now I'd like to look at working with some data that's a little more complicated than what we worked with previously. And actually, when we go to export this data, the first time we're going to have an error and then I'll show you how to fix that error. So, I'm gonna right click on AdventureWorks2014, and off of Tasks, I'm gonna go to Export Data. On the first page, I'll click Next. The Data Source will be the local SQL server. So, SQL Server Native Client 11. Select the appropriate server name and the appropriate database. And click Next. The destination will again be a flat file, and I'm gonna put it in the same directory, the MS SQL data directory. And I'm gonna call this PersonExport. We will be exporting from the Person table. I'll click next, I'll go with the default of copy data from one or more tables. And Next, and then the source table will be Person.Person. I'll hit Next, I'll go with the default of run immediately, and I'll hit Next. And then Finish. And the first few…

Contents