IBM Security i2

iBase: Import: How to quickly change the name of a database in several hundred import specifications?

  • 1.  iBase: Import: How to quickly change the name of a database in several hundred import specifications?

    Posted Fri February 05, 2021 06:23 PM
    Hello to everybody!

    I have the following problem: 
    - I have iBase database
    - In this database I have several hundred import specifications. They all have an OLE-DB data source with the following parameters:
         - Provider: Microsoft Ole-DB Provider for SQL Server
         - Server: Server-PROD
         - Database Name: PROD_01

    BY some reasons I needed to change the name of the Database in all my import specifications!
    Database Name: PROD_01 => PROD_02 (This database has a similar structure with the same tables, views etc.)

    And what is most terrible is that I have to perform several such "switching":
    PROD_01 => PROD_02 => ... => PROD_45
    (I need to import data from 45 databases on the same server)

    If I will manually make database name changes in all my import specification (45 times in several hundred specifications) - I will definitely " die" :(

    Can anyone give me any advice how to do such renaming quickly in all import specifications in iBase?



    ------------------------------
    Pavel Lifanov
    Leading Expert
    R@D Vulkan
    Moscow
    ------------------------------