1

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.

1

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.

  • 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.