Condividi tramite

New version of Partition Management Utility supports SQL2012, ColumnStore Indexes

  • Articolo

A new version of the Partition Management Utility for SQL Server is now available on Codeplex at https://sqlpartitionmgmt.codeplex.com/ .   This is a tool that helps you create necessary staging tables and indexes and associated check constraints, to support partition-switch operations against existing partitioned tables.   This solves the problem of keeping staging table scripts in synch when a permanent partitioned table evolves to contain new boundary values or column attributes.

The latest version adds some significant new capabilities:

  • Support for SQL Server 2012 Columnstore Indexes
  • Option to create TSQL scripts for staging stables, rather than executing DDL
  • Date constraints are now specified in a locale-independent format better supporting globalized deployments
  • Compatible with a broader range of partitioning column types

The utility is a command line tool but it also can be integrated into an SSIS process or used to generate SQL scripts that then become part of a regular "sliding window" partition management scenario.   The new version is backward-compatible with SQL Server 2005, 2008 and 2008 R2.

Comments

  • Anonymous
    December 12, 2012
    You might also check out http://ptf.codeplex.com/ which serves a similar purpose, but is plain T-SQL and thus can easily be incorporated into SQL Agent Jobs or SSIS Packages. PTF also is applicable to SQL Server 2012 and all downlevel versions that support partitioned tables.

  • Anonymous
    December 26, 2012
    This is a great update to the Partition Management Utility !! Scriptable code is really very useful.

  • Anonymous
    July 21, 2013
    I second Dusty. Really a nice utility.

  • Anonymous
    July 25, 2013
    Very useful..

  • Anonymous
    July 25, 2013
    Good one

  • Anonymous
    August 02, 2013
    nice

  • Anonymous
    August 02, 2013
    good one

  • Anonymous
    August 02, 2013
    nice

  • Anonymous
    June 03, 2015
    Thats good...

  • Anonymous
    June 07, 2015
    Excellent...!!

  • Anonymous
    July 01, 2015
    Thats interesting

  • Anonymous
    July 30, 2015
    Interesting...!!

  • Anonymous
    May 03, 2016
    Sweet