As business data grows, the number of single tables is already billions and the data being queried is getting slower, so consider partitioning the database tables and upgrading the database to SQL Server 2012. There were no more considerations at the time, and the SQL Server Standard Edition version was installed on the server. When testing the data, it is found that the partition is not supported and must be Enterprise Edition, here is a record of how to upgrade Standard Edition to Enterprise Edition.
1. Locate the original installation file and run the Setup.exe
Run as above interface, click Maintenance, click on the right version to upgrade.
2. Next step Next
When you reach the above interface, be aware of it. Enter the product key and find an enterprise version of the key online, which provides an available fh666-y346v-7xfq3-v69jm-rhw28
3. Next, upgrade on the original DB instance
4. Continue the next few minutes after the upgrade is complete
Kat Warehouse Management System-. SQL Server 2012 Upgrade Enterprise Edition