Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 229
  • Last Modified:

schema refreshes from source to target on diff hosts for multiple dataabses

Hi guys,
i want to refresh some of the schemas for source to target on diff host for multiple databases. What should be the right approach.

for example- I have two databases on one host.
1. export diff schemas from both databases.
2. Scp dump from one host to another
3. export dumps to the target databases.
  • 2
2 Solutions
slightwv (䄆 Netminder) Commented:
Exp/imp would probably be the easiest.

You might look into linking the databases and do a direct migration but that can be a little dangerous.
nirvairghumanAuthor Commented:
I want to achieve this with shell script, how many steps should be there any suggestions
slightwv (䄆 Netminder) Commented:
Not sure I can answer this.  It depends on your setup.

At a maximum, one script per server involved.
At best, one script.

The one script would issue remote copy and remote shell calls.

The one script per server would have to wait for the correct file to show up before it runs.

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now