Quite often DBAs and Developers are charged with rolling out new changes to their database objects. They might need to ensure their test database reflects their production environment or they might take their stage changes and apply those to their production system. In this short video, Toad for DB2 development manager, Jeff Podlasek, demonstrates how to use Toad’s object compare feature to perform these type of tasks.
Related Articles
How To Write a Cross-Database Query
Introduction When writing a normal SQL query, the user is typically working in a SQL authoring program that is connected directly to the RDBMS in which the query will be run. 1 – Simple Client Conn...
SQL PL Stored Procedures
Stored procedures can be written in a variety of languages, including C, C++, Java, and SQL PL. SQL PL is a language specifically designed for DB2 and offers a rich set of features that can make it su...
I’m having problems with tab stops. They’re not consistent, and when I...
To resolve these problems, go to Edit → Editor Options and look under "General Options", under the "General Options" node, where there are several options related to tab stops. Unchecking "Auto indent...
