At times customers want to retain the name of the currently active config file especially when making minor changes to it by way of adding or removing objects. The purpose may be to implement change management and control the name change so as to change it when there is a major amendment to it.
Â
General information.
Here are the steps involved. Assuming that the name of the currently active config file is config1, and it is desired to add a table to it. The following can be done:
1. Make a copy of the currently active config file config1by:
sp_ctrl>copy config config1 to config2 (or any other name of your choice)
2. Activate the copy:
sp_ctrl>activate config config2
3. Once the table has been created in the database, or is ready to be replicated (as the case may be), add it to the original config file config1 (using the command "edit config")
4. Activate the original config config1 by:
sp_ctrl>activate config config1
5. Sync the target table if applicable, using means such as compare or copy.
