Filegroups setup with the CLI sqlcmd – Linux

Export required variables before running sqlcmd (and replace <...> with required values):

export DATABASE=<IMA9_DB>

export TABGROUP=<IMA9_TABFILEGROUP>

export IDXGROUP=<IMA9_IDXFILEGROUP>

export DEFAULTPATH=<DATA_FILE_PATH>

 

sqlcmd -b -m-1 -i ima9_create_filegroups.sql -U <ADMIN_USER> -P <ADMIN_PASSWORD> -S <SERVER> > ima9_create_filegroups.log