|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
|
|
|
||||||
| ms.sqlserver.setup Questions about SQL Server. |
 |
|
|
LinkBack | Outils de la discussion |
23/10/2006, 22h56
|
#1 |
Messages: n/a
Hébergeur: |
BCP for SQL2005
Hi,
I know that BCP.EXE is part of the client tools for SQL2005. Does it also come as part of a standalone like say SQLCMD.EXE as a standalone from the feature Pack? We are looking to install the Native client and SQLCMD and BCP without the other executables. Thanks Chris |
|
|
24/10/2006, 18h29
|
#2 |
|
Messages: n/a
Hébergeur: |
RE: BCP for SQL2005
Hi Chris
I am not sure about the licencing issue with installing the Feature pack version on it's own! AFAIK BCP.EXE is not available as a standalone install, although there are example applications using the Bulk Copy API which you could use to write your own application. John "Chris Wood" wrote: > Hi, > > I know that BCP.EXE is part of the client tools for SQL2005. Does it also > come as part of a standalone like say SQLCMD.EXE as a standalone from the > feature Pack? We are looking to install the Native client and SQLCMD and BCP > without the other executables. > > Thanks > > Chris > > > |
|
|
|
24/10/2006, 18h42
|
#3 |
|
Messages: n/a
Hébergeur: |
Re: BCP for SQL2005
That's what I thought John.
We have some non MS SQL servers that don't really need the full Client Tools, just the Native Client, SQLCMD and BCP. I could find the first 2 and had hoped that BCP might be available too but if not then we should just be able to copy an SQL2005 BCP.EXE onto the server. Thanks Chris "John Bell" <jbellnewsposts@hotmail.com> wrote in message news:B7EDF30E-63A6-4757-BA3C-A6A8D53600AF@microsoft.com... > Hi Chris > > I am not sure about the licencing issue with installing the Feature pack > version on it's own! AFAIK BCP.EXE is not available as a standalone > install, > although there are example applications using the Bulk Copy API which you > could use to write your own application. > > John > > "Chris Wood" wrote: > >> Hi, >> >> I know that BCP.EXE is part of the client tools for SQL2005. Does it also >> come as part of a standalone like say SQLCMD.EXE as a standalone from the >> feature Pack? We are looking to install the Native client and SQLCMD and >> BCP >> without the other executables. >> >> Thanks >> >> Chris >> >> >> |
|
|
|
24/10/2006, 18h58
|
#4 |
|
Messages: n/a
Hébergeur: |
Re: BCP for SQL2005
Hi Chris
You may want to try installing from SQL Express the tools only which will not install Management studio or Profiler, but I don't know if BCP is included. John "Chris Wood" wrote: > That's what I thought John. > > We have some non MS SQL servers that don't really need the full Client > Tools, just the Native Client, SQLCMD and BCP. I could find the first 2 and > had hoped that BCP might be available too but if not then we should just be > able to copy an SQL2005 BCP.EXE onto the server. > > Thanks > > Chris > > "John Bell" <jbellnewsposts@hotmail.com> wrote in message > news:B7EDF30E-63A6-4757-BA3C-A6A8D53600AF@microsoft.com... > > Hi Chris > > > > I am not sure about the licencing issue with installing the Feature pack > > version on it's own! AFAIK BCP.EXE is not available as a standalone > > install, > > although there are example applications using the Bulk Copy API which you > > could use to write your own application. > > > > John > > > > "Chris Wood" wrote: > > > >> Hi, > >> > >> I know that BCP.EXE is part of the client tools for SQL2005. Does it also > >> come as part of a standalone like say SQLCMD.EXE as a standalone from the > >> feature Pack? We are looking to install the Native client and SQLCMD and > >> BCP > >> without the other executables. > >> > >> Thanks > >> > >> Chris > >> > >> > >> > > > |
|
|
|
24/10/2006, 19h01
|
#5 |
|
Messages: n/a
Hébergeur: |
Re: BCP for SQL2005
That's something worth trying.
Thanks Chris "John Bell" <jbellnewsposts@hotmail.com> wrote in message news:E207B799-76CE-4FCB-AA42-B9B89CF0F768@microsoft.com... > Hi Chris > > You may want to try installing from SQL Express the tools only which will > not install Management studio or Profiler, but I don't know if BCP is > included. > > John > > "Chris Wood" wrote: > >> That's what I thought John. >> >> We have some non MS SQL servers that don't really need the full Client >> Tools, just the Native Client, SQLCMD and BCP. I could find the first 2 >> and >> had hoped that BCP might be available too but if not then we should just >> be >> able to copy an SQL2005 BCP.EXE onto the server. >> >> Thanks >> >> Chris >> >> "John Bell" <jbellnewsposts@hotmail.com> wrote in message >> news:B7EDF30E-63A6-4757-BA3C-A6A8D53600AF@microsoft.com... >> > Hi Chris >> > >> > I am not sure about the licencing issue with installing the Feature >> > pack >> > version on it's own! AFAIK BCP.EXE is not available as a standalone >> > install, >> > although there are example applications using the Bulk Copy API which >> > you >> > could use to write your own application. >> > >> > John >> > >> > "Chris Wood" wrote: >> > >> >> Hi, >> >> >> >> I know that BCP.EXE is part of the client tools for SQL2005. Does it >> >> also >> >> come as part of a standalone like say SQLCMD.EXE as a standalone from >> >> the >> >> feature Pack? We are looking to install the Native client and SQLCMD >> >> and >> >> BCP >> >> without the other executables. >> >> >> >> Thanks >> >> >> >> Chris >> >> >> >> >> >> >> >> >> |
|
|
|
24/10/2006, 21h23
|
#6 |
|
Messages: n/a
Hébergeur: |
Re: BCP for SQL2005
John,
I downloaded the SQLExpress and can see, using Winzip, that it has BCP included as part. I do not have a machine to install this onto so can I just pick Native client, SQLCMD and BCP from the downloaded package? I would like to know if this is an option or not? Thanks Chris "John Bell" <jbellnewsposts@hotmail.com> wrote in message news:E207B799-76CE-4FCB-AA42-B9B89CF0F768@microsoft.com... > Hi Chris > > You may want to try installing from SQL Express the tools only which will > not install Management studio or Profiler, but I don't know if BCP is > included. > > John > > "Chris Wood" wrote: > >> That's what I thought John. >> >> We have some non MS SQL servers that don't really need the full Client >> Tools, just the Native Client, SQLCMD and BCP. I could find the first 2 >> and >> had hoped that BCP might be available too but if not then we should just >> be >> able to copy an SQL2005 BCP.EXE onto the server. >> >> Thanks >> >> Chris >> >> "John Bell" <jbellnewsposts@hotmail.com> wrote in message >> news:B7EDF30E-63A6-4757-BA3C-A6A8D53600AF@microsoft.com... >> > Hi Chris >> > >> > I am not sure about the licencing issue with installing the Feature >> > pack >> > version on it's own! AFAIK BCP.EXE is not available as a standalone >> > install, >> > although there are example applications using the Bulk Copy API which >> > you >> > could use to write your own application. >> > >> > John >> > >> > "Chris Wood" wrote: >> > >> >> Hi, >> >> >> >> I know that BCP.EXE is part of the client tools for SQL2005. Does it >> >> also >> >> come as part of a standalone like say SQLCMD.EXE as a standalone from >> >> the >> >> feature Pack? We are looking to install the Native client and SQLCMD >> >> and >> >> BCP >> >> without the other executables. >> >> >> >> Thanks >> >> >> >> Chris >> >> >> >> >> >> >> >> >> |
|
|
|
25/10/2006, 08h49
|
#7 |
|
Messages: n/a
Hébergeur: |
Re: BCP for SQL2005
Hi Chris
I don't think there is a way of being that selective you would need to use the ADDLOCAL and specify Connectivity and SQL_Tools90 John "Chris Wood" wrote: > John, > > I downloaded the SQLExpress and can see, using Winzip, that it has BCP > included as part. I do not have a machine to install this onto so can I just > pick Native client, SQLCMD and BCP from the downloaded package? I would like > to know if this is an option or not? > > Thanks > > Chris > > "John Bell" <jbellnewsposts@hotmail.com> wrote in message > news:E207B799-76CE-4FCB-AA42-B9B89CF0F768@microsoft.com... > > Hi Chris > > > > You may want to try installing from SQL Express the tools only which will > > not install Management studio or Profiler, but I don't know if BCP is > > included. > > > > John > > > > "Chris Wood" wrote: > > > >> That's what I thought John. > >> > >> We have some non MS SQL servers that don't really need the full Client > >> Tools, just the Native Client, SQLCMD and BCP. I could find the first 2 > >> and > >> had hoped that BCP might be available too but if not then we should just > >> be > >> able to copy an SQL2005 BCP.EXE onto the server. > >> > >> Thanks > >> > >> Chris > >> > >> "John Bell" <jbellnewsposts@hotmail.com> wrote in message > >> news:B7EDF30E-63A6-4757-BA3C-A6A8D53600AF@microsoft.com... > >> > Hi Chris > >> > > >> > I am not sure about the licencing issue with installing the Feature > >> > pack > >> > version on it's own! AFAIK BCP.EXE is not available as a standalone > >> > install, > >> > although there are example applications using the Bulk Copy API which > >> > you > >> > could use to write your own application. > >> > > >> > John > >> > > >> > "Chris Wood" wrote: > >> > > >> >> Hi, > >> >> > >> >> I know that BCP.EXE is part of the client tools for SQL2005. Does it > >> >> also > >> >> come as part of a standalone like say SQLCMD.EXE as a standalone from > >> >> the > >> >> feature Pack? We are looking to install the Native client and SQLCMD > >> >> and > >> >> BCP > >> >> without the other executables. > >> >> > >> >> Thanks > >> >> > >> >> Chris > >> >> > >> >> > >> >> > >> > >> > >> > > > |
|
|
|
| Outils de la discussion | |
|
|
