Forum Discussion

jariwalakrunal's avatar
jariwalakrunal
New Member
10 years ago
Solved

Working with test db & production db

Hi

 

I have created some reports while working on connecting local testing DB. Now I want to use same reports, but instead of local db, I want it to get data from live DB. How it can be achieved?

 

So same reports, but from identical different data source (production database)?

 

Kindly advise.

 

Krunal

Need Help
  • itchyeyeballs's avatar
    itchyeyeballs
    10 years ago

    You should be able to just change the data source providing the table structure is identical.

     

    Click edit queries then click the cog icon next to source and you should be able to change it, make sure you do the same for all your queries or you could get missmatches in data.

     

     

2 Replies

  • itchyeyeballs's avatar
    itchyeyeballs
    Icon for Impactful Individual rankImpactful Individual
    10 years ago

    You should be able to just change the data source providing the table structure is identical.

     

    Click edit queries then click the cog icon next to source and you should be able to change it, make sure you do the same for all your queries or you could get missmatches in data.