Table of Contents:
Creating a server repository manually
Usually, 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 following a few simple steps (use database tools of your choice):
- Create an empty database. A default name is "dataedo" but it can be any valid database name.
- Connect to the database and run a script provided with Dataedo installation. This script contains a set of DDLs and inserts statements that will create repository schema and insert sample documentations. It can be found in your Dataedo installation folder: [installation_path]\Scripts\create_repository.sql.
- Run Dataedo Administration Console and connect to the newly created repository using the same credentials you used in point 1 (or any user with 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 credentials of the user you granted access in step 3.