jQuery in Action, 2nd edition*
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
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Database refresh" Watch "Database refresh" New topic
Author

Database refresh

Deepak Bala
Bartender

Joined: Feb 24, 2006
Posts: 6661
    
    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
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3703
    
    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: 6661
    
    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
 
Don't get me started about those stupid light bulbs.
 
subject: Database refresh
 
Similar Threads
writing pojo in database
What is the role of Web Servers?
server configuration
Estimating Test Development and Test Coverage
Does the persistence layer know when the database has changed?