Database Reference
In-Depth Information
the server and a process command against the affected objects. In many cases, this
is not what you want to do as the processing part can take a very long time when
you have a large database as the relational source. Instead, you probably want to
schedule the processing step to happen at a later stage.
It is possible to control what happens when you click on
Deploy
in the project set-
tings in SQL Server Data Tools. You can find the options if you right-click on the pro-
ject name in the
Solution Explorer
window and then choose
Properties
.
We will cover all the processing options later in this chapter, but if you want to control
when processing should be done, you change
Processing Option
to
Do Not Pro-
cess
. There are a couple of other options that control the deployment of the object.
Transactional Deployment
is another option. It specifies if the deployment and any
processing should be executed as one transaction. You may want to deploy changes
to a database or cube that these changes should only be committed, if the process-
Search WWH ::
Custom Search