mdf","C:\Program Files\Microsoft SQL Server\MSSQL.4\
MSSQL\data","";"pubs_log.ldf","C:\Program Files\Microsoft SQL
Server\MSSQL.4\MSSQL\data",""
2. After rectifying the Destination Folder information, click on the OK button
on the Destination Database Files window.
This updates the Destination Database Files information on the Transfer
Database Editor.
3. Click on the button OK on the Transfer Database Task Editor.
This completes the configuration of the Transfer Database Task.
Step 4: Building the BI Project and Executing
the Package
1. Right-click the Ch 15 project in the Solution Explorer, and click on Build in
the drop-down menu. After the Build succeeds, click on the TransferDb.
dtsx and execute the package.
After the package is run, the Create a database from SQL 2000 to SQL 2005
task turns yellow then green, and will have copied the pubs database to the
SQL Server 2005. This may take a little longer time than in the previous chapter
runs.
Now, it is time to verify the success of this task.
2. Open the SQL Server 2005 Management Studio and the SQL Server 2005
Express, and then expand the Database node as shown.
3. Review the database objects by expanding each node where necessary.
You may have to carry out a server refresh to see the pubs database. Only the
Table and Stored procedure are shown expanded in the screenshot.
Chapter 15
[ 237 ]
Package that Transfers a Database from One SQL Server to Another
[ 238 ]
Summary
This chapter described the usage of the Transfer Database Task wherein the pubs
database on a networked SQL Server 2000 was copied over to the SQL Server 2005.
Pages:
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170