Support Suite

User Login

Knowledgebase: Technical

Moving EIOBoard’s Database Only to a Different SQL Server Posted by Savance on 29 September 2010 09:29 AM
Make a backup. Option 1 – Use SQL Management Studio https://www.serverintellect.com/support/sqlserver/database-backup-ssmse/ Option 2 – Using EIOBoard Admin Open up EIOBoard Server Admin Go to the SQL Tasks tab Edit the Backup Database job Confirm where it is being backed up to (@BackupLocation) and change it as needed Click Cancel or Save if you made changes to go back on the SQL Tasks tab Right click on the Backup Database job and say process now Look in the bottom left corner to follow the status of the job until it is complete Navigate to the location specified in the job and confirm the date/time of the file to make sure it is now Move the Backup and Restore. Copy the backup over to the new SQL server Restore the file using SQL Management Studio https://www.webhosting.uk.com/kb/how-to-restore-ms-sql-server-database-backup-file/ If you do not wish to use the sa username and password, create a user in SQL with dbo (database owner) permissions https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/create-a-database-user?view=sql-server-2017 Adjust Settings. Adjust EIOBoard Server Open EIOBoard Server Admin on your EIOBoard Server Right click on the EIOBoard Server Admin icon in the system tray and select Settings On the Database tab, change the Database Server, Database Name, Username, and Password to match your new server and login information. Adjust Both Web.config Files Open the EIOBoard Web folder (defaults to C:\Program Files\Savance\EIOBoard Server\EIOBoard) Locate and edit the web.config using notepad or equivalent Adjust this line to match your new server/login: <add key="SQLConnection" value="server=yourservernameorip;uid=yourusername;pwd=yourpassword;database=yourdatabase;Min Pool Size=7"/> Save that file and close it Go one folder deeper in the webservice folder and check if the Web Services has it's own web.config If it does, adjust this line to match your new server/login: <add key="ConnectionString" value=" server=yourservernameorip;uid=yourusername;pwd=yourpassword;database=yourdatabase "/> Save that file and close it Decommission old SQL Server or Database. Either uninstall SQL Server from the location where it was originally installed, delete the database, detatch the database, or take the database offline to ensure that everything is pointing to the new database. Test it Login with the different interfaces and make sure everything works as expected!

Savance | The Company

Savance sets ourselves apart from our competition by keeping it personal. We actively request feedback, know our customers by first name, integrate their ideas into our products, and measure our success based on their happiness. The way businesses used to be run.