[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/08   »
    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:
419291
Today:
95
Yesterday:
111