How to migrate DB lookup tables from Splunk DB Connect v1 to latest version?

[krish899]

Hi Splunkers,

Our database team has a Database reporting app which uses Splunk DB Connect v1 add-on and DB lookup tables. We would like to have them migrated to the new Splunk DB Connect add-on which we have installed presently.

We would like to completely migrate a few DB lookup tables from Splunk DB connect v1 to latest Splunk DB connect which we will be using and make the latest version as the primary Splunk DB connect for our users.

Please help in steps to have this lookup tables migrated to new Splunk DB Connect and use the search queries based on the these DB lookup tables.

Any help is appreciated.

Thanks in advance.

[mchang_splunk]

You can refer to this document for migrating DB Connect 1 to 1.2.2, then 2.4.0 and then 3.0.1.
Here is the document you can refer to:
http://docs.splunk.com/Documentation/DBX/3.0.1/DeployDBX/MigratefromDBConnectv1#Migration_paths

After upgraded to 2.4.0, you need to do some manual adjustments by following these steps:
http://docs.splunk.com/Documentation/DBX/2.4.0/DeployDBX/MigratefromDBConnectv1#dbx_migrate_lookups....