File vs server repository

28th August, 2018
Applies to: 5.x versions, Article available also for: 9.x (current), 8.x, 7.x, 6.x
You are looking at documentation for an older release.
Switch to the documentation for Dataedo 9.x (current).

Server repository

Dataedo server repository is a predefined SQL Server database. It is a regular database that is created by Dataedo with mostly tables to store metadata.

Choose server repository if

  1. Whenever you can
  2. Want to work in multi-user environment
  3. Have access to SQL Server instance (you may use free SQL Server Express edition)

Server repository is recommended option

File repository

File repository is a SQL Server Compact database that is stored as a file on your disk. It has almost identical schema as server repository.

Differences from server

  1. No authentication
  2. No support for concurrent work
  3. Slow performance using in network environment

Choose file repository if

  1. You evaluating Dataedo and can't or don't want to install a server and a repository database
  2. Don't have access to SQL Server instance

Notes

It is possible to migrate from file to server with a little effort.

Found issue with this article? Comment below
0
There are no comments. Click here to write the first comment.