We are moving the SQL database from one server to another. How do we change the connection string? Appreciate if someone can post the steps to migrate the DB server.
Thank you.
Best Reply
Hello Shashi,
as this is not a trivial procedure better to look it up here:
https://docs.aris.com/latest/yay-technical-help/en-us/69998-move-the-database-management-system.html#UUID-4b9c001a-9778-b2af-22ec-88feb8a706da
"2. Stop all runnables, except the zoo runnable (service registry)."
A running service registry is needed in order to upate the db service
Regards, Martin
7 Replies
Thank you, Veronika!
I guess the steps are 1. Stop all, 2. Update external ... 3. Startall
lmk
yes, that's right :) only, that you don't have to stop all. Only abs, if I am not mistaken :) but it doesn't hurt to stop all :)
Hello Shashi,
as this is not a trivial procedure better to look it up here:
https://docs.aris.com/latest/yay-technical-help/en-us/69998-move-the-database-management-system.html#UUID-4b9c001a-9778-b2af-22ec-88feb8a706da
"2. Stop all runnables, except the zoo runnable (service registry)."
A running service registry is needed in order to upate the db service
Regards, Martin
Hi Martin,
Thanks for your help. After running the update command and trying to run Startall we are seeing the following error in the log
ping Level 1 failed and ping level 2 failed.
log file attached. Appreciate your help.
Sorry Shashi, the log does not give me a clue, particularly without any more context. Last time I updated a db service myself was on 10SR20 years ago. Better to ask Aris support.
Regards, Martin
Veronika Ellermann on
it is bascially a simple command:
update external service db0000000000 url="jdbc:sqlserver://[IP]:[Port];DatabaseName=[DatabaseName];encrypt=false;user=[DBUser];password=[pw]"