How to increase max row for Copy-DbaDbTableData

How do you increase max row for Copy-DbaDbTableData? It keeps timing out. I tried increasing the BatchSize but it didn’t help. Data would start to import but always times out.

Hi, welcome to the forum :wave:

How long does it take to time out? There are a couple of parameters that you may be able to try: -CommandTimeout and -BulkCopyTimeout.

If they don’t make any difference, you’ll probably have more luck asking in a dbatools specific forum, such as: Issues · dataplat/dbatools · GitHub

2 Likes