# How to connect Development version to Live Version database?

**URL:** <https://forum.bubble.io/t/how-to-connect-development-version-to-live-version-database/224040>\
**Category:** Questions\
**Created:** [September 13, 2022, 7:57am UTC](https://forum.bubble.io/t/how-to-connect-development-version-to-live-version-database/224040 "2022-09-13T07:57:00Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![ZedtronicsAdmin](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/zedtronicsadmin/32/142390_2.png) [@ZedtronicsAdmin](https://forum.bubble.io/u/ZedtronicsAdmin)\
**Post date:** [September 13, 2022, 7:57am UTC](https://forum.bubble.io/t/how-to-connect-development-version-to-live-version-database/224040/1 "2022-09-13T07:57:00Z")

</div>

Hello Everyone,  
I am quite new to bubble…

I need to test few things with my live database since it has more records than my dev database  
I don’t want to deploy every time…

**Is there is any way to connect development version to Live version database?**

Thanks a lot for your help 🙏

---

<div class="post-metadata">

**Author:** ![mani2726](https://avatars.discourse-cdn.com/v4/letter/m/94ad74/32.png) [@mani2726](https://forum.bubble.io/u/mani2726)\
**Post date:** [September 13, 2022, 8:06am UTC](https://forum.bubble.io/t/how-to-connect-development-version-to-live-version-database/224040/2 "2022-09-13T08:06:27Z")

</div>

Hi @ZedtronicsAdmin ,  
Please refer below screen will help you,  
Bubble app editor → Data → App Data  
You will see the text “Copy & Restore Database” like below

 ![image](https://us1.discourse-cdn.com/bubble/original/3X/3/1/3161e24644c1a49097a1e736fa1f629de2a56ca0.png)  
Click this, you will get below screen.  
 ![image](https://us1.discourse-cdn.com/bubble/original/3X/f/9/f95cb8bf25c3db1f79d9710efdc589577628e726.png)  
You can copy the live database to the dev database without deployment.

---

<div class="post-metadata">

**Author:** ![ZedtronicsAdmin](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/zedtronicsadmin/32/142390_2.png) [@ZedtronicsAdmin](https://forum.bubble.io/u/ZedtronicsAdmin)\
**Post date:** [September 13, 2022, 8:33am UTC](https://forum.bubble.io/t/how-to-connect-development-version-to-live-version-database/224040/3 "2022-09-13T08:33:18Z")

</div>

@mani2726 Thanks for the response 👍

This will overwrite my existing dev database  
Well i don’t want to overwrite it because my live database records are in thousands (10k).

**There is no other way to connect development version to live database**

---

<div class="post-metadata">

**Author:** ![vajihahmed](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/vajihahmed/32/147879_2.png) [@vajihahmed](https://forum.bubble.io/u/vajihahmed)\
**Post date:** [September 13, 2022, 8:46am UTC](https://forum.bubble.io/t/how-to-connect-development-version-to-live-version-database/224040/4 "2022-09-13T08:46:07Z")

</div>

@ZedtronicsAdmin 👋

> [@ZedtronicsAdmin](#):
>
> There is no other way to connect development version to live database

I don’t think it’s possible to do that…

We can wait for other experts opinion too @mikeloc @adamhholmes

---

<div class="post-metadata">

**Author:** ![adamhholmes](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/adamhholmes/32/100510_2.png) [@adamhholmes](https://forum.bubble.io/u/adamhholmes)\
**Post date:** [September 13, 2022, 9:17am UTC](https://forum.bubble.io/t/how-to-connect-development-version-to-live-version-database/224040/5 "2022-09-13T09:17:37Z")

</div>

You can’t access your live database directly from your dev app…

You _can_ call the data API of your live site from your dev app though, if you really need to access data from the live DB in your dev app… but it will mean setting up different data sources wherever you need them, so I’m not sure it’s a great idea… (also you’re limited to 100 results returned via the API, so you’d need to set up a way to deal with that limitation)…

---

<div class="post-metadata">

**Author:** ![ZedtronicsAdmin](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/zedtronicsadmin/32/142390_2.png) [@ZedtronicsAdmin](https://forum.bubble.io/u/ZedtronicsAdmin)\
**Post date:** [September 13, 2022, 9:40am UTC](https://forum.bubble.io/t/how-to-connect-development-version-to-live-version-database/224040/6 "2022-09-13T09:40:07Z")

</div>

@vajihahmed @adamhholmes  
Thanks 👍

> [@adamhholmes](#):
>
> you’re limited to 100 results returned via the API

if this the case then i will overwrite my dev database…  
Thanks once again 👍

---

<div class="post-metadata">

**Author:** ![viquarahmed07](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/viquarahmed07/32/145585_2.png) [@viquarahmed07](https://forum.bubble.io/u/viquarahmed07)\
**Post date:** [September 13, 2022, 9:47am UTC](https://forum.bubble.io/t/how-to-connect-development-version-to-live-version-database/224040/7 "2022-09-13T09:47:30Z")

</div>

@ZedtronicsAdmin 👋  
if the dev database is really important to you  
then you can export all the tables as CSV before overwriting…

![Screenshot 2022-09-13 at 11.46.38](https://us1.discourse-cdn.com/bubble/original/3X/e/7/e730aa9babba82cf6a5a98890ef347c410d68e17.png)

later on you can import it…

---

<div class="post-metadata">

**Author:** ![ZedtronicsAdmin](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/zedtronicsadmin/32/142390_2.png) [@ZedtronicsAdmin](https://forum.bubble.io/u/ZedtronicsAdmin)\
**Post date:** [September 13, 2022, 9:48am UTC](https://forum.bubble.io/t/how-to-connect-development-version-to-live-version-database/224040/8 "2022-09-13T09:48:42Z")

</div>

Thanks for the tip 😉 @viquarahmed07

---

<div class="post-metadata">

**Author:** ![ZedtronicsAdmin](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/zedtronicsadmin/32/142390_2.png) [@ZedtronicsAdmin](https://forum.bubble.io/u/ZedtronicsAdmin)\
**Post date:** [September 13, 2022, 9:50am UTC](https://forum.bubble.io/t/how-to-connect-development-version-to-live-version-database/224040/9 "2022-09-13T09:50:42Z")

</div>

@mani2726@adamhholmes  
If i overwrite my data with live database  
Can i restore my dev database using this 👇

 ![Screenshot 2022-09-13 at 11.49.52](https://us1.discourse-cdn.com/bubble/original/3X/2/c/2c6774135d80c02d78a0558c25d3c971b3f2683c.png)

---

<div class="post-metadata">

**Author:** ![adamhholmes](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/adamhholmes/32/100510_2.png) [@adamhholmes](https://forum.bubble.io/u/adamhholmes)\
**Post date:** [September 13, 2022, 10:00am UTC](https://forum.bubble.io/t/how-to-connect-development-version-to-live-version-database/224040/10 "2022-09-13T10:00:12Z")

</div>

> If i overwrite my data with live database  
> Can i restore my dev database using this 👇

Yep…

---

<div class="post-metadata">

**Author:** ![ZedtronicsAdmin](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/zedtronicsadmin/32/142390_2.png) [@ZedtronicsAdmin](https://forum.bubble.io/u/ZedtronicsAdmin)\
**Post date:** [September 13, 2022, 12:25pm UTC](https://forum.bubble.io/t/how-to-connect-development-version-to-live-version-database/224040/11 "2022-09-13T12:25:58Z")

</div>

@adamhholmes Thanks 👍
