In the Connections node, the connection information necessary to connect to the
Source and the Destination needs to be furnished.
In configuring the Source Database node, several possibilities exist as the
Action item can be Copy or Move, and the Method item can be DatabaseOffline
or DatabaseOnLine. Also, if the method chosen is DatabaseOffline, the
SourceDatabaseFiles item describing the name and location of database files needs
to be furnished along with whether or not the SourceDatabaseFile needs to be
reattached.
In configuring the Destination Database, information similar to configuring the
Source Database should be provided, in addition to providing whether or not the
destination database is to be overwritten.
In this exercise, we will be considering the DatabaseOnline method and the action to
copy the database.
Chapter 15
[ 231 ]
Establishing Connections
1. Click on the point marked 1 along the SourceConnection item, shown in the
previous screenshot.
2. From the drop-down menu, click on
.
This brings up the SQL Management Object (SMO) Connection Manager
Editor window as shown in the next screenshot. When this window shows
up, all the controls are empty. The database pubs is on the SQL Server 2000
on the machine Computer 1. For the server name field, type-in Computer 1
(XPHTEK), as shown in the next screenshot (you may also pick it from the
drop-down menu when you click on the drop-down arrow head).
Pages:
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166