[MS-SQL] bcp로 데이타 dump(import, export)

1. export

c:\>bcp 디비명.소유자.테이블명 out FILE_NAME -c -T

c:\>bcp NRMSdb..discharge out c:\discharge.txt -c -T


2. import

c:\>bcp 디비명.소유자.테이블명 in FILE_NAME -c -T

c:\>bcp NRMSdb..discharge in c:\discharge.txt -c -T

Posted by incree

2013/03/28 23:49 2013/03/28 23:49
, , , , ,
Response
0 Trackbacks , 0 Comments
RSS :
http://www.incree.com/tc/incree/rss/response/207

Trackback URL : 이 글에는 트랙백을 보낼 수 없습니다


Notices

Archives

Authors

  1. incree

Recent Trackbacks

Calendar

«   2017/02   »
      1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28        

Site Stats

Total hits:
389701
Today:
36
Yesterday:
144