How can I code an auto-sync to live databases from sandbox?

Is this possible? I have data what is auto uploaded into wix databases everyday, put then I have to manually sync each sandbox to live. Is it possible to automate this through wix code?

It’s not possible to sync from the sandbox to the Live database collections. You should just create an import mechanism direct to the Live database.

Ah I thought as much, any idea on how to import data straight to the live database? Has anyone ever done this before?

@raiyatfx Like this:

First open the Edit Live Data app:


Then you’ll have the Import/Export option:

that’s a manual process - same as putting in sandbox and then syncing (in terms of efficiency),

we currently use a database populator which pulls data using wix fetch from our data source. It then populates all our databases with up-to-date information when you click a button the page associated to where the code is place

Essentially is there a way to populate the live database instead? i.e a piece of code that allows you to directly update the live.

Instead of running the populator from Preview, run the populator from the Live site and it will populate the Live database.

@yisrael-wix ooo okay I’ll try this and let you know how it goes!

@yisrael-wix Hi Yisrael, I also trying to do the same thing and didn’t able to populate in the live even though I run through Live Site. Do you have any other suggestion I could try?