This server
uses the SQL Server authentication; type-in the User name and Password,
as shown (you need to use those appropriate for this networked server). The
connection can be tested as well.
3. After the Test succeeds, click the OK button on the Microsoft Visual Studio
2005 window and the SMO Connection Manager Editor window.
Package that Transfers a Database from One SQL Server to Another
[ 232 ]
This completes the connection to the source and a SMO Connection
Manager component is added to the Connection Managers' page of
the Canvas.
4. Click on location 2, along the destination connection, and as done in the
previous case, enter server name and authentication information (Windows
authentication this time) as shown in the next screenshot. Note that the fully
qualified name of this server is Computer 2\SQLExpress (Hodentek/SQL Express).
5. Click on the OK button on the Microsoft Visual Studio window, as well as
the SMO Connection Manager Editor window.
This adds another SMO Connection Manager control to the Connection
Managers' page on the Canvas. The Connections window of the Databases
list item of the Transfer Database Task Editor now gets changed, as
shown below.
Chapter 15
[ 233 ]
Configuring the Source Database Node
1. In configuring the Source Database, choose Copy for the Action item
from the drop-down and choose DatabaseOnLine from the Method
item's drop-down. This grays out the SourceDatabaseFiles and the
ReattachSourceDatabase items.
Pages:
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167