3
I have installed an instance 2012 Express, I need to update to the Standard, but to update I need to make sure that there will be no changes in the databases.
3 answers
3
In theory there will be no problems, there is full compatibility.
But if you are unsure, take a test first to be sure. In fact you can lose by wrong tricks. So it is good to do carefully, test before in out-of-production environment, have backup if you need to go back.
2
Not.
This link teaches you how to do the installation steps. In any case, I recommend a backup of schema + dice. There’s a step-by-step for that here.
2
Every time I installed different versions of SQL Server side-by-side, they always coexisted without touching each other’s data. By the way, ever wondered how many distracted people would lose their data accidentally if that were not the case? The fury of Dbas against Microsoft? :)
But the saying goes, insurance died of old.
Even if all manuals, explanations and tests work without losing data, you should do what is always recommended for database maintenance: backup.
The real world is cruel, and no matter how hard you try to follow the right steps to not lose your data (in whole or in part), Murphy’s Law is our eternal adversary and one day it comes into action.
The recommended is not only to take backup of your bank but also to test the restore procedure regularly, so you don’t find that backups don’t only work when you need them.
Browser other questions tagged sql database sql-server
You are not signed in. Login or sign up in order to post.
Just supplementing... For the backup: https://msdn.microsoft.com/pt-br/library/ms187510(v=sql.120). aspx
– mauricio caserta