SQL query to find database CMS version

Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more

AI OnAI Off

Home / Forums / Developers (Main Products) Forum / CMS 7.5 - 11 /

amol.mahul

Vote:

Hi,

In my local environment ,I have dozens of databases and I have different version of same site 7,8 and 9. Unfortunately the naming convention is not helping me to find the correct database. I am expecting a simple sql query which I could run againt the database and find the database version compatible to the CMS versions. Basically finding the available database I could link to the various version of CMS site I have

Any pointer?

#173497

Dec 29, 2016 12:29

David Knipe

Vote:

The database version is returned by the dbo.sp_DatabaseVersion stored proc.

David

#173502

Dec 29, 2016 13:17

amol.mahul

Vote:

Executed the Stored Procedue sp_DatabaseVersion did not got any response in the query window. However I could find the version of the database by reading the script for stored procedure. It did the trick for me.

Thanks David :)

#173507

Dec 30, 2016 6:59

Dejan Caric

Vote:

Hi Amol,

As David said, you can execute sp_DatabaseVersion to get the database version:

declare @ver int
exec @ver=sp_DatabaseVersion
print @ver

Next, you can open packages/EPiServer.CMS.Core.X.X.X/tools/epiupdates/sql to find out which database version matches episerver assembly version.

For example:

db version 7036 is used for episerver.cms.core versions between 9.8.3 and 10.0.0, including 9.8.3.

episerver.cms.core 10.0.0 is using db version 7037, etc.

Hope this helps!

#173512

Dec 30, 2016 15:52

amol.mahul

Vote:

Thanks Dejan :) It Surely does help... Happy New Year

#173541

Jan 02, 2017 6:33

This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.