Documentation

Table of Contents:


    Creating Azure SQL repository

    Applies to: 9.x (current), Article available also for: 8.x, 7.x

    Note that this is a beta feature. If you run into any issues, we’d be happy to hear about them.

    Administration Console connection is not currently supported for Azure SQL repositories.

    Current implementation of Azure repository requires manual setup. In future releases this process will be included in our repository creator.

    Create an Azure SQL Database

    To create a repository in Azure, first create an Azure SQL database. Find out more here.

    New Azure database

    Make sure your IP has access to the database by clicking Set server firewall when database creation finishes.

    Azure firewall

    Click Add client IP, then Save to add your IP to the whitelist.

    Add IP to firewall

    After clicking your database name, you can copy its hist address by clicking an icon to the right of Server name field.

    Copy the server name

    Repository creation

    Connect to the database with SQL Server Management Studio (SSMS) using server name copied above.

    Connect with SSMS

    Right click your database, then choose New query.

    New SSMS query

    Find the repository creation script named create_repository.sql in Dataedo folder (default path is C:\Program Files (x86)\Dataedo\Scripts).

    Create script location

    Copy the script to SSMS and run it by pressing the F5 key.

    Create repository on Azure

    You should see a Query executed successfully message.

    SSMS query successful

    User creation

    If you're going to connect to the repository with previously created user, you can skip this step.

    Each person connecting to the repository will need to have a database user.

    Create database users as usual through CREATE USER command in SSMS. Find out more details here.

    The easiest way would be to create a new login in master database of the server your repository is on: CREATE LOGIN new_login WITH password='P@ssword';

    Then, switch database to the repository and create a new database user: CREATE USER new_user FROM LOGIN new_login;

    After creating a user, you need to add it to the USERS role in repository database: EXEC sp_addrolemember 'USERS', 'new_user';

    The user can now connect to the repository with login and password specified in the CREATE LOGIN command..

    Connecting to the repository

    Run Dataedo, and double click the Connect to the repository button.

    Connect button

    Fill the connection details - host is the server name you've previously copied.

    Connect to Azure

    To add a Trial or Pro license, after connecting, click the Enter key in the ribbon:

    Enter key button

    Paste the key to the text box and click OK.

    Enter key box

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

    By continuing to use our website, you consent to the use of cookies in accordance with our Privacy Policy (updated 28-04-2020).
    Accept