Import/Load data:
bcp itinerary.dbo.tariff in "C:\mobile\itinerary.txt" -N -S <ServerName/IP> -U <userid> -P <password> -T
Export/Extract Data:
bcp itinerary.dbo.tariff out "C:\fruit\inventory.txt" -c -S <ServerName/IP> -U <userid> -P <password> -T -h "TABLOCKX"
bcp itinerary.dbo.tariff in "C:\mobile\itinerary.txt" -N -S <ServerName/IP> -U <userid> -P <password> -T
Export/Extract Data:
bcp itinerary.dbo.tariff out "C:\fruit\inventory.txt" -c -S <ServerName/IP> -U <userid> -P <password> -T -h "TABLOCKX"
No comments :
Post a Comment