다음을 통해 공유

Partitioned Table Framework (PTF) Project has been published on CodePlex

  • 아티클

Today I did publish the PTF project on CodePlex (see https://ptf.codeplex.com/) which consists of a set of T-SQL stored procedures for managing partitioned tables in SQL Server. These procedures may be used in your SQL Agent Jobs or SSIS SQL Tasks that load data into staging tables of your data warehouse and then switch these tables into partitions of your partitioned fact tables, i.e. implementing a sliding window scenario. All SQL Server versions and Editions that allow for partitioned tables are being supported.

The following activities can be accomplished:

  • Creating a staging table.
  • Preparing a staging table, i.e. creating Indexes and constraints.
  • Performing partition switches and Partition merges and splits.
  • Unloading or uploading of specific partitions.
  • Converting an unpartitioned table into a partitioned one.

For detailed documentation download the PTF.docx file from the codeplex project.

Comments

  • Anonymous
    November 25, 2012
    I'm curious about why you chose to develop this given that there is a .NET tool which ostensibly does the same thing. The link is below. My question is an honest question; I'm not trying to be belligerent. :) If your tools rely only on SQL (no CLR or c# executables needed), that would be cool enough. :) A related question: Do you happen to know if your tools do everything the partition management tool does? I am currently using the partition management tool below, and it might be nice to use a SQL based tool, so that is why I'm asking. Sincerest regards, Jason sqlpartitionmgmt.codeplex.com

  • Anonymous
    January 06, 2013
    Of course, I was aware of the sqlpartitionmgmt project when developing my tool. The main difference is that PTF is fully implemented in T-SQL and hence can easily being incorporated in SQL Agent jobs and SSIS SQL Tasks. Besides this, PTF does not just help in creating staging tables and the required indexes, but also helps in performing all subsequent steps in a sliding window scenario, like partition switching, partition merge and splits.