# How to migrate OpUtils to a different database?

The default database used by OpUtils is PostGres database. Earlier versions of OpUtils were using FireBired database. This document will provide you the steps to move the OpUtils database to PostGres or MS SQL. The steps and the supported databases vary in accordance to the OS where OpUtils is installed. While both PostGres and MS SQL are supported for Windows, only PostGres is supported for Linux.

## Windows

### Move to PostGres database

Follow the steps below to migrate the data from FireBird or MS SQL database:

1. Stop OpUtils.
2. Download [Postgres DB](https://uploads.zohocorp.com/Internal_Useruploads/dnd/OpUtils/p18qpcmvljev5ojj16q1gflepk0/pgsql-windows.zip) from the following URL and unzip it under the OpUtils directory.
3. Open a command prompt and change directory to `OpUtils\bin`.
4. Execute the command:

   ```
   OpUtilsDBMigration.bat postgres
   ```

5. Start OpUtils.

### Move to MS SQL database

Follow the steps below to migrate from FireBired or PostGres database:

1. Stop OpUtils.
2. Edit the `mssql_dbm_params.conf` available under the `OpUtils/conf` directory.
3. Specify the SQL Server name and authentication details and save.
4. Open a command prompt and change directory to `OpUtils\bin`.
5. Execute the command:

   ```
   OpUtilsDBMigration.bat mssql
   ```

6. Start OpUtils.