Any IBM Tools for database change management and versioning available ?

Satvinder Kaur

Any IBM Tools for database change management and versioning available ?

Looking for experts opinions on three queries below :

1) Best database change management and versioning tool in the market. It should cover DB2 LUW, MySQL and also NoSQL(for future requirements) if possible.

2) Do IBM has any tool which supports this zone.

3) if IBM do not have any tools, opinion on Liquibase- pros and cons.

Thanks.

Ludovic Janssens

RE: Any IBM Tools for database change management and versioning available ?
(in response to Satvinder Kaur)

Hi Satvinder,

1) Best database change management and versioning tool in the market. It should cover DB2 LUW, MySQL and also NoSQL(for future requirements) if possible.

The best database change management and versioning tool in the market is the one that suits your needs. There are many on the market and they all serve different use cases. If you want to know which is the best for you, you should lay out all your requirements and look for the best match. Personally, I wouldn't go for a change management and versioning tool that is designed for databases only, I would look for a full blown Change, Configuration and Release Management platform that allows you to align database development with your application development.

2) Do IBM has any tool which supports this zone.

In the scope of IBM I would look at Urban Code and its integration options. Urban Code provides you with a single interface that can include different extensions that could reply to your needs. You can combine Urban Code with other IBM tools in that area such as Rational Team Concert and with open source solutions such as Jenkins.

3) if IBM do not have any tools, opinion on Liquibase- pros and cons.

Liquibase is a fine tool, but it does not support NoSQL yet (nor does it support DB2 for z/OS). If you use this tool, make sure to embed it in a well defined context of deployment tools such as Jenkins. If you consider Liquibase, you should also consider Datical (Liquibase's enterprise version) and FlyWayDB as an alternative (FlywayDB offers you the option to work with real DDL)

Good luck with your search!

Ludovic Janssens
Information Management Consultant

Satvinder Kaur

RE: Any IBM Tools for database change management and versioning available ?
(in response to Ludovic Janssens)

Thank you so much Ludovic for detailed information.

In Reply to Ludovic Janssens:

Hi Satvinder,

1) Best database change management and versioning tool in the market. It should cover DB2 LUW, MySQL and also NoSQL(for future requirements) if possible.

The best database change management and versioning tool in the market is the one that suits your needs. There are many on the market and they all serve different use cases. If you want to know which is the best for you, you should lay out all your requirements and look for the best match. Personally, I wouldn't go for a change management and versioning tool that is designed for databases only, I would look for a full blown Change, Configuration and Release Management platform that allows you to align database development with your application development.

2) Do IBM has any tool which supports this zone.

In the scope of IBM I would look at Urban Code and its integration options. Urban Code provides you with a single interface that can include different extensions that could reply to your needs. You can combine Urban Code with other IBM tools in that area such as Rational Team Concert and with open source solutions such as Jenkins.

3) if IBM do not have any tools, opinion on Liquibase- pros and cons.

Liquibase is a fine tool, but it does not support NoSQL yet (nor does it support DB2 for z/OS). If you use this tool, make sure to embed it in a well defined context of deployment tools such as Jenkins. If you consider Liquibase, you should also consider Datical (Liquibase's enterprise version) and FlyWayDB as an alternative (FlywayDB offers you the option to work with real DDL)

Good luck with your search!

Ludovic Janssens
Information Management Consultant

Robert Krall

RE: Any IBM Tools for database change management and versioning available ?
(in response to Satvinder Kaur)

Personally I am a big fan of Toad.  There are some odd settings I think should be changed out of the box, but all in all I am pretty pleased with it.  

https://www.quest.com/toad/

"Toad solutions support and work across relational databases (such as Oracle, SQL Server, DB2, SAP and MySQL), as well as a growing number of NoSQL databases, cloud sources, data warehouse platforms and BI platforms."

For version control. They support TFS, SVN and a few others I believe. I only use TFS. Works pretty pretty well. Their DDL compare is not bad either.  

I have found IBM tools hard to use mostly cause its all green screen and lacks a lot of functionality I prefer.

Avram Friedman

RE: Any IBM Tools for database change management and versioning available ?
(in response to Satvinder Kaur)


DB2 has built in tools for database change management.

The details of your question suggest that you are looking for application change management.
The main IBM tool for doing this which does not support heterogeneous platforms is called
SMP/e  or Systems Modification Program / extended
DB2 its self uses SMP/e for service of its software.

Avram Friedman
DB2-L hall of fame contributer
DB2-L acting administrator

[login to unmask email]

Robert Plata

RE: Any IBM Tools for database change management and versioning available ?
(in response to Robert Krall)

I prefer Toad for DB2.  Robert K hits upon reasons that we are experiencing here now.  

Our DBAs only supported SQL Server and Oracle in the past, but now must support DB2 LUW and z/OS due to attrition.  They prefer to stay away from the green screens on z/OS.  Toad provides support for all of the DBMSs that we work with, which is a big plus in our current evaluation of Toad.  

Rob Plata

Robert Krall

RE: Any IBM Tools for database change management and versioning available ?
(in response to Robert Plata)

Robert, you ever use RedGate with MSSQL or Oracle?  SSMS + RedGate is my favorite RDBMS tools. 

Edited By:
Robert Krall[Organization Members] @ Apr 03, 2017 - 07:42 AM (America/Central)

Robert Krall

RE: Any IBM Tools for database change management and versioning available ?
(in response to Robert Plata)

Robert, Did you run into issues like I did with nsql procs being created in Sysproc schema?  TFS and TOAD will not work if your objects are created in system schemas such as sysproc.