Skip to content

Get-DbaDbTable: Fix for Azure SQL Database#10182

Open
andreasjordan wants to merge 2 commits intodevelopmentfrom
fix_GetDbaDbTable
Open

Get-DbaDbTable: Fix for Azure SQL Database#10182
andreasjordan wants to merge 2 commits intodevelopmentfrom
fix_GetDbaDbTable

Conversation

@andreasjordan
Copy link
Collaborator

Type of Change

  • Bug fix (non-breaking change, fixes Copy-DbaDbTableData Fails in Version 2.7.25 Exception calling "ClearAndInitialize" #10181 )
  • New feature (non-breaking change, adds functionality, fixes # )
  • Breaking change (affects multiple commands or functionality, fixes # )
  • Ran manual Pester test and has passed (Invoke-ManualPester)
  • Adding code coverage to existing functionality
  • Pester test is included
  • If new file reference added for test, has is been added to github.com/dataplat/appveyor-lab ?
  • Unit test is included
  • Documentation
  • Build system

Claude said:
Azure SQL's SMO enumerator does not support IndexSpaceUsed and DataSpaceUsed. When ClearAndInitialize is called with an explicit property list that includes these, it throws "unknown property IndexSpaceUsed".

@andreasjordan
Copy link
Collaborator Author

I will try to find time on the weekend to spin up an Azure SQL database and test this fix.

@andreasjordan
Copy link
Collaborator Author

andreasjordan commented Feb 22, 2026

Just tested in my lab - fix works.

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

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

Copy-DbaDbTableData Fails in Version 2.7.25 Exception calling "ClearAndInitialize"

2 participants