SQL Server 2019 - Standard to Developer upgrade *

Question

Hi guys,

My company IT support has installed a Standard edition of SQL Server 2019 and I've just noticed it when I tried to deploy SSIS and got deploy error due to Microsoft Connector for Oracle not being compative with SQL Server Standard. The upgrade path from Standard to Developer is not possible, however it could probably me made indirectly, by upgrading to Enterprise and then Developer. Is that possible? From the documentation it seems to be.

Thank you

Answer 1

Hi Swares,

In addition, you can install developer edition side by side and migrate SQL Server Standard database to developer using DMA.
For more details, please refer to tutorials which might be helpful:
SQL Server upgrades
Upgrade SQL Server to SQL Server

Best Regards,
Amelia

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

It might be possible, but I would recommend that you sort this out with your IT department. They want to track which licenses they are using. If you are a developer, it seems like a little wasteful to give you Standard Edition, when Developer Edition is at no cost.

But you also need to consider what your actual task with the Microsoft Connector for Oracle is. If it is for development and testing, it's a fair game. But if you are actually moving data from one production system to another, you cannot use Developer Edition, but you need Enterprise Edition, and obviously your IT department needs to know about that.

Also, even if you only want to use the connector for development and testing, you should make sure that the intended production environment has Enterprise Edition.

Answer 3

Hi,

This is a PoC :-) we are using a frozen image of a Oracle database the customer gave us.

Answer 4

Thank you. I have noticed that Enterprise to Developer is not in the edition upgrade supported paths. I think I will need to do it side by side.