How to connect Development version to Live Version database?

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 :pray:

2 Likes

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


Click this, you will get below screen.

You can copy the live database to the dev database without deployment.

1 Like

@mani2726 Thanks for the response :+1:

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

@ZedtronicsAdmin :wave:

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

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

1 Like

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)…

1 Like

@vajihahmed @adamhholmes
Thanks :+1:

if this the case then i will overwrite my dev database…
Thanks once again :+1:

@ZedtronicsAdmin :wave:
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

later on you can import it…

1 Like

Thanks for the tip :wink: @viquarahmed07

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

If i overwrite my data with live database
Can i restore my dev database using this :point_down:

Yep…

1 Like

@adamhholmes Thanks :+1: