My collegue installed Dell OpenManage and now the complete package is installed on the system drive. I, however, would like to move the repository data to another, larger, drive (e.g. a data drive) to be sure the system drive isn't filled with updates completely.
Is there a way to move the repository or do i have to reïnstall Dell OpenManage?
ITA stores all of it's data in a SQL database. By default this is an MSDE / SQL Expres instance on the same server. All you will need to do is delete all current packages in the ITA Software Updates screen in the gui, change the pointer in the database and re-import the updates.
1. Delete all packages from the ita gui, manage > software updates, left pane under IT Assistant Repository 2. Delete the package files from the default location on the C drive. 3. Change the repositoryLocation field in the repository table. The following TSQL example sets the repository location to e:\dell\ita\ItaRepository (note the double backslash at the lowest level!). To change the data you can use the SQL CLI called OSQL. Osql should be in the path on your ITA server, you can run osql -? to check. Copy the code below and paste it into notepad.
/** change ITA Software Update Repository Location **/ use itassist go SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO update repository set repositoryLocation = 'e:\dell\ita\\ItaRepository' where RepositoryName = 'IT Assistant Repository' GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO
/*****end****/
4. Change where you want the repository to be (the location in line 9) and save it as 'update_repository_loc.sql'.
5. Run it with osql -i update_repository_loc.sql -E The output should look like this:
I followed these steps, moving the repository to a storage server.
The repository location correctly displays in ITA, however, when importing packages in ITA the repository folders are empty. There are no error messages in ITA or in the Event Logs.
Which version of IT Assistant are you using? I think there was a slight change in the folder structure of Repository when Online Synchronization feature got introduced... (there are 2 sub-folders under the Repository - ITA and Online) and corresponding 2 entries in the database.
I have attempted the method listed here. I am running ITA 8.2.0 and the repository shows the right path in ITA now but when I try to import I get this error:
Error Code: 1904
Error message: e:\dell\ita\ItaRepository is not a supported repository location
DELL-JamesC
206 Posts
481
0
Posted December 18th, 2006 19:00
2. Delete the package files from the default location on the C drive.
3. Change the repositoryLocation field in the repository table. The following TSQL example sets the repository location to e:\dell\ita\ItaRepository (note the double backslash at the lowest level!). To change the data you can use the SQL CLI called OSQL. Osql should be in the path on your ITA server, you can run osql -? to check. Copy the code below and paste it into notepad.
use itassist
go
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
update repository
set repositoryLocation = 'e:\dell\ita\\ItaRepository'
where RepositoryName = 'IT Assistant Repository'
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
Message Edited by DELL-JamesC on 12-18-200603:03 PM