Was this page helpful?

Migration

    Table of contents

    Migration of DTW database

    There is no procedure due to the fact that the DB is provided by the customer.
    Check our pre-requisites/recommendations

    Here are described all the actions to done:

    1. Isolate the datawarehouse:
    • disable the SQL job nmc_DataTransfer_SQL
    • disable the SQL job nrs_DataTransfer
    1. Move the database to the new instance or Install the datawarehouse with the two scripts (newtest) with an DBA / DBO access rights

    In case the DWH is on a new machine, run on the new machine (SQL server): EXEC sp_change_users_login 'Update_One', 'NewtestDWH', 'NewtestDWH';

    Also, check that the NewtestDWH user has the 'dbowner' role.

    1. NMC part

    Open and modify C:\Newtest\SSIS\DataTransfer SQLSERVER\DataTransfer_SQL.dtsConfig

    reference to undefined name 'syntax' Une exception de type 'MindTouch.Deki.Script.Runtime.DekiScriptUndefinedNameException' a été levée. (click for details)

     

    1. NRS part

    Provider=MSOLAP.3;Data Source=NEW_IP_ADDRESS_DWH\Newtest;Initial Catalog="Newtest Reporting"

    • Run SQL Server Management Studio (Analysis Services), change the Datasource

    Provider=MSOLAP.3;Data Source=NEW_IP_ADDRESS_DWH\Newtest;Initial Catalog="Newtest Reporting"

    • Run SQL Server Management Studio (Database)

    Delete the linked server DTW_NEWTEST (localhost\NEWTEST\Server Objects\Linked server\)

    Create the linked server with the appropriate information and choose "Be made using this security context" with the login NewtestDWh and the password NewtestDWh

    1. Enable the 2 jobs and check their state after one run.
    Was this page helpful?
    Tag page (Edit tags)
    • No tags
    Page statistics
    3427 view(s), 4 edit(s) and 2442 character(s)

    Comments

    You must login to post a comment.

    Attach file

    Attachments