Automatic one-click deploying method for SQL Server

An automatic deployment and automatic installation technology, applied in the computer field, can solve problems such as waste of human resources and troubles, and achieve the effect of high security and simple operation steps

Inactive Publication Date: 2017-05-10
GUANGXI POWER GRID CORP
View PDF3 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The conventional SQL Server installation method is manual installation. Copy the installation package and place it on the target virtual machine, and then click Install. During the installation, a UI window will pop up, prompting you to choose to install the server components, tools, online books and examples. Click to select the option to be installed, then select the installation instance name, then select the authentication mode, and select the installation path. These will allow users to choose manually, which is troublesome and wastes human resources.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0040] One-click deployment and installation of SQL Server 2005 on the virtual machine of windows server 2008 R2 x64, the installation steps are as follows:

[0041] 1) Apply for a virtual machine whose operating system is windows server 2008 R2 x64. The virtual machine configuration parameters are: 2CPU, 4 cores, 16G memory, and 500GB disk.

[0042] 2) Deploy the automated installation script in the virtual machine in step 1), and place the SQL Server 2005 installation package on the remote resource library server.

[0043] 3) Configure the silent installation file (ConfigurationFile.ini). The configuration file of the SQL Server 2005 version includes the following main configuration items:

[0044] (1) Specify the installation directory, its value is:

[0045] INSTALLSQLDIR="C:\Program Files\Microsoft SQL Server\";

[0046] (2) Specify the OLAP data directory, whose value is:

[0047] INSTALLOLAPDATADIR="C:\Program Files\Microsoft SQL Server\MSSQL\OLAP\Data";

[0048] (3...

Embodiment 2

[0088] One-click deployment of SQL Server 2008 on Windows Server 2008 R2 x64.

[0089] 1) Apply for a virtual machine whose operating system is windows server 2008 R2 x64. The virtual machine configuration parameters are: 2CPU, 4 cores, 16G memory, and 500GB disk.

[0090] 2) Deploy the automated installation script in the virtual machine, and place the installation package on the remote resource library server.

[0091] 3) Configure the silent installation file (ConfigurationFile.ini). The configuration file of the SQL Server 2008 version includes the following main configuration items:

[0092] (1) The specified SQL Server feature specifies the instance ID, and the SQL Server directory structure, registry structure, and service name will reflect the instance ID of the SQL Server instance, whose value is:

[0093] INSTANCEID="MSSQLSERVER";

[0094] (2) Specify the workflow of the installer, specified as Install, and its value is:

[0095] ACTION="Install";

[0096] (3) Sp...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses an automatic one-click deploying method for an SQL Server, and belongs to the technical field of computers. The automatic one-click deploying method includes the following installation steps that 1) an automatic script installer and an installation package are initialized; 2) to-be-installed SQL Server database parameters are input; 3) an SQL Server database is installed; 4) memory parameters and a shared IP are adjusted. Installing operation of operation and maintenance staff can be replaced, it is avoided that UI page reminding is popped up, a ConfigurationFile.ini silence configuration file is set and modified, configurations of SQL Server related parameters are set, a security patch is installed for the installed SQL Server, safety is high, and the operating steps are simple.

Description

technical field [0001] The invention belongs to the technical field of computers, and in particular relates to a one-key automatic deployment method of SQL Server. Background technique [0002] The SQL Server database is a relational database system launched by Microsoft Corporation. SQL Server database is an extensible, high-performance database management system involved in distributed client / server computing. It realizes the organic combination with Microsoft's operating system—Windows NT, and provides transaction-based enterprise-level information. Management system scheme. [0003] The conventional SQL Server installation method is manual installation. Copy the installation package and place it on the target virtual machine, and then click Install. During the installation, a UI window will pop up, prompting you to choose to install the server components, tools, online books and examples. Click to select the option to be installed, then select the installation instance...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30G06F9/445
CPCG06F8/61G06F16/21
Inventor 陈祖斌杭聪袁勇黄连月谢铭蒙亮莫英红陆冰芳黄鑫
Owner GUANGXI POWER GRID CORP
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap