# Modify Connection Target

**URL:** <https://community.exalate.com/t/modify-connection-target/4258>\
**Category:** General Questions\
**Tags:** onpremise-jira, migrated\_question\
**Created:** [November 4, 2024, 6:42am UTC](https://community.exalate.com/t/modify-connection-target/4258 "2024-11-04T06:42:29Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![xl8bot](https://dub1.discourse-cdn.com/flex018/user_avatar/community.exalate.com/xl8bot/32/324_2.png) [@xl8bot](https://community.exalate.com/u/xl8bot)\
**Post date:** [November 4, 2024, 6:42am UTC](https://community.exalate.com/t/modify-connection-target/4258/1 "2024-11-04T06:42:29Z")

</div>

_Originally asked by Ziad Qadora on 17 June 2020 [(original question)](https://oldcommunity.exalate.com/questions/11340119)_

* * *

Hi I have refreshed my development server from production and now the connection in the dev server pointing to a production server and I want to point it to another development server. Is there away to modify the target server for the connection? This connection uses the old 3 panels sync rules so I’m trying to test it in the format we have in production.

Source: [Jira Server/Datacenter](http://community.exalate.com/pages/viewpage.action?pageId=3703137)

* * *

---

<div class="post-metadata">

**Author:** ![xl8bot](https://dub1.discourse-cdn.com/flex018/user_avatar/community.exalate.com/xl8bot/32/324_2.png) [@xl8bot](https://community.exalate.com/u/xl8bot)\
**Post date:** [November 4, 2024, 6:42am UTC](https://community.exalate.com/t/modify-connection-target/4258/2 "2024-11-04T06:42:30Z")

</div>

_Answer by Juan Grases on 17 June 2020_

Hi, you can only do it with a SQL:

```auto
UPDATE "AO_08F1AF_INSTANCE" SET "URL" = 'https://newurl.com' WHERE "ID" = $id
UPDATE "AO_08F1AF_NODE_INFO" SET "BASE_URL" = 'https://newurl.com' , "ISSUE_TRACKER_URL" = 'https://newurl.com' WHERE "ID" = $id

```

Of course replace the values with the actual new url and the ID of the instance you want to change. To know which instance is, you might query them and check the NAME column.

* * *

#### Comments:

> **Ziad Qadora commented on 17 June 2020**
>
> > Hi Juan,
> 
> Thank you for your response, I did change the URL in the database. But when I click on the remote system it still takes me to the production instance.

> **Juan Grases commented on 17 June 2020**
>
> > Hi!
> 
> I have updated the connection with another update that is necessary to fix that part of the UI. Let me know if it works.
> 
> Juan

> **Ziad Qadora commented on 17 June 2020**
>
> > Thank you again for the information. This worked, but linked issues are still pointing to production.
> 
> It seems the best thing to do to test the upgrade is to create new connection and then once testing is done, to apply any needed changes to the production.
> 
> Please let me know if you do have any other recommendations?