Chatta subito con l'assistenza
Chat con il supporto

erwin Evolve 2024.0.0 - Installation Guide

Create a Networked Database

This section provides instructions for users who wish to set up a new Evolve Repository on SQL Server.

 

The details in this section are intended to be used by an experienced database administrator - you should not attempt to perform these tasks if you are not an experienced SQL user.

Before You Begin

Before You Begin

It is a prerequisite of this guide that you have already installed Microsoft SQL Server and that it meets the Evolve Suite System Requirements. The database should be on a different computer to the one which you will install the Evolve Suite client software on.

Get The SQL Script Files

Get The SQL Script Files

We have provided a set of SQL scripts which should be used when configuring the database, so please ensure you have these ready when preparing to set up the database. The script files are available from Quest website. The website files are zipped in files titled:

l erwin EvolveSuite_MSSQLScriptFiles_****_*_*_*.zip

Instructions for SQL Server

Instructions for SQL Server

The following table shows high-level steps for setting up the Evolve Repository on Microsoft SQL Server and should only be performed by a SQL Server administrator.

1

Create a new SQL Instance

Note the name as: [database_name]

Make sure the collation is: Latin1_General_CI_AS

2

Run SQL Script Files

Run each of the supplied SQL Script files against your database, in the following order:

1.CreateMSSQLSchema.sql

2.CreateMSSQLCopyModelProcedure.sql

3.CreateMSSQLDeleteModelProcedure.sql

4.GetNextId.sql

5.CreateCasewiseRWRole.sql

6.GrantAccessToSchemaForCasewiseRWRole.sql

3

Create a new login

Create a new login specifically for Evolve Suite use. We recommend using Windows Authentication, however you can also use SQL Authentication if you wish.

Note the login name as [login_name]

For Windows Authentication

Make sure the User Group you assign to the login includes all users who need to access Evolve Suite.

For SQL Authentication

Note the password as [login_password]

4

Create a new user

Create a new Database User for the Evolve Database [database_name] and link the user to the login [login_name] you just created. Set Owned Schemas and Membership (Role Members) to CasewiseRW

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione