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
ChrisHi 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
>
>|||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
>>|||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
> >>
> >>
> >>
>
>|||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
>> >>
>> >>
>> >>
>>|||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
>> >>
>> >>
>> >>
>>|||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
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>