[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/10   »
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:
428044
Today:
84
Yesterday:
91