Tips for using bulk copy in SQL Server 2014 Use native mode bulk copy whenever possible. Because native mode bulk copies are generally faster than character mode, you should use native mode bulk copy whenever possible. Note. Now the bcp utility supports native data files compatible with SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2,...
Tag: BULK insert
Troubleshooting SQL Server 2012 Bulk Copy Problems
Troubleshooting SQL Server 2012 Bulk Copy Problems If you have problems with SQL Server 2012 bulk copy, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because some SQL Server 2012 bulk copy bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the...
Troubleshooting problems with bulk copy in SQL Server 2008 R2
Troubleshooting problems with bulk copy in SQL Server 2008 R2 If you have problems with bulk copy in SQL Server 2008 R2, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 bulk copy bugs were fixed in SQL Server service packs, you should install the...