Skip to content

Commit e7b64f0

Browse files
committed
Consolidating files
1 parent 91dc307 commit e7b64f0

6 files changed

Lines changed: 34 additions & 220 deletions

docs/linux/TOC.md

Lines changed: 0 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -20,7 +20,6 @@
2020
## [Use SSMS to Manage](sql-server-linux-manage-ssms.md)
2121
## [Use PowerShell to Manage](sql-server-linux-manage-powershell.md)
2222
## [Configure with mssql-conf](sql-server-linux-configure-mssql-conf.md)
23-
## [Monitor with dmvtool](sql-server-linux-dmv-tool.md)
2423
# [Configure business continuity](sql-server-linux-backup-overview.md)
2524
## [Backup](sql-server-linux-backup-and-restore-database.md)
2625
## [Restore](sql-server-linux-restore-database.md)

docs/linux/sql-server-linux-develop-overview.md

Lines changed: 0 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -58,4 +58,3 @@ See the topics below for more information:
5858
- [bcp](sql-server-linux-migrate-bcp.md)
5959
- [sqlpackage](sql-server-linux-migrate-sqlpackage.md)
6060
- [mssql-conf](sql-server-linux-configure-mssql-conf.md)
61-
- [dmvtool](sql-server-linux-dmv-tool.md)

docs/linux/sql-server-linux-dmv-tool.md

Lines changed: 0 additions & 146 deletions
This file was deleted.

docs/linux/sql-server-linux-import-data-with-bcp.md

Lines changed: 0 additions & 59 deletions
This file was deleted.

docs/linux/sql-server-linux-management-overview.md

Lines changed: 1 addition & 12 deletions
Original file line numberDiff line numberDiff line change
@@ -6,7 +6,7 @@ description: This topic provides links to common management tasks and tools for
66
author: rothja
77
ms.author: jroth
88
manager: jhubbard
9-
ms.date: 11/08/2016
9+
ms.date: 11/12/2016
1010
ms.topic: article
1111
ms.prod: sql-linux
1212
ms.technology: database-engine
@@ -28,17 +28,6 @@ ms.assetid: 6bd8eb0b-593d-467e-87ea-ab1c4dbcd1ea
2828

2929
The topics in this section provide an overview of some common management tasks and associated tools for managing SQL Server vNext CTP1 on Linux. Some of these are introductions to techniques that are common to all platforms. Other scenarios are specific to SQL Server on Linux.
3030

31-
## Management tasks
32-
The following management tasks are covered in this section.
33-
34-
| Task | How-to |
35-
|------|------|
36-
| Configure | [Configure SQL Server on Linux with mssql-conf](sql-server-linux-configure-mssql-conf.md) |
37-
| Monitor | [Monitor SQL Server on Linux with dmvtool](sql-server-linux-dmv-tool.md) |
38-
| Export and import | [Export and import databases with SqlPackage](sql-server-linux-export-import-with-sqlpackage.md) |
39-
| Bulk import | [Use bcp to bulk import data to SQL Server on Linux](sql-server-linux-import-data-with-bcp.md) |
40-
| Troubleshoot | [Troubleshoot SQL Server on Linux](sql-server-linux-troubleshooting-guide.md) |
41-
4231
## Next steps
4332
In addition to these management tutorials, also review the following topics:
4433

docs/linux/sql-server-linux-migrate-bcp.md

Lines changed: 33 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -25,5 +25,37 @@ ms.assetid: 7b93d0d7-7946-4b78-b33a-57d6307cdfa9
2525
---
2626
# Bulk copy with bcp to SQL Server on Linux
2727

28-
(sql-server-linux-migrate-bcp.md)
28+
TODO: provide an example of using BCP on SQL Server on Linux. Point to the BCP documentation as well. Focus on migrte scenario.
29+
30+
Optional: consider whether this discussion of BULK INSERT is applicable in this topic (from evaluation guide) and whether the same workaround for line ending is necessary with BCP.
31+
32+
## Bulk Insert
33+
34+
The Bulk Insert feature allows you to import records into a
35+
table or view from a local data file.
36+
37+
To test this feature, create a new directory /var/opt/mssql/Samples and a new file SampleLocations.txt with the following content:
38+
39+
1,Subassembly
40+
2,Storage
41+
3,Assembly
42+
4,Final Assembly
43+
5,Paint Shop
44+
45+
Linux and Windows handle newlines differently and SQL Server on Linux only recognizes newline characters in the Windows format this preview release.  If you authored the SampleLocations.txt file in Linux, download the dos2unix package and use it to create a version of the file that will be interpreted correctly by SQL Server. 
46+
47+
$ apt-get install dos2unix
48+
49+
$ unix2dos –n SampleLocations.txt WinSampleLocations.txt
50+
51+
Create a new table in tempdb for Location data:
52+
53+
use tempdb
54+
55+
CREATE TABLE Locations ( LocationID int, Location varchar(255) )
56+
57+
Use Bulk Insert to populate the Locations table with data from your text file:
58+
59+
BULK INSERT Locations FROM 'C:\Samples\WinSampleLocations.txt' WITH (FIELDTERMINATOR = ',')
60+
2961

0 commit comments

Comments
 (0)