Using a lookup or constant for database connection
Comments
-
[font=Roboto, Arial, Helvetica, sans-serif]Is there a way to reference a lookup value or constant in a connection string? We have multiple environments and the connection string to a database will differ in database server and account information. We want to set it up in a way to prevent the connection string to be overwritten when we migrate updates from server environment to server environment.[/font]
-
Hello,
We dont have the ability to reference a lookup value in a connection string; however, after your first import, any subsequent imports respect the current connection string and is not overridden because a connection string is considered a system constant. There shouldnt be anything you need to do to prevent any changes to the connection string. Let us know if you have any other questions.