Hi everyone. After to view this very good video, maybe to see LoaderDataPlus tool to import CSV files and to import in SQLSERVER with BCP tool, and too other DMBS, also parsing and detect data type.
AOA, Manzoor, I have large table that size is approx 400gb and i want to copy same table into my staging instance, please advise BCP will work in this large table scenario because i will copy table data from my production database to staging server. please advise.
Hi everyone. After to view this very good video, maybe to see LoaderDataPlus tool to import CSV files and to import in SQLSERVER with BCP tool, and too other DMBS, also parsing and detect data type.
Just what i needed. Thank you!
Perfect, really helped - thank you
AOA, Manzoor, I have large table that size is approx 400gb and i want to copy same table into my staging instance, please advise BCP will work in this large table scenario because i will copy table data from my production database to staging server. please advise.
could I get the copy query that contains 7 command?
It's available on website - www.SQLServerLog.com
hi, bro, you can try show example import of file *.dat and *.xml. just can be interesting. thx
Hi Manzoor,
Can you please tell us how to fetch data in different column using csv file with header.
Many thanks in advance.
Regards,
Amol M