Skip to content

Exported table size incorrectly reported in KB while it's actually in Bytes #209

@yochananrachamim

Description

@yochananrachamim
  • SqlPackage or DacFx Version: 161.6374.0
  • .NET Framework (Windows-only) or .NET Core: .Net Core
  • Environment (local platform and source/target platforms): SQL Server 2019

Description of the issue:
When exporting database and using diagnostics output we can see message for tables exported.
the message shows the size of the table in KB

Example from diagnostics output:

Microsoft.Data.Tools.Diagnostics.Tracer Information: 25 : 2023-01-23T16:30:55 : Perf: Exported table [dbo].[ImageTable], size 102694928 KB, with rate of 48502439.434251316 bytes per seconds

Steps to Reproduce:

  1. create empty database and table with BLOB data type.
  2. insert BLOB record with known size using something like that
    SELECT * FROM OPENROWSET( BULK 'C:\file.bmp', SINGLE_BLOB) as x
  3. Export using SQLPackage with diagnostics output activated.
  4. Validate the reported size of the table.

Expected results:
correct size of the file
Actual results:
Size of the file multiplied by 1024 (incorrectly reported as KB instead of Bytes)

Did this occur in prior versions? If not - which version(s) did it work in?

(DacFx/SqlPackage/SSMS/Azure Data Studio)

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions