This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / please help: I want to use BCP to export/import a big table, I know a sample bcp command, but where I type it, an article said type as inside:bcp "SELECT * FROM pubs..authors" queryout authors.txt -U garth -P pw -c
To execute the statement, go to the Command Prompt, what is Command Prompt.........:-( ji, ji ,ji .ji,...........................
-shinning(dudu);
2003-4-11
{208}
(#1135156@0)
-
I'm using SQL Server 2000.....
-shinning(dudu);
2003-4-11
(#1135159@0)
-
up.....I only can use BCP to do it, please tell me if anybody knows..can I write it in query analyzer or stored procedures.thanks a lot
-shinning(dudu);
2003-4-11
(#1135305@0)
-
from START-->RUN, type your commond
-zxcvb(闷死了！);
2003-4-11
(#1135362@0)
-
thank you soooooooooooooooooooo much. ~~.~~
and I also want to import this file to a remote sql server DB, is it same way, -->start-->run the commands???????
-shinning(dudu);
2003-4-11
(#1135391@0)
-
from sql server enterprise manager, right click on the table you want to export, choose export
-zxcvb(闷死了！);
2003-4-11
(#1135401@0)
-
Copying Data Between Servers
-zxcvb(闷死了！);
2003-4-11
{1614}
(#1135458@0)
-
why don't u use dsn file? it's easy than bulk copy
-zxcvb(闷死了！);
2003-4-11
(#1135379@0)
-
because it have 45000 records, and size of log file is limited, it failed by using DTS, and web admin told me must use BCP...
-shinning(dudu);
2003-4-11
(#1135420@0)
-
Getting Started with Command Prompt Utilities
-zxcvb(闷死了！);
2003-4-11
{2281}
(#1135388@0)
-
I found the bcp.exe, I double click it, but it can not run, it show so quickly, even I can not see it..:-(
-shinning(dudu);
2003-4-11
(#1135439@0)
-
a........................how do i do, I try to use BCP, but failed lots of times, and even I can not see error massage, because the windows closed so quickly.....:(
-shinning(dudu);
2003-4-11
(#1135490@0)
-
try this: bcp pubs..authors out authors.txt -ca pop window will will ask password, type ur pwd in and hit enter. the text file will be created under c:/
-zxcvb(闷死了！);
2003-4-11
{106}
(#1135714@0)
-
another total windows guy, only knows window, hehe. BCP is a command tool, means you have to open a console (e.g dos prompt) then type the command with correct parameters.
-dibert(呆伯);
2003-4-11
(#1135931@0)
-
BTW, 45000 is not a big number, I've ever bcped 4 million records, (but in Sybase not SQL server). no problem for bcp out, but when u bcp in, something should be paid attention:these are for Sybase, but may SQL Server also.
1) fast or slow bcp (for log increasement)
2) -b option (for tran size)
3) -E option (for identity column)
If bcp for SQL server don't have above, forget them.
-dibert(呆伯);
2003-4-11
{211}
(#1135956@0)