Move Advanced Mobile Databases to a different SQL Server
- On the Adv Mobile web server, run
iisreset /stop
in command prompt - Move BDSI_AM_CORE, BDSI_AM_WOM, and BDSI_AM_Inventory database to the new server using SQL detach/attach functions in SQL Management Studio (see Microsoft SQL documentation if you have question).
- Once the databases have been moved, update the connection strings in each web.config file. Open each file in a text editor and use find/replace, find the old server name/Instance and replace with the new. You’ll be replacing the Data Source value in the ConnectionString.
- AM CORE: c:\Program Files (x86)\Blue Dot\Advanced Mobile for Infor EAM Server\Instances\%InstanceName%\AMCoreWeb\web.config
- AM Work: c:\Program Files (x86)\Blue Dot\Advanced Mobile for Infor EAM Server\Instances\%InstanceName%\AMWorkWeb\web.config
AM Inventory: c:\Program Files (x86)\Blue Dot\Advanced Mobile for Infor EAM Server\Instances\%InstanceName%\AMInventoryWeb\web.config
Example<add name="AMWOMIntegration" connectionString="Data Source=(local);Initial Catalog=BDSI_AM_WOM_1835;Integrated Security=True" providerName="System.Data.SqlClient" />
- Once the connection strings have been replaced and saved. Start IIS on the Adv Mobile web server, run
iisreset /start
in command prompt.
Have questions? Email support@bluedotsolutions.com