05-27-2015 11:12 AM
Hello,
My DBA's are in the middle of upgrading from SQL 2008 to SQL 2012. My DBA's do not want to do a restore of a backup from 2008. They are wanting to do a fresh install.
Does this sound logical to any of you Hyland DBA's?
06-01-2015 10:01 AM
Dear Seth,
Thank you for using Community. Hope I can solve your issue.
First off, I don't believe you need to head down the path of doing a fresh install of OnBase for a database upgrade. Like Nick said, the backup/restore path has worked fine for our customers.
I believe what your DBAs are referring to is the Database Compatibility Level. Every database has a compatibility level, and in SQL Server 2012, you can go all the way back to compatibility level SQL Server 2005. This makes it so if you have an application that has code specific to a version of SQL Server, you can still have it running on later versions of SQL Server by setting the compatibility level appropriately.
OnBase doesn't have any code specific to versions of SQL Server, so changing the compatibility level hasn't been an issue for us. However, we have some recommendations when changing compatibility levels:
1. Make sure the database compatibility level is the same as the version of the database server it's running on.
2. If you must change it, perform a backup beforehand, change it off hours, and do some testing before releasing it to the users. There shouldn't be any issues, but it always pays to be cautious.
If you have any questions or concerns, feel free to contact your first line of support.
I hope this answers your question.
05-27-2015 12:25 PM
05-29-2015 07:43 AM
06-01-2015 10:01 AM
Dear Seth,
Thank you for using Community. Hope I can solve your issue.
First off, I don't believe you need to head down the path of doing a fresh install of OnBase for a database upgrade. Like Nick said, the backup/restore path has worked fine for our customers.
I believe what your DBAs are referring to is the Database Compatibility Level. Every database has a compatibility level, and in SQL Server 2012, you can go all the way back to compatibility level SQL Server 2005. This makes it so if you have an application that has code specific to a version of SQL Server, you can still have it running on later versions of SQL Server by setting the compatibility level appropriately.
OnBase doesn't have any code specific to versions of SQL Server, so changing the compatibility level hasn't been an issue for us. However, we have some recommendations when changing compatibility levels:
1. Make sure the database compatibility level is the same as the version of the database server it's running on.
2. If you must change it, perform a backup beforehand, change it off hours, and do some testing before releasing it to the users. There shouldn't be any issues, but it always pays to be cautious.
If you have any questions or concerns, feel free to contact your first line of support.
I hope this answers your question.
06-02-2015 09:33 AM
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.