2. Click on the SourceDatabaseName drop-down handle to bring up the list
of databases on the SQL 2000 Server, as shown in the following screenshot.
You may verify if a database pubs does exist on this server. Although
pubs is chosen from this list, you can use any other database that exists on
your server.
3. Click on pubs in the drop-down list.
This updates the information in the Transfer Database Task Editor window.
Although the SourceDatabaseFiles was grayed out, the file name and
location name are still retrieved. At present, the information is read-only. The
grayed out information is incomplete as it was mentioned that this task is
error prone (perhaps for this version). Follow the steps to retrieve the complete
information.
Package that Transfers a Database from One SQL Server to Another
[ 234 ]
4. Change the method to DatabaseOffline by clicking along the line item, and
choosing it from the drop-down menu.
This enables the SourceDatabaseFiles to be modified.
5. Click on an empty area along the SourceDatabaseFiles.
This will display an ellipsis button.
6. Click on the ellipsis button
This brings up the Source Database Files window.
7. Click on the ellipsis button to the right of the Network File Share list
heading.
This opens the Browse for folder window where you need to locate the
shared data folder PubsData on Computer 1 you created earlier.
8. Click on PubsData and click on the OK button on the Browse the Folder
window.
Pages:
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168