Skip to content

Instantly share code, notes, and snippets.

@tariqmislam

tariqmislam/how-to

Created March 20, 2012 21:01
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tariqmislam/2141262 to your computer and use it in GitHub Desktop.
Save tariqmislam/2141262 to your computer and use it in GitHub Desktop.
Download ZIP
BCP with SQL Server 2012 and Windows 7 64-bit
Raw
how-to
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