Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Database refresh

 
Deepak Bala
Bartender
Posts: 6663
5
Firefox Browser Linux MyEclipse IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ?
 
Scott Selikoff
author
Saloon Keeper
Posts: 4014
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Deepak Bala
Bartender
Posts: 6663
5
Firefox Browser Linux MyEclipse IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic