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
add comment

1 Answer

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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