Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm looking for software tools to move database schema for Oracle, SQL Server and Netezza. We use Oracle for our ODS, Netezza for our Data Warehouse (for it's bulk loading capabilities) and SQL Server for internal tool development.

When we move data schema from one environment to another, it's all done manually. This takes a lot of time. And we use Informatica to move the actual data. To my knowledge, Informatica cannot move database schema. What tools can I buy that can move database schema for all three database management systems?

I see Red Gate SQL Compare can move schema. But it doesn't look like it can handle Oracle or Netezza. If you don't know one single tool that can be purchased to move schema for all 3 DBMSs, can you give let me know what tools folks recommend for each one?

PS: I didn't see a Stack Exchange [tag] for Netezza. But I believe Netezza is based on PostGres, so I included that in the tag list.

share|improve this question

closed as off-topic by Paul White, tblPhil, bluefeet, Aaron Bertrand Jan 26 at 14:40

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Paul White, tblPhil, bluefeet, Aaron Bertrand
If this question can be reworded to fit the rules in the help center, please edit the question.

1 Answer 1

up vote 1 down vote accepted

In the past, I have used ErWin from Computer Associates and PowerDesigner to move schema between RDBMSes. It's been many years since then, and I would evaluate their current feature set if I had to pick something today.

share|improve this answer
    
just found "SchemaDiff Multi-DB" ... datanamic.com/dezign –  MacGyver May 17 '12 at 17:56
    
I have used Dezign as well but I never looked at any multi DB features it might have. –  darin strait May 18 '12 at 18:21

Not the answer you're looking for? Browse other questions tagged or ask your own question.