Hi,

We are running SEPM v11 RU7 on WinServer 2003 and Database on SQL Server 2005. We are about to move the database to a new SQL server (2008).

Please advise if the following symantec article is sufficient for the DB migration and the steps on changes in SEPM.

http://www.symantec.com/business/support/index?page=content&id=TECH132761

Also would like to find out how long will it take to complete this migration.

Thank you.

hi,

Find some more artical

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

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

Follow steps as per comments

https://www-secure.symantec.com/connect/forums/migrating-sepm-database-sql-2005-sql-2008#comment-5834701

Hi,

You can refer these articles

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

SQL admin will be the best person to complete this activity.

Hello,

Here are the perfect articles for your issue:

Migrating to Microsoft SQL 2008 from a previous version

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

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

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

Hope that helps!!

Thank you all on providing the information.

I was reading some blogs on this migration process as well and realised the procedure of migrating DB to SQL 2008 also requires backing up SEPM server certificate as well as uninstall & reinstall SEPM which will take heaps longer to carry out. Is that true?

Ta.

Not true. As per article mentioned above after moving the DB you will need only to run the Management Server Configuration Wizard on SEPM to point it to the new database server:

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

6. Run the Management Server Configuration Wizard to point the SEPM to the new database.

6a. If SEPM is already installed: Choose the option to Reconfigure the Management server. When prompted, enter the credentials for the sem5 user created in the steps above.

does this help?

Symantec Endpoint Protection Manager: Moving from the embedded database to Microsoft SQL Server

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

I believe in this case it is a move from SQL to SQL - according to inital post:

We are running SEPM v11 RU7 on WinServer 2003 and Database on SQL Server 2005. We are about to move the database to a new SQL server (2008).

Hi,

Please refer this..

http://www.symantec.com/business/support/index?page=content&id=TECH132761

http://www.symantec.com/business/support/index?page=content&id=TECH174821

Symantec Endpoint Protection Manager: Moving from the embedded database to Microsoft SQL Server

http://www.symantec.com/business/support/index?page=content&id=TECH102547

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/business/support/index?page=content&id=TECH104723

Hi

To move embedded database to SQL you need to run Management Server Wizard Console and Select Database as "SQL Database"

Regards

Hi

Any update on the above mentioned query

Regards

Hi, 

Follow http://www.symantec.com/docs/TECH174821 for the same and keep posted.

Regards

Ajin

Try these articles.

http://www.symantec.com/business/support/index?page=content&id=TECH102547

http://www.symantec.com/business/support/index?page=content&id=TECH104723&actp=search&viewlocale=en_US&searchid=1337691896765

Thank you all for providing all the links.

I went through all of them and got the following statement:

With the migration from the embedded database to SQL database - the process of uninstall and reinstall SEPM is required. This is supported by the article ID: TECH102547

http://www.symantec.com/business/support/index?page=content&id=TECH102547

With the migration from the existing SQL database to the newer version (e.g. 2005 to 2008) - the process of uninstall and reinstall SEPM is NOT required. This is supported by the article ID: TECH104723 and a discussion in the forum.

http://www.symantec.com/business/support/index?page=content&id=TECH104723

http://www.symantec.com/connect/forums/migrating-sepm-db-sql-server-2005-2008-do-i-really-have-reinstall-sepm

This article might also be helpful.

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

I haven't started the migration process yet so I can't confirm the statement above is true. Will provide an update once this process is complete.

Hi

Please follow the link below

http://www.symantec.com/business/support/index?page=content&id=TECH104723&actp=search&viewlocale=en_US&searchid=1366263937023

Regards

Just a quick note. We have successfully migrated the SQL Database from 2005 to 2008. No SEPM re-install is required. All you need is to have the DB login and password. This process takes about 10 minutes to complete and the SEPM services will restore automatically.