Thursday, March 14, 2013

How could you import or export bulk data in SQL Server?

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"

No comments :