Skip to content

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

Description

  • 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)

No activity

Activity on this issue will appear here.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Labels

Type

No type

Projects

No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions