Как перенести базу Контур.Экстерн Лайт из SQL Server Express в SQL Server Standart
При достижении базы с типом SQL Server Express размера 10 ГБ вы не сможете отправлять и получать документы, поскольку это максимально допустимый размер базы для этого типа.
При большом размере базы данных SQL Server Express воспользуйтесь одним из вариантов:
Перенесите базу данных в SQL Server Standart
Рекомендуется, чтобы перенос базы и настройку сделал ваш системный администратор, с учетом специфики доменной политики, размещения серверов, политики аутентификации.
1.Создайте и сохраните Backup базы данных, которая находится на SQL Server Express.
2. Установите и настройте SQL Server редакции выше чем Express (например, редакции Standart или Developer).
3. В установленной редакции SQL Server восстановите базу данных из созданного в п.1. Backup-а.
4. Настройте Контур.Экстерн Лайт на работу с базой в установленной редакции SQL Server согласно инструкции. Укажите новые имя сервера и параметры аутентификации, если они изменились.
Создайте новую базу данных SQL Server Express (временное решение)
Воспользуйтесь данным вариантом, если у вас по каким-то причинам нет возможности перенести базу из SQL Server Express в SQL Server Standart. При этом старых отчетов в новой базе не будет.
1. Выберите в Контур.Экстерн Лайт меню «Настройки / Параметры соединения с базой данных…».
2. В строке «Имя базы данных:» впишите новое имя файла: например, RSBase2.sdf вместо RSBase.sdf:
3. Нажмите «Сохранить» и перезапустите Контур.Экстерн Лайт. После перезапуска добавьте пользователя.
4. При первом нажатии «Отправить и получить», Контур.Экстерн Лайт предложит скачать все документа с сервера. Выберите ползунком не все документы, а за определенный период: например, начиная с текущего месяца (либо за более ранний период при необходимости) и н ажмите «ОК».
Edition Upgrade and Downgrade in SQL Server
Have you ever needed to upgrade or downgrade the SQL Server edition you already installed? Maybe you currently have Enterprise Edition and have discovered that you can save money on licensing if you downgrade to Standard Edition. These steps will walk through both scenarios of upgrading or downgrading the edition and demonstrate how to complete either option.
Solution
The ability to upgrade your SQL Server Edition is built-in to the installer. We will walk through the steps to complete this action.
The downgrade operation is a bit more complicated and requires some backups and uninstallations. We will walk through all the necessary steps to complete the Edition downgrade and have your system back online with all the original settings/configurations.
Edition Upgrade in SQL Server
Let’s get started with the Edition Upgrade.
Currently, the SQL Server instance is running Standard Edition as shown above.
Locate the Setup.exe and launch the SQL Server Installer for the version that matches the current server instance.
Choose Maintenance > Edition Upgrade.
- When prompted, enter the Product Key information or accept the Product Key that is populated automatically.
- Select Next then Accept the License Terms and select Next again.
- If your server has multiple instances, choose the one where you want to upgrade Editions. If you only have one, leave the defaults and click Next.
- Finally, choose Upgrade to start the Edition Upgrade process.
- You will see a Results section and all the features should show a Succeeded status when the process finishes.
- Click Close and then Exit the Installer.
Proceed back to SSMS and login to the SQL Server instance. View the properties of the SQL Server instance. The results should show that the SQL Server Edition is now Enterprise as shown below.
The Enterprise Edition of SQL Server is now running this instance and everything is fully functional.
Downgrade SQL Server Enterprise to Standard Edition
This section is going to depend on how comfortable you are restoring the SQL Server master database. Downgrading SQL Server Editions using this method might be risky for some individuals. However, just like "never shrink your data files", there are circumstances when such an action is warranted.
The following steps show how to downgrade the SQL Server edition while still maintaining the information in your master database.
This screenshot above shows that there are currently two SQL Server logins, one user table, and two user stored procedures in the existing Enterprise Edition of SQL Server instance.
The steps below will prepare the server downgrade to Standard Edition.
First, perform a full database backup of the master database using a command similar to the below or using SSMS.
The next set of steps will sound aggressive, but they are necessary and safe. The uninstallation of SQL Server will now be executed on the server.
- Navigate to the Control Panel and choose Uninstall a program under the Programs section.
- Find Microsoft SQL Server 2016 (64-bit) or the appropriate version on your server.
- Click Uninstall/Change, then click Remove.
- The SQL Server Installer will launch and list all the SQL Server Instances currently installed on the server.
- Choose the SQL Server instance you want to downgrade and click Next.
- Click Select All to remove all SQL Server components from the server for this instance and click Next.
- Now click Remove to begin the uninstallation operation.
- You will see a Results section and all features should show a Succeeded status when the process finishes.
- Click Close, then refresh the Programs and Features windows, and you should not see SQL Server in the list.
- At this point, a server Restart is required.
Locate the setup.exe and launch the SQL Server Installer for Standard Edition.
Navigate through the prompts as would be normal during a typical SQL Server installation.
Apply all the SQL Server patches required to get to the same patch version as your Enterprise before the uninstallation.
The image above is an example showing a blank/fresh SQL Server Standard Edition installation.
Perform a full database backup of the master database using the below command or use SSMS.
From the SQL Server Configuration Manager, stop the SQL Server services.
Open a Command Prompt window as Administrator and navigate to the Binn directory for the SQL Server instance (example: E:\DATA\MSSQL13.MSSQLSERVER\MSSQL\Binn).
Run the command:
SQL Server will be launched in single-user mode from the Command Prompt by running this command.
Open another Command Prompt window as Administrator and run:
Executing the above command will connect to the SQL Server Instance and allow you to execute T-SQL commands.
Use the backup taken earlier of the master database from the Enterprise Edition version in your restore command as follows.
Once the restore command is successfully completed, close both open Command Prompt windows.
From the SQL Server Configuration Manager, start the SQL Server services.
Once the SQL Server services are started, the restore that was done will have recovered the Logins, Table, and Stored Procedures from the backup taken of the Enterprise Edition to the new Standard Edition server.
Conclusion
These steps walked through the process of Upgrading a stand-alone SQL Server instance from Standard Edition to Enterprise Edition. The opposite has been achieved by taking steps of Downgrading Enterprise Edition to Standard Edition without losing any of your system-level settings.
Upgrading to Microsoft SQL Standard from a 64-bit instance of SQL Express.
This article discusses the steps to upgrade to Microsoft SQL Server Standard Edition assuming you’re currently on a 64-bit instance of SQL Express (2016 and later.)
Acctivate includes the free Microsoft SQL Server Express Edition. You can easily upgrade to SQL Server Standard Edition for increased capacity and performance when necessary.
Please note: This article only applies to SQL server instances that are running on 64-bit SQL server. If you are on a 32-bit version of SQL server (SQL 2014 or lower), you will have to create a new instance of SQL server standard and migrate your data over. We have an article about that here.
Instructions
Note, different SQL Editions may have different upgrade processes.
For newer upgrades to an existing instance, start by using the SQL Server Installation Center. Then select Maintenance and Edition Upgrade to access the Product Key window.
Microsoft SQL Server Edition upgrades are handled through the standard SQL Server installer (setup.exe).
The main difference is that you will be required to enter the product key for SQL Server Standard Edition. Choosing the free Evaluation option is not recommended since it will expire in 180 days with no warning.
You will also want to verify the Ready to Upgrade Summary includes Edition: Standard and Action: Upgrade.
Then, click Upgrade to start the process. The Upgrade Process will take awhile and SQL Server will be offline until the upgrade is Complete.
Note: Microsoft SQL Server licenses must be purchased from Microsoft or a license reseller. Alterity does not sell SQL Server licenses or client access licenses (CALs).
Upgrade from SQL Server 2014 Express to Standard Edition
This article will describe the steps to upgrade a SQL Server 2014 Express to Standard. Since the release of 2008 R2 it is quite simplified to do this kind of edition upgrades and it is almost the same for every version after 2008 R2. Before that version, you needed to start the setup with “SKUUPGRADE=1”, the command in older versions is:
Here I’ll show the steps to perform an edition upgrade from SQL Server 2014 Express to Standard.
- First start the SQL Server 2014 installer, click on the maintenance tab and here you see the option “Edition Upgrade”, launch this option.
- After launching the “Edition Upgrade” option, you’ll see a new window that SQL Server 2014 Setup is processes the current operation, just have some patience.
- After it’s done with “processes” again a new window will pop. Select the radio button before “Enter the product key” and click on Next.
- Read the License Terms carefully and if you want to continue the upgrade, accept them by ticking the before “I accept the license terms.”, after that click on Next.
- After you click on Next the Global and Edition Upgrade Rules will perform some checks, if this check goes without any problems the Select Instance step is shown automatically.
- Select the instance of SQL Server you want to upgrade and click on Next.
- The Feature Rules step will perform 6 checks and again if no errors occur, you’ll be brought to the “Ready to upgrade edition” step.
- Here you can see the summary of features that will be chanced, if this is looking good, click Upgrade.
- After the upgrade is complete, you can close the window.
