Database Reference
In-Depth Information
Table 19-1.
Copying Objects from a Development Server to a Testing Server
Object
Locations
Method Used to Copy Object
Data warehouse database
SQL Server instance
Back up and restore database
Script database and database objects
Copy and paste
.dtsx
le
SSIS ETL package
SQL Server instance
File system
Deploy using Visual Studio
Import using SQL Server Management Studio
SSAS database
SQL Server instance
Deploy using Visual Studio
Back up and restore SSAS database
Script SSAS database and objects
SSRS reports
SSRS web service
Deploy using Visual Studio
Import using Report Manager
Upload using the SSRS web service
■
solution artifacts represent all items produced during the creation of your BI solution. These translate to files
you created in your BI projects.
Tip
Collecting the Solution Artifacts
You will need to collect all solution artifacts into one location so that they can be used and managed effectively.
Ideally this location will be some sort of source control and release management software such as Microsoft's
Team Foundation Server, but even a folder on a network share can work.
Collecting all the files you need for deployment into one shared folder is a simple technique that works well
enough for small solutions like the example project from the exercises in this topic. Each team member will be
responsible for placing their files into one central location.
Some larger solutions will have more than one team working on them. As the number of developers involved
in creating a solution goes up, so does the need to manage the folder. Developers have been known to be, shall
we say, creative as to what and when they upload to deployment folders. Set a schedule to determine when the
files must be in place and indicate which files they need to go into. Also, at some point you will need to assign
someone as an official release manager. The manager's job is to coordinate with each team to make sure that the
release is orderly and on time (aka keep the developers on track).
For the solution created in this topic, our network share will look like the one pictured in Figure
19-2
.
Here
we have placed a backup file for the data warehouse, a
.dtsx
file for the ETL process, a backup file for the SSAS
database, and a couple of SSRS
.rdl
report files. (Our examples and images are from Randal's RSLAPTOP2
computer, so remember to use your computer name instead.)
