Design

Databases and Refreshing Test Data

By Gregory Williams, September 14, 2010

Every shop needs a Test and a Production database -- but keeping them in sync?

2. Define the Chain Steps

Now that I have created my chain, I can create my chain steps to call a program or another chain. In my case I will call a program. Each chain step calls a program that will call a procedure within my package – SCHEMA_REFRESH. Please note that the program_name in my chain steps are the same as the procedure names in my package, except the last chain step which will be handled differently. I do it this way as a way of self documentation. The program_name can be any name you choose. Listing 6 shows all of my chain steps.

Dr. Dobb's encourages readers to engage in spirited, healthy debate, including taking us to task.
However, Dr. Dobb's moderates all comments posted to our site, and reserves the right to modify or remove any content that it determines to be derogatory, offensive, inflammatory, vulgar, irrelevant/off-topic, racist or obvious marketing or spam. Dr. Dobb's further reserves the right to disable the profile of any commenter participating in said activities.

Video

This month's Dr. Dobb's Journal

This month,
Dr. Dobb's Journal is devoted to mobile programming. We introduce you to Apple's new Swift programming language, discuss the perils of being the third-most-popular mobile platform, revisit SQLite on Android
, and much more!