Export and import records in a table using BCP To export records in a table, using below command. bcp [databaseName].dbo.tableName out <backupLocation> -n -T To import records to a table, using below command. bcp [ databaseName ].dbo. tableName IN < backupLocation> -b 5000 -h "TABLOCK" -m 1 -n -e <errorLogLocation> -o <outputLogLocation> -S -T