Skip to main content
Skip table of contents

How do I request that a test database be refreshed with the latest copy of production?

Frequently, a client asks to refresh their test environment with real production data to test a new feature or process. The client may also want to restore test over prod during go-live, where data may be loaded in the test environment for verification and copied to prod prior to go-live.

Database refreshes are requested by Veson IMOS Platform clients. On-Premise clients will refresh their test database by themselves.

To request the test database to be refreshed with the real production data, you will need to create the request through our portal, providing a time slot in the UTC time zone. Typically, an hour time slot is enough, but we would like to request a two-hour window from Clients for this change. This should be the window when users are logged out of the target system (test database). Production is not affected by the restoration process.

Please note that confirmation of the scheduled window is dependent upon the availability of our resources.
The maintenance window for the database refresh is not official unless otherwise confirmed. In the event that a request coincides with a public holiday within the specified time zone, we may need to reschedule for an alternative update window.

Kindly provide the following required details when raising a database refresh:

  1. What is the source environment/database name? (E.g. ABCD_prod)

  2. What is the target environment/database name? (E.g. ABCD_test)

  3. When can this be performed?

    1. Kindly provide two maintenance windows, each with a 2-hour period, with the earliest window being at least 48 hours in advance. (Example: 12 December 2023 12 pm to 2 pm UTC, or 14 December 2023 12 pm to 2 pm UTC.) The date and time MUST be specified in the UTC time zone within the "Standard ISD request window“ table below

    2. Changes cannot be accommodated at weekends.

  4. Do you want to preserve user info (i.e. Security list) on the TARGET? (Default is no)

Standard ISD request window (Mon-Fri, excluding regional public holidays):

From:

To:

Summer Time:

01:00 UTC

20:30 UTC

Winter Time:

01:00 UTC

21:30 UTC

Note: Any request outside the above times needs approval.

We require 2 working days' notice for a simple copy of the database (i.e. latest production copied to test) and 2 weeks' notice if you require the test database to be refreshed with a copy of production from a specific point in time in the past.

Before database restore

Before restoring a database copy, please keep in mind:

  • Configuration flag list will not be overwritten

  • Messaging service configuration will not be overwritten

  • Customers have the choice of whether the users are retained from the restore or overwritten

    • If you have a user that is used for API calls - take note of the email address of that user, and once the database is restored, change the email address back to the original one (i.e. before the DB restore) in the user profile of Security list. Log out and log in again in order to see the Veslink API section.


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.