Using migration tool with own SQL credentials
There is a method to use the migration tool in the current version with the SQL credentials defined separately from B2 settings.
The xml file for standard SQL sa account settings where
SQL user: sa
Password: ICU_ROOT_11looks as follows:
<?xml version="1.0" encoding="utf-8"?>
<RemoteDatabaseConfig xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<strHost>192.168.61.252</strHost>
<strUsername>sa</strUsername>
<strPassword>NXDa2+dKCZe1lSfXKPmYbg==</strPassword>
<port>1433</port>
<bUseRemote>true</bUseRemote>
<instanceName>ICUDB</instanceName>
</RemoteDatabaseConfig>If the default SQL user credentials were used then the only tag to modify is <strHost>.
The DatabaseConfig.xml and file called Boomerang2.exe (it may be any file with such a name) shall be placed in a directory which then shall be selected as the source of information for B2 database access. This will create a correct JSON file.
Last updated
