Skip to main content

Optimizely

Databases from the Future: What is Database Version 954?

Robotic Hand Pressing A Keyboard On A Laptop 3d Rendering

Have you started up a new Optimizely site, and prepared your database only get to this error message?

 

Dberror
Reading the error message itself, you’ll see that the created DB version is at 957 where the current version of Optimizely, at the time of this writing, is 904.

Where did this come from?
How do I put my database in a time machine and bring it back to the present?

The good news on both parts of this manageable with a visit from Dr. Emmett Brown. The first question: “Where did this come from?” is a versioning issue. SQL Server 2022 (v16) will create future database if you simply run your database creation against a SQL 2022 instance. This will occur if your default instance is SQL 2022 regardless of how you go about generating your database.

So, that’s how it happens, now how do you create a database that is ready now, instead of a database from the far future? This is where Visual Studio and SQL Server Object Explorer come in handy. Visual Studio installs a database instance for itself, which you can see when you pull up the SQL Server Object Explorer:

You can already see from the screenshot that this is a SQL 2019 instance as it is v15. Right clicking this instance and selecting New Query will open up a new SQL command tab. Here it is a simple matter of running your creation script to create your blank database so Optimizely can configure it on startup.

Sqlcommand

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Greg Jeffers, Senior Technical Consultant

Greg Jeffers is a Senior Technical Consultant with Perficient. He has been developing software on the Microsoft stack for 20+ years and working with Optimizely for 5. Having been in several roles across multiple industries, Greg brings a holistic approach to development. He is passionate about finding the right balance of people and processes to make users feel comfortable in the application while being performant.

More from this Author

Follow Us