Re: BCP Utility
From: Hari (hari_prasad_k_at_hotmail.com)
Date: 04/21/04
- Next message: Immy: "Re: how to give value with singel quotation in sql query( Mic's)"
- Previous message: Eric Sabine: "Re: Interpreting the Estimated Execution Plan"
- In reply to: Fabrizio Maccarrone: "BCP Utility"
- Next in thread: Fabrizio Maccarrone: "Re: BCP Utility"
- Reply: Fabrizio Maccarrone: "Re: BCP Utility"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 21 Apr 2004 18:20:34 +0530
Hi,
Why do you need Linked server for BCP? It is not required to have linked
server to do a BCP OUT and IN.
Steps to perform BCP OUT / IN between 2 servers
1. Bcp out the data from source server specifying User name, password,
Source server name ....
2. BCP IN the data from text file to destination server
1) Is there the way to bcp an entire database instead of only a table?
No, You have to write your own script on sysobjects fir type ='U' (U - user
tables)
2) I have to bcp a large table(s) (500 MB of data) to linked server, is
there any problem to do this during normal operations (lock and so on...)
for my users?
No need to Linked server for BCP OUT and IN.
Thanks
Hari
MCDBA
"Fabrizio Maccarrone" <fabrizio (at) 7mates (punto) com> wrote in message
news:#Q0aax5JEHA.2576@TK2MSFTNGP12.phx.gbl...
> I have to bcp some data from a server to another.
>
> I add themselves as "linked servers".
>
> Now I want to ask you
>
> 1) Is there the way to bcp an entire database instead of only a table?
> 2) I have to bcp a large table(s) (500 MB of data) to linked server, is
> there any problem to do this during normal operations (lock and so on...)
> for my users?
>
>
> Any help much appreciated.
>
> Regards.
>
> --
> Fabrizio Maccarrone
> --
> YAMSSQLU
> (Yet Another MSSQL User)
>
>
>
- Next message: Immy: "Re: how to give value with singel quotation in sql query( Mic's)"
- Previous message: Eric Sabine: "Re: Interpreting the Estimated Execution Plan"
- In reply to: Fabrizio Maccarrone: "BCP Utility"
- Next in thread: Fabrizio Maccarrone: "Re: BCP Utility"
- Reply: Fabrizio Maccarrone: "Re: BCP Utility"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
