Community and Support

            OpUtils Database Migration from Firebird to MSSql

            Here are the steps for the Firebird to Mssql DB migration:
            1. Stop OpUtils Service

            2. Take a complete OpUtils Folder backup and save it on different location .

            3. Go to OpUtils\conf dir

            4. Open mssql_dbm_params.conf ile and mention SQL server name and authentication and save it.

            5. Open command prompt and go to OpUtils\bin directory

            6. Ensure the SQL server is running

            7. Execute OpUtilsDBMigration.bat file as below
              Eg:-
              OpUtilsDBMigration.bat mssql

            8. Start OpUtils Service




            mssql_dbm_params.conf property file 
            ---------------------------------------------------------------------------------------------------------------
            username=<Enter User Name>
            # Eg.
            #username=oputils

            # password for the db can be specified here
            password=<Enter Password>
            # Eg.
            #password=oputils

            url=jdbc:jtds:sqlserver://<Enter Server Name>:<Enter Port Number>/OpUtilsDB
            # Eg.
            #url=jdbc:jtds:sqlserver://localhost:1433/OpUtilsDB

            # For named instance, append "/instance=<Enter Instance>" at the end
            # Eg.
            #url=jdbc:jtds:sqlserver://localhost:1433/OpUtilsDB/instance=EXPRESSOP

            # For windows authentication, append "/Domain=<Enter Domain Name>" at the end
            #Eg.
            #url=jdbc:jtds:sqlserver://localhost:1433/OpUtilsDB/Domain=csez.zohocorpin.com

            # For named instance with windows authentication, append "/instance=<Enter Instance>/Domain=<Enter Domain Name>" at the end
            #Eg.
            #url=jdbc:jtds:sqlserver://localhost:1433/OpUtilsDB/instance=EXPRESSOP/Domain=csez.zohocorpin.com

            ---------------------------------------------------------------------------------------------------------------


            Updated: 07 Nov 2018 10:06 PM
            Helpful?  
            Help us to make this article better
            0 0