Migrate MEE data from SQL Express to SQL server

[cjones_ufv]

I have MEE 1.3.1.1962 with data currently stored in the SQL Express embedded database.  I need to migrate that date over to a SQL server.  What are the configuration requirements for the SQL database and what steps are required to migrate the data from the existing SQL Express database?

[celorbelor]

Hi cjones_ufv, and welcome to the Malwarebytes forum!

 

It looks like you've already opened a support ticket for help on migrating your SQL database. The agent in the ticket will be giving you some detailed steps to follow for your setup, but in general the process works like this:

 

1. Click Start > All Programs > Malwarebytes Enterprise Edition > Data Backup and Restoration
2. Create a new backup of the database on your Management Server
3. Copy the backup folder to your SQL Server
4. Inside the backup folder, locate the SCDB.mdf and .ldf files
5. Copy these files to the folder C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\
   • Note: This folder may vary depending on your installation path
6. On the new SQL Server, log in to SQL Management Studio
7. Attach the SCDB.MDF file
8. Once attached, rename the database from C:\Program Files... to SCDB
9. On your existing Management Server, log in to the Management Console
10. Click the Admin Pane on the left
11. On the Overview tab, under SQL Database Setting, click Change
12. Enter the address, instance name, and user information (sysadmin role preferred) for the SQL server
13. The Management Console should disconnect, and then you should be able to log in again

As far as configuration requirements go, you'll need to enable Named Pipes and TCP/IP on your SQL Server. For other customers who are looking for specific steps unique to your setup or who would like help with this, please feel free to create a support ticket using our support request form and a support agent will be able to help further.