As described in Creating a File Repository, there are currently two possible formats for the repository storage solution - database or file-based. This article describes how to convert from one to the other.
- The SystemWeaver server using the existing file repository must be stopped. See Stopping and Starting a SystemWeaver Server.
- It is always a good idea to create a copy of the original repository as an extra backup that you can easily revert to if something unexpected should happen.
To begin, open the swDatabaseManager application and click on the File Repository tab.
Converting From Database to File-based
If you are using a database format for the file repository and want to switch to using a file-based file repository, use the Convert from database to filebased section.
- Select the original database-formatted file repository be clicking Select database. You will be prompted to select the database.
- Next, specify where the new file-based repository should be located by clicking Select directory. You will be prompted to select the location of, and name of, the new directory where you want the repository copy to be placed.
- After you have specified the old and new database locations respectively, click on Convert. This will start the process of copying the files from the original repository to the new repository. This may take a while.
- When it is completed, the log window to the right will indicate the number of files copied:
If you navigate out to the directory, you should find a data folder and an index.db database file:
Converting From File-Based to Database
If you are using a file-based format for the file repository and want to switch to using a database file repository, use the Convert from filebased to database section.
- Select the original file-based file repository directory be using Select directory. You will be prompted to select the directory. Click Select folder when located in the folder where you can view the data folder.
- Next, specify a new database repository file (be sure to use the extension .sqlite in all lower case) and its path in Select database.
- After you have made your selections, click on Convert. This will start the process of copying the files from the original file-based repository to the new database repository. This may take a while.
- When it is completed, the log window to the right will indicate the number of files copied.
If you navigate out to the directory, you should find the new .sqlite repository database file.
To learn more about working with file repositories, browse these articles or search for 'repository' in the Help.