dbatools icon indicating copy to clipboard operation
dbatools copied to clipboard

export-dbaDbTableData generates files with same timestamp

Open wfvdijk opened this issue 2 years ago • 0 comments

Verified issue does not already exist?

No, I did not search

What error did you receive?

I was exporting all tables from a database using Get-DbaDBTable ... | export_dbaDbTableData. This export generated multiple files with the same filename. As a result only the last filename remained.

Steps to Reproduce

# provide your command(s) executed pertaining to dbatools
# please include variable values (redacted or fake if needed) for reference

Please confirm that you are running the most recent version of dbatools

1.1.142

Other details or mentions

output:

Mode                LastWriteTime         Length Name
----                -------------         ------ ----
-a----       27/07/2023     16:16           6967 tsql02-20230727161621-script.sql
-a----       27/07/2023     16:16            401 tsql02-20230727161621-script.sql
-a----       27/07/2023     16:16           4682 tsql02-20230727161621-script.sql
-a----       27/07/2023     16:16          67182 tsql02-20230727161621-script.sql
-a----       27/07/2023     16:16          49514 tsql02-20230727161621-script.sql
-a----       27/07/2023     16:16         941319 tsql02-20230727161622-script.sql
-a----       27/07/2023     16:16         970570 tsql02-20230727161622-script.sql
-a----       27/07/2023     16:16          86735 tsql02-20230727161622-script.sql
-a----       27/07/2023     16:16         471292 tsql02-20230727161623-script.sql
-a----       27/07/2023     16:16        1450673 tsql02-20230727161623-script.sql
-a----       27/07/2023     16:16           4688 tsql02-20230727161623-script.sql
-a----       27/07/2023     16:16           3313 tsql02-20230727161623-script.sql
-a----       27/07/2023     16:16       11919469 tsql02-20230727161623-script.sql
-a----       27/07/2023     16:16           2765 tsql02-20230727161626-script.sql
-a----       27/07/2023     16:16            207 tsql02-20230727161626-script.sql
-a----       27/07/2023     16:16        6824358 tsql02-20230727161626-script.sql
-a----       27/07/2023     16:16           7393 tsql02-20230727161626-script.sql

What PowerShell host was used when producing this error

Windows PowerShell (powershell.exe)

PowerShell Host Version

Name Value


PSVersion 5.1.17763.4644
PSEdition Desktop
PSCompatibleVersions {1.0, 2.0, 3.0, 4.0...}
BuildVersion 10.0.17763.4644
CLRVersion 4.0.30319.42000
WSManStackVersion 3.0
PSRemotingProtocolVersion 2.3
SerializationVersion 1.1.0.1

SQL Server Edition and Build number

Microsoft SQL Server 2019 (RTM-CU17) (KB5016394) - 15.0.4249.2 (X64) Jul 22 2022 12:11:33 Copyright (C) 2019 Microsoft Corporation Developer Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)

.NET Framework Version

PSChildName Version


Client 4.8.03761 Full 4.8.03761 Client 4.0.0.0

wfvdijk avatar Jul 27 '23 14:07 wfvdijk