Endpoint Protection

We currently got SEP 12 hosting its database on a SQL 2008 R2 Server and we are building new SEP 14 environemnt with SQL 2016 (the old SEP 12 & SQL 2008 R2 will continue to run in parallel). We have build new SEP 14 application server but we could not find any details on how to migrate (copy) the data from old SQL database to new SQL database. We have restored (overwrite) old sem5 database on new SQL Server but application fails possibly because old database scheme is different.

Is there a documented process on how to migrate the data from old SQL database to new database ?

Hello,

If you are installing a new SEPM, you must use the same version of SEPM as the original SEPM. If you install a newer version of SEPM, you will get an error that the schema is not compatible.

Check these Articles:

Detach and move the Symantec Endpoint Protection Manager SQL database to a new SQL Server

https://support.symantec.com/en_US/article.TECH174821.html

Move the Symantec Endpoint Protection Manager SQL database to a new SQL Server with backup and restore

https://support.symantec.com/en_US/article.TECH132761.html

Best Practices guide to moving the Symantec Endpoint Protection Manager SQL Server database from an existing SQL Server database to a new SQL Server database

http://www.symantec.com/docs/TECH167300

Regards,

Thanks for the comments. I did read the KB but like I said, our requirements is to get newer version of SEPM.

If we install same version of SEPM on the new Server (connect to database restored on SQL 2016), can we do an in place upgrade of SEPM ? Will the database schema get updated during the SEPM upgrade ?