3
Vote

Idea: Partition generator

description

We often have to create partitions, it would be nice to generate them in BIDS. This would save us a lot of time.

comments

dgosbell wrote May 21, 2013 at 11:18 PM

BIDS already has a UI for creating partitions. So I assume you are talking about some sort of wizard approach that would generate partitions. Are you able to provide more details about how you would see this working?

In my experience the most common pattern is to generate a date based partitioning scheme and we only generate a template partition in BIDS and then dynamically add partitions as part of our ETL. We would not want to have to re-deploy from BIDS in order to add new partitions, so I'm not sure what sort of scenario you have in mind.

DanielBos wrote May 22, 2013 at 7:15 AM

The thing is that I sometimes want to generate 20 or 30 partitions instead of creating them manually. This would save me a lot of time (indeed, I mean a wizzard-like approach).

But you're right, I could solve this using AMO. I will work this out today.

Thank you for your reply!