When upgrading from an existing implementation using an old database server, you have to manually upgrade your old MS-SQL server with Microsoft free/built-in utility (e.g. Microsoft SQL Management Studio) before upgrading the MobiControl server.  

I have Microsoft SQL Management Studio installed and have used that for backup up the database but didn't know you could use to upgrade a database

Do you have any articles about that or is it really simple

I was thinking of just running the SQL express installer and trying to get it to upgrade the database I currently have

I will try to google for some articles

are there any "gottcha's I need to be aware of or that you have run into

thanks

Larry

I found this method:

To Upgrade a Database by Using Detach and Attach

looks like it might be over my head though

I found a pretty good article about upgrading sql on a SCCM server

https://www.prajwaldesai.com/sccm-sql-server-upgrade/

It's the full sql but should be similiar approach I am guessing

There are just too many variations depending on a specific implementation.  Just look into MS SQL documentation and support web-site, and there are plenty of articles to give you details on how to do it.  Make sure you take VM snapshot and/or other full system back up before you experiment with it, just in case you break something.

As I am not from Soti and you are not my customer,  I rather not say too much just in case you miss or misunderstand something and break your implementation.

For my cases, I personally use "Backup" in the old SQL server to create the FULL database backup file .bak , and "Restore" in the new SQL server.

Hello Harry,

We do this type of activity for our clients in Brazil. We have to work with the on premise business model to compete with local players who practice MDM license prices, sometimes around U $ 0.20 with cloud hosting.

I needed to understand your scenario first. But from the information in your first post I recommend taking a snapshot of the machines or the machine if you are running SQL in conjunction with DS and MS. Make a new machine putting this snapshot for you to work, you will have your disaster recovery scenario ready.

Then you can work with the SQL Express update first, with it running, leave 2-4 days running or the time required for most devices to connect to the server again and you can check everything is right, then continue always taking snapshots / backups and proceed to the update of MobiControl in the version you desire.

Mading a ready scenario for disaster recovery in all actions is the most important thing, we have a rollback history with more than a week successfully executed.

However, if you have to recreate the Windows machine to perform this activity, it becomes a migration and this becomes a little more complicated, with points that involve sanitizing the database, transferring certificates and other points to successfully complete the activity. migration.