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.


Prerequisites

  • 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 file-based section.

  1. Select the original database file repository be clicking Select database. You will be prompted to select the database.
  2. 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.


  3. 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. 
  4. 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:
You must never manually edit this structure or it's files. This may corrupt the file store. You can move the file store to another location by copying the entire directory including all it's subdirectories and files.

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 file-based to database section.


  1. 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.


  2. Next, specify a new database repository file (be sure to use the extension .sqlite in all lower case) and its path in Select database.


  3. 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.
  4. 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.



What's Next?

To learn more about working with file repositories, browse these articles or search for 'repository' in the Help.