显示标签为“exe”的博文。显示所有博文
显示标签为“exe”的博文。显示所有博文

2012年3月29日星期四

Bcp.exe on client machine

Hi,
We use BCP.EXE to bulk upload to SQL Server. However, some of our clients
use SQL Server while others use MSDE.
We need to have BCP.EXE available on each client machine.
In case of a MSDE server does this mean that each client machine needs the
full MSDE installed just to get bcp.exe?
In case of the full SQL Server server does this mean that each client
machine needs a client tool like Query Analyzer installed just to get
bcp.exe?
Can I run SQLREDIS.EXE on a client machine instead and then just copy the
BCP.EXE and BCP.RLL files from the server machine instead? I read the
licenses but it is still unclear to me if this is allowed.
I've Googled to try find a solution but things are still as clear as mud.
Thanks in advance for any help,
Jako GroblerJako Grobler wrote:
> Hi,
> We use BCP.EXE to bulk upload to SQL Server. However, some of our
> clients use SQL Server while others use MSDE.
> We need to have BCP.EXE available on each client machine.
> In case of a MSDE server does this mean that each client machine
> needs the full MSDE installed just to get bcp.exe?
> In case of the full SQL Server server does this mean that each client
> machine needs a client tool like Query Analyzer installed just to get
> bcp.exe?
> Can I run SQLREDIS.EXE on a client machine instead and then just copy
> the BCP.EXE and BCP.RLL files from the server machine instead? I read
> the licenses but it is still unclear to me if this is allowed.
> I've Googled to try find a solution but things are still as clear as
> mud.
> Thanks in advance for any help,
> Jako Grobler
I'd just install the client utilities on every client machine (unless it's
a server at the same time). Disk space is cheap and this is definitely
the most hassle free solution - apart from licensing maybe.
Kind regards
robert|||"Robert Klemme" <bob.news@.gmx.net> wrote in
news:ONhaOCncFHA.3120@.TK2MSFTNGP12.phx.gbl:

> I'd just install the client utilities on every client machine (unless
> it's a server at the same time). Disk space is cheap and this is
> definitely the most hassle free solution - apart from licensing maybe.
> Kind regards
> robert
The problem is that the client utilities option is not available with MSDE.
Also, some companies are not happy installing Query Analyzer or Enterprise
Manager on client machines.
SQLREDIS.EXE does not install BCP.EXE, I tried it already.
:-(
Jako|||Jako Grobler wrote:
> "Robert Klemme" <bob.news@.gmx.net> wrote in
> news:ONhaOCncFHA.3120@.TK2MSFTNGP12.phx.gbl:
>
> The problem is that the client utilities option is not available with
> MSDE.
You can simply use SQL Server client utilities. They should happily
connect to an MSDE instance.

> Also, some companies are not happy installing Query Analyzer or
> Enterprise Manager on client machines.
Well then...

> SQLREDIS.EXE does not install BCP.EXE, I tried it already.
> :-(
> Jako
Kind regards
robert

Bcp.exe on client machine

Hi,
We use BCP.EXE to bulk upload to SQL Server. However, some of our clients
use SQL Server while others use MSDE.
We need to have BCP.EXE available on each client machine.
In case of a MSDE server does this mean that each client machine needs the
full MSDE installed just to get bcp.exe?
In case of the full SQL Server server does this mean that each client
machine needs a client tool like Query Analyzer installed just to get
bcp.exe?
Can I run SQLREDIS.EXE on a client machine instead and then just copy the
BCP.EXE and BCP.RLL files from the server machine instead? I read the
licenses but it is still unclear to me if this is allowed.
I've Googled to try find a solution but things are still as clear as mud.
Thanks in advance for any help,
Jako Grobler
Jako Grobler wrote:
> Hi,
> We use BCP.EXE to bulk upload to SQL Server. However, some of our
> clients use SQL Server while others use MSDE.
> We need to have BCP.EXE available on each client machine.
> In case of a MSDE server does this mean that each client machine
> needs the full MSDE installed just to get bcp.exe?
> In case of the full SQL Server server does this mean that each client
> machine needs a client tool like Query Analyzer installed just to get
> bcp.exe?
> Can I run SQLREDIS.EXE on a client machine instead and then just copy
> the BCP.EXE and BCP.RLL files from the server machine instead? I read
> the licenses but it is still unclear to me if this is allowed.
> I've Googled to try find a solution but things are still as clear as
> mud.
> Thanks in advance for any help,
> Jako Grobler
I'd just install the client utilities on every client machine (unless it's
a server at the same time). Disk space is cheap and this is definitely
the most hassle free solution - apart from licensing maybe.
Kind regards
robert
|||"Robert Klemme" <bob.news@.gmx.net> wrote in
news:ONhaOCncFHA.3120@.TK2MSFTNGP12.phx.gbl:

> I'd just install the client utilities on every client machine (unless
> it's a server at the same time). Disk space is cheap and this is
> definitely the most hassle free solution - apart from licensing maybe.
> Kind regards
> robert
The problem is that the client utilities option is not available with MSDE.
Also, some companies are not happy installing Query Analyzer or Enterprise
Manager on client machines.
SQLREDIS.EXE does not install BCP.EXE, I tried it already.
:-(
Jako
|||Jako Grobler wrote:
> "Robert Klemme" <bob.news@.gmx.net> wrote in
> news:ONhaOCncFHA.3120@.TK2MSFTNGP12.phx.gbl:
>
> The problem is that the client utilities option is not available with
> MSDE.
You can simply use SQL Server client utilities. They should happily
connect to an MSDE instance.

> Also, some companies are not happy installing Query Analyzer or
> Enterprise Manager on client machines.
Well then...

> SQLREDIS.EXE does not install BCP.EXE, I tried it already.
> :-(
> Jako
Kind regards
robert

Bcp.exe on client machine

Hi,
We use BCP.EXE to bulk upload to SQL Server. However, some of our clients
use SQL Server while others use MSDE.
We need to have BCP.EXE available on each client machine.
In case of a MSDE server does this mean that each client machine needs the
full MSDE installed just to get bcp.exe?
In case of the full SQL Server server does this mean that each client
machine needs a client tool like Query Analyzer installed just to get
bcp.exe?
Can I run SQLREDIS.EXE on a client machine instead and then just copy the
BCP.EXE and BCP.RLL files from the server machine instead? I read the
licenses but it is still unclear to me if this is allowed.
I've Googled to try find a solution but things are still as clear as mud.
Thanks in advance for any help,
Jako GroblerJako Grobler wrote:
> Hi,
> We use BCP.EXE to bulk upload to SQL Server. However, some of our
> clients use SQL Server while others use MSDE.
> We need to have BCP.EXE available on each client machine.
> In case of a MSDE server does this mean that each client machine
> needs the full MSDE installed just to get bcp.exe?
> In case of the full SQL Server server does this mean that each client
> machine needs a client tool like Query Analyzer installed just to get
> bcp.exe?
> Can I run SQLREDIS.EXE on a client machine instead and then just copy
> the BCP.EXE and BCP.RLL files from the server machine instead? I read
> the licenses but it is still unclear to me if this is allowed.
> I've Googled to try find a solution but things are still as clear as
> mud.
> Thanks in advance for any help,
> Jako Grobler
I'd just install the client utilities on every client machine (unless it's
a server at the same time). Disk space is cheap and this is definitely
the most hassle free solution - apart from licensing maybe.
Kind regards
robert|||"Robert Klemme" <bob.news@.gmx.net> wrote in
news:ONhaOCncFHA.3120@.TK2MSFTNGP12.phx.gbl:
> I'd just install the client utilities on every client machine (unless
> it's a server at the same time). Disk space is cheap and this is
> definitely the most hassle free solution - apart from licensing maybe.
> Kind regards
> robert
The problem is that the client utilities option is not available with MSDE.
Also, some companies are not happy installing Query Analyzer or Enterprise
Manager on client machines.
SQLREDIS.EXE does not install BCP.EXE, I tried it already.
:-(
Jako|||Jako Grobler wrote:
> "Robert Klemme" <bob.news@.gmx.net> wrote in
> news:ONhaOCncFHA.3120@.TK2MSFTNGP12.phx.gbl:
>> I'd just install the client utilities on every client machine (unless
>> it's a server at the same time). Disk space is cheap and this is
>> definitely the most hassle free solution - apart from licensing
>> maybe.
>> Kind regards
>> robert
> The problem is that the client utilities option is not available with
> MSDE.
You can simply use SQL Server client utilities. They should happily
connect to an MSDE instance.
> Also, some companies are not happy installing Query Analyzer or
> Enterprise Manager on client machines.
Well then...
> SQLREDIS.EXE does not install BCP.EXE, I tried it already.
> :-(
> Jako
Kind regards
robert

BCP.EXE for SQL Server

Is it possible/legal to place just the BCP.exe and it's required files on
a non-sql server machine? If not please let me know the best way to use bulk insert into SQL server from a remote machine?

-thanks
john

Yes, you can, but be aware that accessing SQL Server will need an additional licence if connected to a productional server.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||See my post in this similar thread.

sql

bcp.exe connects to go.microsoft.com?

Hi!
We're using MSDE 1.0 and one customer informed us, that his Sygate
personal firewall spit out the following message:
bcp.exe is trying to connect to go.microsoft.com [207.46.197.43] using
port 80.
the exe's path is the path that we'd expect and bcp still does it's job,
namely saving the databases to files; so I doubt that it is a hijacked
version; but we'll have to double check that.
Can anyone explain why bcp would want to connect to a website?
Thanks,
Stefan
Check your event log. For many Microsoft Products, events that have errors
can connect to or provide a link to go.microsoft.com ... if you have error
reporting enabled that might be where the error goes...
I see this in my event log for various auditing events and errors:
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
http://www.aspfaq.com/
(Reverse address to reply.)
"Stefan M. Huber" <looseleaf@.gmx.net> wrote in message
news:opsb7imbzss9ddfw@.news.individual.de...
> Hi!
> We're using MSDE 1.0 and one customer informed us, that his Sygate
> personal firewall spit out the following message:
> bcp.exe is trying to connect to go.microsoft.com [207.46.197.43] using
> port 80.
> the exe's path is the path that we'd expect and bcp still does it's job,
> namely saving the databases to files; so I doubt that it is a hijacked
> version; but we'll have to double check that.
> Can anyone explain why bcp would want to connect to a website?
> Thanks,
> Stefan
|||On Wed, 4 Aug 2004 09:43:42 -0400, Aaron [SQL Server MVP]
<ten.xoc@.dnartreb.noraa> wrote:

> Check your event log. For many Microsoft Products, events that have
> errors
> can connect to or provide a link to go.microsoft.com ... if you have
> error
> reporting enabled that might be where the error goes...
Oh thank you. That is a very good hint.
Stefan
Pink Floyd of Borg: We don't need no assimilation!

2012年3月27日星期二

BCP with Windows authentication?

We've been using BCP.EXE for ages, but are now connecting to our
databases via Windows authentication rather than SQL ID's. How can I
get BCP to connect via Windows authentication? Thanks.Can't find Books on Line? First, run bcp /? to see all the
parameters. You will find one to use a Trusted connection:
[-T trusted connection]
Roy Harvey
Beacon Falls, CT
On Wed, 3 May 2006 12:44:08 -0400, Rick Charnes
<rickxyz--nospam.zyxcharnes@.thehartford.com> wrote:

>We've been using BCP.EXE for ages, but are now connecting to our
>databases via Windows authentication rather than SQL ID's. How can I
>get BCP to connect via Windows authentication? Thanks.|||I have not tried this in a long time but shold be -T as shown on the help
-T (trusted connection)
Ben Nevarez, MCDBA, OCP
Database Administrator
"Rick Charnes" wrote:

> We've been using BCP.EXE for ages, but are now connecting to our
> databases via Windows authentication rather than SQL ID's. How can I
> get BCP to connect via Windows authentication? Thanks.
>

2012年3月25日星期日

bcp to xml

can someone please advise me on the correct syntax to bcp export executing a
stored procedures results to xml
I know it begins
bcp "exe sp_procedure" queryout
but unser on the rest of the syntax
many thanks
bcp "SELECT * FROM TABLE FOR XML RAW" queryout
c:\table.xml -Sserver -Uusername -Ppassword -c -r -t
"Matthew Butler" <matthew.butler@.srjdebt.co.uk> wrote in message
news:KuZ%i.24820$6v.5502@.newsfe2-gui.ntli.net...
> can someone please advise me on the correct syntax to bcp export executing
> a stored procedures results to xml
> I know it begins
> bcp "exe sp_procedure" queryout
> but unser on the rest of the syntax
> many thanks
>

bcp to xml

can someone please advise me on the correct syntax to bcp export executing a
stored procedures results to xml
I know it begins
bcp "exe sp_procedure" queryout
but unser on the rest of the syntax
many thanksbcp "SELECT * FROM TABLE FOR XML RAW" queryout
c:\table.xml -Sserver -Uusername -Ppassword -c -r -t
"Matthew Butler" <matthew.butler@.srjdebt.co.uk> wrote in message
news:KuZ%i.24820$6v.5502@.newsfe2-gui.ntli.net...
> can someone please advise me on the correct syntax to bcp export executing
> a stored procedures results to xml
> I know it begins
> bcp "exe sp_procedure" queryout
> but unser on the rest of the syntax
> many thanks
>sql

2012年3月19日星期一

BCP on client machine

Hi,

What is the best practice to use BCP.exe to load text file from client machine to the SQLSERVER database installed in another server machine, without installing SQLSERVER client tools on the client machine.

Any suggestions is appreciated.

Thanks in advance.

-Anand

You can use BCP on the client machine, but you will have to be aware to have a licencse for that. If you do not want to use BPC per se (becasue of this reason) you will have to implement it on your own, or by another third party data pump.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||Thanks for your reply.

Can anybody help me out in downloading the third party data dump tool. I heard about freetds, thats only for linux.

Any help is appreciated.

-Anand|||

My understanding is that BCP is in the class of 'Client Tools' that are available to install on any client computer that is licensed with a CAL, or to access a SQL Server that is licensed with a Processor license.

For definitive answers about licensing, contact the licensing forks at:

Licensing –Microsoft, Contact
(800) 426-9400

From: http://www.microsoft.com/sql/howtobuy/faq.mspx

Do I need a separate license to run the SQL Server tools and analysis services? A.

No, a separate license is not required. However, any device that has SQL Server tools or technologies installed must have a valid SQL Server license.

Note: Most of the 'Client Tools' are NOT included with SQL Server 2005 Express Edition. There is, however, a special version of SQL Server Management Studio Express available.

BCP install

Hi,

I need to have on a client machine the bcp.exe installed. What components do I need to install from SQL Server 2005. I would like to have the absolute minimal installed on this machine.


Thanks.

Solved the problem:

download the SQLEXPR_TOOLKIT.EXE and installed only the connections component.

2012年3月8日星期四

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
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 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...[vbcol=seagreen]
> 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 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...
>
>
|||That's something worth trying.
Thanks
Chris
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:E207B799-76CE-4FCB-AA42-B9B89CF0F768@.microsoft.com...[vbcol=seagreen]
> 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:
|||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...[vbcol=seagreen]
> 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:

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

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 B
CP
> 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...[vbcol=seagreen]
> 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 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 an
d
> had hoped that BCP might be available too but if not then we should just b
e
> 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...
>
>|||That's something worth trying.
Thanks
Chris
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:E207B799-76CE-4FCB-AA42-B9B89CF0F768@.microsoft.com...[vbcol=seagreen]
> 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:
>|||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...[vbcol=seagreen]
> 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:
>|||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 ju
st
> pick Native client, SQLCMD and BCP from the downloaded package? I would li
ke
> 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...
>
>

2012年3月6日星期二

bcp error handling

Hello
I am using bcp.exe to transfer data between remote servers and need a way to
do the error handling. What I need is simple - just to know whether the copy
was successful or not, because it needs to be in transaction with other
operations. There are situations when the return value of the exe is always
0 and nothing gets written into the error log ( for example copying from
file to table that violates a constraint ). All that came to me was to parse
the log file ( option -o ) for strings like 'error' and 'failed' but this
doesn't look like a great idea. And yes, I am using bcp in both directions,
so bulk insert will not do.
Any ideas of how to find whether the copy was successful?
(sql server 2000 sp3, in case it matters)
Thanks
Plamen
"Plamen Doykov" <p_doykov@.code.bg> schrieb im Newsbeitrag
news:uoZ1ear1EHA.2540@.TK2MSFTNGP09.phx.gbl...
> Hello
> I am using bcp.exe to transfer data between remote servers and need a
way to
> do the error handling. What I need is simple - just to know whether the
copy
> was successful or not, because it needs to be in transaction with other
> operations. There are situations when the return value of the exe is
always
> 0 and nothing gets written into the error log ( for example copying from
> file to table that violates a constraint ). All that came to me was to
parse
> the log file ( option -o ) for strings like 'error' and 'failed' but
this
> doesn't look like a great idea. And yes, I am using bcp in both
directions,
> so bulk insert will not do.
> Any ideas of how to find whether the copy was successful?
> (sql server 2000 sp3, in case it matters)
We settled with the output parsing also. That's what we use in Java:
private static final Pattern ERROR_PATTERN =
Pattern.compile(
"^\\s*(?:SQLState\\s*=\\s*([^,]+?)\\s*,\\s*NativeError\\s*=\\s*([+-]?\\d+)
\\s*|" +
"Error\\s+=\\s*+(.*?))$", Pattern.MULTILINE );
/**
* Extract error BCP messages from the given process output.
*
* @.param bcpOutput the output to extract the messages from.
* @.return a List of {@.link String} with the messages.
*/
protected static List extractErrorMessages( String bcpOutput ) {
List messages = new LinkedList();
Matcher m = ERROR_PATTERN.matcher( bcpOutput );
SqlServerError err = null;
while ( m.find() ) {
String message = m.group( 3 );
if ( message == null ) {
/*
* no message => first line:
* SQLState = 23000, NativeError = 3604
*/
err = new SqlServerError();
err.setSqlState( m.group( 1 ) );
err.setNativeError( StringParsing.string2int( m.group(
2 ) ) );
}
else {
/*
* second line:
* Error = [Microsoft][ODBC SQL Server Driver][SQL
Server]Doppelter Schl?ssel wurde ignoriert.
*/
err.setMessage( message );
messages.add( err );
err = null;
}
}
return messages;
}
Kind regards
robert

2012年2月18日星期六

bcp

How implements bcp.exe in visual basic.net project.
hi Viktor,
"Viktor Zadro" <viktor.zadro@.tel.net.ba> ha scritto nel messaggio
news:O1IHIcPtEHA.2192@.TK2MSFTNGP14.phx.gbl
> How implements bcp.exe in visual basic.net project.
how would you implement BCP?
you can "shell" to it, or you could "import" the COM object definition of
bcp (via INTEROP) and access it's properties and methods...
http://msdn.microsoft.com/library/de..._ob_b_8o8k.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply