problem with the command "bcp" 
Author Message
 problem with the command "bcp"
Hello,
I'd like to export a database in ONE instruction but the command "bcp"
can only export table by table.
I would like to know if the command "bcp" can export the database in
one instruction.
Thanks,
Cissou


Mon, 13 Sep 2004 17:21:02 GMT
 problem with the command "bcp"

i'm afraid not. you would need to loop through and execute bcp on every
table.

--
-oj
Feeling Lucky Today?! Download a copy of RAC v2.0
and register for our weekly sweepstake!
http://www.rac4sql.com


Quote:
> Hello,
> I'd like to export a database in ONE instruction but the command "bcp"
> can only export table by table.
> I would like to know if the command "bcp" can export the database in
> one instruction.
> Thanks,
> Cissou



Mon, 13 Sep 2004 17:33:26 GMT
 problem with the command "bcp"
How about using DTS? Other options - backup/restore, replication, detach/attach db,log shipping,linked server

If you must use BCP, then perhaps the following KB will help: Q176818 INF: How to Bulk Copy Out All the Tables in a
Database. It's 6.5 but I am sure it'll work for post 6.5.

Keith

=================================================
* Posting is provided "AS IS" with no warranties, and confers no rights.
*
* For information about the Strategic Technology Protection
* Program and to order your FREE Security Tool Kit, visit
*          http://www.microsoft.com/security
*
--------------------

|>Newsgroups: microsoft.public.sqlserver.programming
|>Subject: problem with the command "bcp"
|>Date: 28 Mar 2002 01:21:02 -0800
|>Organization: http://groups.google.com/
|>Lines: 7

|>NNTP-Posting-Host: 217.167.18.101
|>Content-Type: text/plain; charset=ISO-8859-1
|>Content-Transfer-Encoding: 8bit
|>X-Trace: posting.google.com 1017307262 27758 127.0.0.1 (28 Mar 2002 09:21:02 GMT)

|>NNTP-Posting-Date: 28 Mar 2002 09:21:02 GMT
|>Path: cpmsftngxa07!tkmsftngp01!newsfeed00.sul.t-online.de!t-online.de!fr.usenet-edu.net!usenet-edu.net!proxad.net!
isdnet!sn-xit-02!supernews.com!postnews1.google.com!not-for-mail
|>Xref: cpmsftngxa07 microsoft.public.sqlserver.programming:245299
|>X-Tomcat-NG: microsoft.public.sqlserver.programming
|>
|>Hello,
|>I'd like to export a database in ONE instruction but the command "bcp"
|>can only export table by table.
|>I would like to know if the command "bcp" can export the database in
|>one instruction.
|>Thanks,
|>Cissou
|>



Tue, 14 Sep 2004 23:16:32 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Nasty SybPerl/bcp "bad free()" problem

2. BCP Problems "String data, right truncation"

3. max of ("...","...","..")

4. problem with "create directory " command

5. Having problems with "Insert Into" command

6. BCP - text qualifiers ""

7. "function sequence error" with BCP

8. sa CAN "xp_cmdshell bcp blabla", other users cannot

9. "bcp" question

10. BCP lockup with multiple "text" columns

11. bcp text file with "" identifiers

12. BCP "HOW-TO"?


 
Powered by phpBB® Forum Software