Creating Table Partitions for a Microsoft SQL Server Database
To create table partitions for a Microsoft SQL Server database, follow the instructions in this section.
To run the partition-creation script:
| 1. | Stop the FlexNet Manager for Engineering Applications Admin and Reporting servers, if they are running. |
| 2. | Open the script file, located at the following location: |
<reporting_install_directory>/site/samples/db/PartitionNonPartitionedTableSQLFinal.sql
| 3. | Connect to the FlexNet Manager for Engineering Applications Reporting database in Microsoft SQL Management studio, then copy and paste the contents of the script into the SQL query window. |
| 4. | Execute the complete script. |
| 5. | Review the output to check for any errors. |
| 6. | Start the FlexNet Manager for Engineering Applications Reporting and Admin servers. |