Use BCP to Backup/Restore Table

24-02-2013

Backup/Export

bcp YourDBName.dbo.YourTableName out YourOutputFilePath -U YourUserName -P YourPassword -S HostNameOfYourServer -c

Restore/Import

bcp YourDBName.dbo.YourTableName in YourDatabaseTableFilePath -U YourUserName -P YourPassword -S HostNameOfYourServer -c

详细参数参考 这里

Creative Commons Licence
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License.