Owner's Manual

278 Utilities in Dell OpenManage IT Assistant
Detach Database
• Command: dcdbmng /R or dcdbmng /r
• Description: Detaches the attached database file from the SQL Server
2005 Express
Edition SP2 or the SQL 2005 Server SP2.
NOTE: The detached database file remains in the location from where it was
attached to the SQL Server 2005 Express Edition SP2 or the SQL Server 2005 SP2.
Export Table
• Command: dcdbmng /E tablename filename or dcdbmng /e tablename
filename
• Description: Exports the data in the table specified by tablename to the
flat text file specified by
filename . If the flat text file does not exist, the
utility creates it. If
filename does not include path information, the utility
creates the file in the local directory.
Export Database
• Command: dcdbmng /X path or dcdbmng /x path
• Description: Exports data from all tables in the database to flat text files in
the location specified by path.
NOTE: The utility creates the files in the location specified by path in the format of
tablename.txt.
Import Table
• Command: dcdbmng /I tablename path [migrate] or dcdbmng /i tablename
path [migrate]
• Description: Imports data to the table specified by tablename from the flat
text file specified in
path .
Import Database
• Command: dcdbmng /M path or dcdbmng /m path
• Description: Imports data to all tables in the database from flat text files in
the location specified by
path .