SQL Partitioner

The SQL Partitioner automates the process of scaling out your data tier. It enables you to create and maintain partitioned databases and distributed partitioned views. With its wizard-based graphical user interface you can:

• Set up query nodes or distributed partition views.
• Set up constraints on data nodes.
• Set up linked servers between nodes.
• Write all views and triggers, based on your partitioning requirements.
• Partition data from an original—nonpartitioned—source data node.

Requirements

Microsoft SQL Server 2000.

Installation

Install the SQL Partitioner by running Setup.exe from the SQL Partitioner directory on the Resource Kit companion CD. You can run Setup on either a client or a server. The computer on which you install the SQL Partitioner must have SQL connectivity and must be running SQL Server 2000 Enterprise Manager.

NOTE

---

It is very important to do an in-depth analysis of your current database before partitioning the database. See the following section.

Usage Instructions

See the documentation for the SQL Partitioner on the Resource Kit companion CD.