Unsolved
This post is more than 5 years old
3 Posts
0
1968
February 16th, 2017 12:00
Migrating OME SQLexpress to SQL12
Is there a how to documentation on migrating of locally I installed SQLexpress backend for OME 2.2 to an external SQL12?
No Events found!
DELL-Shivendra K
2 Intern
•
685 Posts
0
February 19th, 2017 22:00
Hi, thanks for the query.
This can be done by backing up existing database and then restoring it on a new target instance. Once database is up on new instance, OME can be re-targeted on it by failing the login on current instance and then providing new instance details in OME UI. Please refer following white paper for more details.
en.community.dell.com/.../20441772
sarahyu
3 Posts
0
February 20th, 2017 13:00
Thank you for the information and link to OME guide. Can you validate if we should install SQL12 or SQL14 for our OME install version: 2.2.0.2056
DELL-Shivendra K
2 Intern
•
685 Posts
0
February 20th, 2017 23:00
OME 2.2 supports both the versions. You can use one as per your convenience. Our recommendation would be to use the greater one (SQL Server 2014).
sarahyu
3 Posts
0
February 22nd, 2017 14:00
Following the instructions outline in the OpenManage Essentials database, I have successfully installed and restored OMEssentials Database. However, when attempting to retarget OME to the new SQL, we are getting connection issues. Are there additional documentation that can help with OME to SQL connections issues?
DELL-Shivendra K
2 Intern
•
685 Posts
0
February 23rd, 2017 22:00
What error are you getting, possible to share the screenshot?
I hope the DB user credentials have "db_owner" role enabled on the target database.