I have created 20 reports but then I realized that the created reports are from staging database but ideally it should be with production database. What should I do?
Is the schema of these report same or different?
Schema is same for the all the report.
In case if the database schema is same you can go to edit database and change the db connection details to production database. All the reports will work perfectly without any problem and will reflect this new data.