Add the --tablespaceoption switch to configure the tablespace creation process. This switch allows you to specify whether tablespaces are created using default settings, custom settings, or the single tablespace setting.
When creating tablespaces with Azure SQL Managed Instance only the Size and Growth will be used, File path will be ignored.
When using the --tablespaceoption switch, you must apply one of the following qualifiers:
|
Qualifier |
Description |
|---|---|
|
default |
Tablespaces are created using the default values for initial size and growth increment. See Using Default Settings for more information. |
|
single |
All tables and indexes are configured to reside in the primary tablespace. See Using The Single Tablespace Setting for more information. |
|
custom |
Tablespaces are created using values specified by the user in either the command line or a JSON configuration file. See Using Custom Settings for more information. Note:
When using the custom qualifier, the initial size, growth increment, and location information must be specified for every DBSpace. |