[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/07   »
            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 29
30 31          

Site Stats

Total hits:
415553
Today:
87
Yesterday:
140