If you want to use a SQL Server user account, then select SQL Authentication and enter the Username and Password.For Authentication, you can either use Windows credentials or a SQL Server user account.If not, click Browse and select the bcp.exe and bcp.rll files from SQL Server installed directory. If you have already moved the bcp.exe and bcp.rll files, the same will be visible in the Select bcp.exe File and Select bcp.rll File fields.In the DB Server Instance field, select the SQL Server instance you want to use.In the DB Server Name/IP and Port field, enter the host name or IP address and the port number of the MS SQL database server.Enter the Username and Password of a user who has permission to create a new database.In the DB Server Name/IP and Port field, enter the host name or IP address and the port number of the PostgreSQL database server.From the Select Database Server menu, select the database server that you want to change to.Navigate to Admin → Administration → Database Settings → Database Configuration.Log in to RecoveryManager Plus as an administrator.Repeat the steps 1 to 3 from above whenever you update the PostgreSQL server.Restart the external PostgreSQL server.refers to the home directory of RecoveryManager Plus. Copy all the files in /lib and /bin folders and paste them in /pgsql/lib and /pgsql/bin folders respectively.Uncomment the entry and change its value to archive. In the machine where PostgreSQL is installed, go to /data and open the nf file.If firewall is enabled in the MS SQL Server machine, the TCP and UDP ports must be opened.For migration to MS SQL, please install the corresponding SQL Native Client in the RecoveryManager Plus machine as per the MS SQL Server version.For example, C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn\Resources\1033\bcp.rll Location of the bcp.rll file: \Client SDK\ODBC\130\Tools\Binn\Resources\1033\bcp.rll.For example, C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn\bcp.exe. Copy the bcp.exe and bcp.rll files from the SQL Server installed directory and paste them in the RecoveryManager Plus bin folder (\Client SDK\ODBC\130\Tools\Binn\bcp.exe.Take a backup of the database before you proceed.MS SQL Server to PostgreSQL Server or another instance of MS SQL Server.PostgreSQL Server to MS SQL Server or another instance of PostgreSQL Server.Using this option you can change the built-in database server (PostgreSQL) of RecoveryManager Plus to MS SQL Server or another instance of a PostgreSQL Server. The product also allows you to migrate from the built-in database (PostgreSQL) to MS SQL. RecoveryManager Plus allows you to configure periodic backups of the database that comes built-in with it.
0 Comments
Leave a Reply. |