Skip to main content
To homepage To homepage
Solved

SQL Database cleanup tool for ODX

P
Contributor
Forum|alt.badge.img+2

Is there a way to remove tables from ODX storage that have been deleted in the desktop, similar to the SQL Database cleanup tool available in the DW? My use case is when SQL Storage is used for the ODX.

The “Remove unused object” option does not drop tables it seems. The Storage Management Task is good of course, but we can’t use it for deleted data sources.

Let’s say I have transferred a large table hundreds of times into my ODX and then deleted the data source. Can I remove them without having to drop the tables manually in SSMS?

Best,

Pontus 

Best answer by pontus.berglund

I have posted it as an idea: 

https://support.timextender.com/ideas/add-odx-storage-clean-up-tool-1711

 

View original
Did this topic help you find an answer to your question?

3 replies

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Thomas Lind
  • Community Manager
  • 1035 replies
  • January 24, 2024

Hi @pontus.berglund 

No it can’t clean it from within the program, you will have to do it from another program.

I see if more as a new feature. Are you able to change the original wording to be more like that?

Then I can change it to a suggestion instead of a question.

P
Contributor
Forum|alt.badge.img+2

Hi @Thomas Lind,

Ok thanks for letting me know. Yes that would be a new feature then. I can rewrite the post and post it in the ideas section.

P
Contributor
Forum|alt.badge.img+2
  • pontus.berglund
  • Author
  • Contributor
  • 61 replies
  • Answer
  • January 24, 2024

I have posted it as an idea: 

https://support.timextender.com/ideas/add-odx-storage-clean-up-tool-1711

 

Thomas Lind
1 person likes this
  • Thomas Lind
    Thomas Lind

Reply


Most helpful members this week

Terms and ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings