Show/Hide Toolbars

Reporting Services CMD

Command: CreateAll

 

creates a folder, reports, shared datasets, resources and models

 

SSRS Version:

 

2000, 2005 (N), 2005 (I), 2008 (N), 2008 (I),2008r2(N), 2008r2(I), Azure

 

(N)=Native

(I)=Integrated

 

 

Syntax

 

CreateAll   [Folder] [/F:Folder] [/O] [/H] [/D:Description] [/B:Folder]

CreateAll   [/?] displays help

 

 

Parameters

 

 

   [Folder]           Name of the folder on the PC to upload items from

   [/F:Folder]        Location to deploy items to on the report server

                      if not specified current folder is used

   [/O]               Overwrite resource if it exists

                      if not specified file name is used

   [/H]               Hide report

   [/D:Description]   Description of report

   [/B:Folder]        Backup original resource before uploading new report

   [/BO:Folder]       Backup original resource and overwrite (if exists)

   [/BD:Folder]       Backup original resource to Folder\Date

                      if resource exists the resource created is resource_<num>.rdl

   [/BF:Folder]       Creates folder structure and backup original resource

                      if resource exists the resource created is resource_<num>.rdl

   [/BFO:Folder]      Creates folder structure and backup original resource

                      overwrite backup file

   [/BFD:Folder]      Creates folder structure+DATE and backup original resource

 

                      if resource exists the resource created is resource_<num>.rdl

   [/BDF:Folder]      Creates folder DATE+structure and backup original resource

 

                      if resource exists the resource created is resource_<num>.rdl

   [/S]              

 

                      Nobackup folder is created if it does not exist

 

 

Examples

 

 

Upload all items from the folder c:\ssrsDeploy to the report server folder \ssrstest

 

 createall /f:\ssrstest c:\ssrsDeploy

 

 

 

Note the above example will not overwrite existing items. Use /O for overwrite

Upload all items from the folder c:\ssrsDeploy to the report server folder \ssrstst

 

 createall /f:\ssrstest c:\ssrsDeploy /o

 

 

 

 

Before overwriting you can backup existing items.

 

Upload all items from the folder c:\ssrsDeploy to the report server folder \ssrstst

backup existing items before overwriting on the report server use /b:<folder on PC>

 

Note if the backup item already exists it will not be overwritten but a new file created on the PC

eg sales.rdl file exists in the backup folder.

 

If this command is rerun there will be another file called sales-1.rdl.

Rerun again sales-2.rdl and so on

 

 createall /f:\ssrstest c:\ssrsDeploy /o /b:c:\backup

 

 

 

 

If you want to overwrite the backup item and not create multiple backup copies

used the command /bo:  (backup overwrite) not /b:

 

 createall /f:\ssrstest c:\ssrsDeploy /o /bo:c:\backup

 

 

 

If you want to upload all items in the folder and sub folders use /s

 

 createall /f:\ssrstest c:\ssrsDeploy /s

 

 

 

Recommended option to deploy and backup existing items use /s and /bf:

 

 createall /f:\ssrstest c:\ssrsDeploy /o /bf:c:\backup /s

 

 

 

 

Date time can also be added to the backup folder name

 

there are 2 options

 

1. foldername\<date>  (use /bfd = backup folder date)

 

         createall /f:\ssrstest c:\ssrsDeploy /o /bfd:c:\backup /s

 

 

 

2. <date>\foldername  (use /bdf = backup date folder)

 

         createall /f:\ssrstest c:\ssrsDeploy /o /bdf:c:\backup /s

 

 

 

 

Remarks

 

 

 

See Also

CreateAll        - Upload from disk one or more reports, models, data sources
CreateLinkRpt- Create linked report
CreateModel- Upload from disk one or more models
CreateDS        - Create data source
CreateRes- Upload from disk one or more resources
CreateRpt- Upload from disk one or more reports