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 ![]()
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