Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Configurations
- Thread starter vkolli001
- Start date
Hi ,
In order to migrate the configurations from one system to another environment , this option could be tried .
1. Go to Configuration Manager .
2. There is a tab called Export / Import .
3. choose Export option. It asks for a filename .It writes the current configuration settings to that file .
4. The file saved can be copied to the environment /temp directory where needed.
5. That file can again be imported via the same tab thru the Import from a file option.
6. This option overrides the current configuration settings and updates with the new configuration settings .
Thanx and regards ,
Giri
Please let me know whether this served the purpose.
In order to migrate the configurations from one system to another environment , this option could be tried .
1. Go to Configuration Manager .
2. There is a tab called Export / Import .
3. choose Export option. It asks for a filename .It writes the current configuration settings to that file .
4. The file saved can be copied to the environment /temp directory where needed.
5. That file can again be imported via the same tab thru the Import from a file option.
6. This option overrides the current configuration settings and updates with the new configuration settings .
Thanx and regards ,
Giri
Please let me know whether this served the purpose.
johnmanfreda
IS-IT--Management
Hi,
The posted response will get you the workstation/session configuration. If you are looking for actual application configuration from one environment to the other then the solution is more complicated.
1. You must identify all related "configuration" tables during a users session. This is accomplished by using the sql trace facility in the 'per session' mode it would be edit-> preferences-> configuration. Select the trace tab and make sure the sql trace options are selected also make sure the file selected is a valid drive and directory for the machine.
2. On the machince configured in step 1. have a functional expert configure the system i.e. add an account,department or whatever is necessary.
3. Capture the trace file from the configured file name in step 1.
4. Using a text editor of your choice,search the trace file for all insert,update statements. All tables will then be identified.
5. A data mover script can then be written from the table names in the trace to export from one environemnt and a sister script can be written to import to the target.
6. This data mover scripts can then be executed to export and import.
7. Alternative to step 5. would be scripts written in native RDMS tools.
This is really involved but, the only sure way to capture all effected "configuration tables" from a given application.
Hope this helps.
John Manfreda
The posted response will get you the workstation/session configuration. If you are looking for actual application configuration from one environment to the other then the solution is more complicated.
1. You must identify all related "configuration" tables during a users session. This is accomplished by using the sql trace facility in the 'per session' mode it would be edit-> preferences-> configuration. Select the trace tab and make sure the sql trace options are selected also make sure the file selected is a valid drive and directory for the machine.
2. On the machince configured in step 1. have a functional expert configure the system i.e. add an account,department or whatever is necessary.
3. Capture the trace file from the configured file name in step 1.
4. Using a text editor of your choice,search the trace file for all insert,update statements. All tables will then be identified.
5. A data mover script can then be written from the table names in the trace to export from one environemnt and a sister script can be written to import to the target.
6. This data mover scripts can then be executed to export and import.
7. Alternative to step 5. would be scripts written in native RDMS tools.
This is really involved but, the only sure way to capture all effected "configuration tables" from a given application.
Hope this helps.
John Manfreda
- Status