Unsolved
This post is more than 5 years old
1 Rookie
•
357 Posts
0
2147
How can I move my database to a different SQL Server?
I have OME installed using one of our SQL servers. We need to get rid of that server so I need to move the database to a different SQL server. Is it as simple as having our DBA move the database and then just editing something in OME to point to the new location or is there a more involved process I'd need to follow?
Thanks.
DELL-Shivendra K
685 Posts
0
November 9th, 2017 00:00
Hi, thanks for the query.
After moving the database (remove from source and restore at target), when you launch OME for the first time, it will ask for database reconfiguration. You need to provide new SQL server and instance details with credentials to finish the process. No other edits required.
Always good to keep a backup copied. Also, good to keep following white paper handy for any database related tasks / operations needed with OME:
http://en.community.dell.com/techcenter/extras/m/white_papers/20441772