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...
Tag: bcp
Bulk Transfers: Some guidelines
Bulk Transfers: Some guidelines Author: Basit A. Farooq Introduction Bulk transfers are a common way of importing large amounts of data into, or exporting large amounts of data out of, SQL Server databases. SQL Server supports bulk transfers run from an operating system command line or the SQL Server command processor. When performing bulk transfers, you must consider the implications...
Tips for using SQL Server 2012 bulk copy
Tips for using SQL Server 2012 bulk copy Use the -K option of the bcp utility. This option was first introduced in SQL Server 2012. If you specify "ReadOnly" for the -K option the read-only access to a secondary replica in an AlwaysOn availability group will be used. Consider using minimally logged bulk copy whenever possible. The minimally logged bulk...
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...