To migrate from a SQL express to a standalone server follow these steps:
- Install the latest EA patch on the system
- Install SQL system server onto the new SQL box and get it setup and ready to receive the DB's
- Stop all EA services on the EA machine
- Migrate the local SQL DB from the Express setup to the SQL Standalone server using SQL Management backup and restore options.
- Change the SQL DB connection string to the new SQL DB location in the following files:
- C:\......\Enterprise Alert\Websites\EAPortal->web.config
- C:\......\Enterprise Alert -> logman.xml
- C:\......\Enterprise Alert -> profman.xml
- Restart IIS
- Start all EA services on the EA machine