aspose file tools*
The moose likes JDBC and the fly likes Database refresh Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Database refresh" Watch "Database refresh" New topic
Author

Database refresh

Deepak Bala
Bartender

Joined: Feb 24, 2006
Posts: 6662
    
    5

Sometimes we need our development servers to be refreshed with data from our production servers. We raise a request to a DB group and they take care of it for us. I was wondering if there exists a tool that would allow us to make a quick copy of data from some limited important tables (these tables would be identified by us). The tool has to refresh data from one table to another. We cant spare a day at times since the team might be trying to solve production bugs. A free tool would be preferable Anyone know of one ?


SCJP 6 articles - SCJP 5/6 mock exams - More SCJP Mocks
Scott Selikoff
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3710
    
    5

I've worked in numerous environments where the vast majority of developers had little to no access to production data (because it was so special) so I've never needed such a tool. Most of the time such tools can be hand-coded for specific situations. What database software are you using? I'm sure there's a DBA tool that can be used but it is likely DBMS specific.


My Blog: Down Home Country Coding with Scott Selikoff
Deepak Bala
Bartender

Joined: Feb 24, 2006
Posts: 6662
    
    5

What database software are you using? I'm sure there's a DBA tool that can be used but it is likely DBMS specific.


Yes thats what I thought too. We have Sybase. I was told powerbuilder has something called data pipe line that will allow me to do something like this. I was just wondering if there was a generic tool out there. Thanks
 
Consider Paul's rocket mass heater.
 
subject: Database refresh