Owner's Manual

Installing, Uninstalling, and Upgrading Dell OpenManage ITAssistant 79
Deploying the IT Assistant Database to the Remote Database
On the management station, stop the IT Assistant Connection Service and
the IT Assistant Network Monitoring Service from the Service Control
Manager. This stops the IT Assistant services from accessing the local
IT Assistant database. Ensure that no other program is accessing the local
IT Assistant database. If a database program such as the SQL Server’s
Enterprise Manager and/or Query Analyzer is running, close the program or
ensure that the program is not accessing local IT Assistant database.
On the
management station , detach the IT Assistant database from the local
SQL Server by running the IT Assistant database management utility on the
command line.
Run the following command from the IT Assistant bin directory:
dcdbmng /r
When the IT Assistant database has been successfully detached, the
Detach database dialog box is displayed.
To ensure that the database is detached, perform the following steps:
1
Start the ODBC Data Source Administrator by clicking the Start button.
Select
Settings   Control Panel  Administrative Tools  Data Sources
(ODBC)
.
2 Select the System DSN tab.
Ensure that there no system data source with the name
ITAssist
(local IT Assistant database).
If such a system data source exists, click
Remove to delete this data source.
On the management station, navigate to the Data folder under the SQL
Server installation directory. By default, the installation path is C:\Program
Files\Microsoft SQL Server\MSSQL. Copy the IT Assistant database file,
ITAssist_Data.mdf to a location on the remote database system. For this
example, let us consider the desired path to be DB_PATH.
On the remote database system, attach the database file, ITAssist_Data.mdf
located in DB_PATH to the local SQL Server. You can do this by executing
the following SQL statement against the local master database:
exec sp_attach_single_file_db @dbname=
'ITAssist',@physname='DB_PATH\ITAssist_Data.mdf'