bcpsql server
I am working with a client who needs to do a data import to a remote SQL Server (2008) instance. The machine that the import will be done from cannot have SQL Server installed on it. Can the BCP.exe utility run without a SQL Server install?
Thanks for any help.
You would need to add the folder containing bcp.exe to the environment variables search path.
You will be using the servername (DNS) or the IP address of the server. But if you have a named instance (as opposed to the default instance), your servername will be followed by \instanceName.
So, in other words unless you changed any SQL Server Express install defaults, you should connect to the server like this:
yourServerName\sqlexpress
SQL Server Express has a default named instance name of SQLEXPRESS. Also, since SQL Server Express is a named instance, you'll need to ensure that your SQL Server Browser service is running.
Another one. If you are trying to connect to SQL Server from a separate machine, you'll need to ensure that the TCP/IP protocol is enabled for SQL Server.
The above two points can be verified and configured in SQL Server Configuration Manager.
Best Answer
You have to use one of the SQL Server distributable packages to stay within licensing terms. These are not full installs.
The one you want is "Microsoft® SQL Server® 2008 R2 Command Line Utilities"
Note: copying bcp.exe by itself will not work