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.
4 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 :)
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]"