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.
Creating tablespaces using default or custom settings is not supported with Azure SQL Database. When using Azure SQL Database, you must use the single tablespace setting.
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. |