Page History

...

1. Open the IDERA SQL Admin Toolset Launchpad, and then click Partition Generator.
2. Specify the SQL Server instance or server group that contains the database you want to partition. To specify multiple SQL Servers, separate each instance name with a semicolon.
3. Click Get Partition Information.
4. To see only partitioned tables, select that option on the Table pane.
5. If you want to create a partition, complete these steps:
   1. In the Partition Details column, click Create for the table you want to partition.
   2. On the Partition Information window, specify the appropriate partition settings.
   3. To add a new data range, click Add new, and then type the range values in the new grid row. Ensure the range values are in ascending order and can be converted to the SQL data type of the partition column.
   4. Click OK.
6. If you want to edit a partition ,complete these steps:
   1. In the Partition Details column, click Edit for the partitioned table you want to update.
   2. On the Partition Information window, change the appropriate partition settings.
   3. To add a new data range, click Add new, and then type the range values in the new grid row. Ensure the range values are in ascending order and can be converted to the SQL data type of the partition column.
   4. Click OK.
7. Click OK.

IDERA SQL Admin Toolset delivers 24 essential administration tools. Learn more > >