aspose file tools
The moose likes JDBC and Relational Databases 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 Groovy Fundamentals video training course this week in the Groovy forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 3740
    
  10

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.


[OCA 8 Book] [Blog]
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Database refresh