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:
- Isolate the datawarehouse:
- disable the SQL job nmc_DataTransfer_SQL
- disable the SQL job nrs_DataTransfer
- 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.
- 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)Callstack:
at NEWTEST/DWH_-_Datawarehouse/Installation_-_Updates/Migration
MindTouch.Deki.Script.Runtime.DekiScriptUndefinedNameException: reference to undefined name 'syntax' Une exception de type 'MindTouch.Deki.Script.Runtime.DekiScriptUndefinedNameException' a été levée.
à MindTouch.Deki.Script.Compiler.DekiScriptExpressionEvaluation.Visit(DekiScriptVar expr, DekiScriptExpressionEvaluationState state)
à MindTouch.Deki.Script.Expr.DekiScriptVar.VisitWith[TState,TReturn](IDekiScriptExpressionVisitor`2 visitor, TState state)
à MindTouch.Deki.Script.Compiler.DekiScriptExpressionEvaluation.Evaluate(DekiScriptAccess expr, DekiScriptExpressionEvaluationState state, Boolean evaluateProperties)
à MindTouch.Deki.Script.Compiler.DekiScriptExpressionEvaluation.Visit(DekiScriptAccess expr, DekiScriptExpressionEvaluationState state)
à MindTouch.Deki.Script.Expr.DekiScriptAccess.VisitWith[TState,TReturn](IDekiScriptExpressionVisitor`2 visitor, TState state)
à MindTouch.Deki.Script.Compiler.DekiScriptExpressionEvaluation.Visit(DekiScriptCall expr, DekiScriptExpressionEvaluationState state)
à MindTouch.Deki.Script.Expr.DekiScriptCall.VisitWith[TState,TReturn](IDekiScriptExpressionVisitor`2 visitor, TState state)
à MindTouch.Deki.Script.Compiler.DekiScriptExpressionEvaluation.Visit(DekiScriptSequence expr, DekiScriptExpressionEvaluationState state)
à MindTouch.Deki.Script.Expr.DekiScriptSequence.VisitWith[TState,TReturn](IDekiScriptExpressionVisitor`2 visitor, TState state)
à MindTouch.Deki.Script.Compiler.DekiScriptExpressionEvaluation.Visit(DekiScriptReturnScope expr, DekiScriptExpressionEvaluationState state)
- 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
- Enable the 2 jobs and check their state after one run.
Comments