SQL Partition Manager
|
Improves performance and manageability in large SQL Server databases. SQL Partition Manager is a solution for managing SQL Server partitioned tables. If you work with large databases, SQL Partition Manager greatly simplifies the maintenance of partitioned tables.
You can create new partitions, delete, split or merge them, and at the same time avoid potential partitioning errors. Moreover, this application will partition existing tables with data and will turn them into manageable chunks of data that can be easily moved in and out.
SQL Partition Manager enables you to do the following:
1. Convert existing nonpartitioned tables with data to partitioned tables
2. Split and merge table partitions
3. Switch partitions from one partitioned table to another
4. Switch in standalone tables as new partitions
5. Create and manage partition functions and partition schemes
6. Review and modify the partition objects in a database
How to Partition Tables with Data:
1. The situation
2. Connect to a database
3. Specify a table for the partition
4. Define the Partition Key
5. Specify wich indexes should be aligned
6. Specify the partition scheme
7. Specify partition ranges
8. Map partitions to filegroups
9. Start partitioning
10. After the partitioning
Requirements:
* .NET Framework
The license of this software is Free Trial Software, the price is $199.00, you can free download and get a free trial.