Created
March 20, 2012 21:01
-
-
Save tariqmislam/2141262 to your computer and use it in GitHub Desktop.
BCP with SQL Server 2012 and Windows 7 64-bit
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Interestingly enough, the BCP utility requires that you provide the server name. | |
So for example if you are doing everything locally, the syntax would be: | |
bcp Theater.gems.ALLERGIES in ALLERGIES.dat -T -n -S localhost\SQLExpress | |
This assumes that your instance name is 'SQLExpress' of course. Also be sure that when configuring your instance, you specify windows authentication as the login method. | |
For remote connections however, remember to create another user through the SQL Authentication Login option. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment