Table Storage locations can be changed through the Storage tab on a table's Properties dialog but they can also be changed in bulk by using the following process:
- Double-click on the desired object group in the left pane. This will display all the tables in that group in the middle pane.
- Select the tables that you wish to change the storage for using the standard Windows selection.
- Right-click to bring up a menu and select Storage.
- On the Target Location Selection dialog, select the desired Target Location for the change.
- Double-click on the desired object group in the left pane. This will display all the tables in that group in the middle pane.
- Double-click on the desired object group in the left pane. This will display all the tables in that group in the middle pane.
- Follow the next dialogs to complete the bulk storage change.
- Please note that all procedures from the affected tables will need to be manually changed or regenerated after a bulk storage change.
Please note that changing the Storage for Dimension and Fact tables needs to be handled very carefully because artificial key relationships between Dimension and Fact could become out of sync.Recreating Fact tables and large Dimension tables might take a considerable amount of time.