Simple question, I built a query using query builder to check some data in our production environment. I’d like to use the same one in our pilot environment. Usually to do this I right click on the tab and select change connection. Not sure why, but for some queries, this one included, it doesn’t appear, not even greyed out. Am I doing something wrong?
Other than copying the SQL, is there a way to port this to a different connection?