[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 : 이 글에는 트랙백을 보낼 수 없습니다