sys_dwh

Description

  • contains only synonyms to connect a repository database and a dwh database

  • connect repo datatabase to dwh database using synonyms executing the stored procedure config.usp_connect_database - P

    Example 1. connect repository database to the dwh database 'WideWorldImporters'
    EXEC [config].[usp_connect_database]
@dwh_database_name = 'WideWorldImporters'
    sql

Objects