Skip to main content

Create a server repository manually

Usually, the Dataedo server repository is created automatically with a wizard. All you need to do is provide an SQL Server instance and user credentials with sufficient privileges to create a new database.

You may, however, prefer to have this process under control. You can do this by following a few simple steps (use the database tools of your choice):

  1. Create an empty database. The default name is "dataedo" but it can be any valid database name.

  2. Connect to the database and run a script provided with the Dataedo installation. This script contains a set of DDLs and insert statements that will create the repository schema and insert sample documentation. It can be found in your Dataedo installation folder: [installation_path]\Scripts\create_repository.sql.

  3. Run the Dataedo Administration Console, connect to the newly created repository using the same credentials you used in point 1 (or any user with the db_owner role in the repository), and assign or create users as needed.

After following these steps, you can connect to your new repository by providing server and database connection details with the credentials of the user you granted access to in step 3.