Managing SQL Server using CentOS 7

In the previous article, we completed the functional components of SQL, and then we then how to connect to manage the use of this CentOS SQL Server.

We can download a SQL manager for connection use, this SQL Manager recommends downloading in Https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms

650) this.width=650; "title=" clip_image001 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image001" src= "Http://s3.51cto.com/wyfs02/M02/99/0B/wKioL1lDV4qCg-r_AAI31r182p0988.png" height= "484"/>

What is the benefit of this SQL manager? Look, is not feeling good, compatibility and many versions that can be connected, including SQL Yo on Azure.

650) this.width=650; "title=" clip_image002 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image002" src= "Http://s3.51cto.com/wyfs02/M00/99/0C/wKiom1lDV4vTRX5zAAIPvMrcplo747.png" height= "461"/>

Of course support Chinese yo

650) this.width=650; "title=" clip_image001[4] "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "Clip_image001[4]" src= "Http://s3.51cto.com/wyfs02/M01/99/0B/wKioL1lDV4zAaZDeAAEctckUbdY769.png" height= "484"/ >

Start installation

650) this.width=650; "title=" clip_image003 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image003" src= "Http://s3.51cto.com/wyfs02/M01/99/0B/wKioL1lDV47SUrzoAACERUactqk384.png" height= "484"/>

Here i download install and try to connect my centossql look, using SQL Manager to connect SQL Server on CentOS and SQL Server on Windows is no different. Enter the server name or Ip,sa and password to do so.

650) this.width=650; "title=" clip_image001[6] "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "Clip_image001[6]" src= "http://s3.51cto.com/wyfs02/M02/99/0B/wKioL1lDV4-BqLPhAACE8iA6-j4785.png" height= "337"/ >

You can see a lot of this type of connection.

650) this.width=650; "title=" clip_image002[4] "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "Clip_image002[4]" src= "Http://s3.51cto.com/wyfs02/M02/99/0C/wKiom1lDV5DADptfAADX-0jxzkM989.png" height= "351"/ >

Here I connect my deployed Centossql

650) this.width=650; "title=" clip_image003[4] "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "Clip_image003[4]" src= "Http://s3.51cto.com/wyfs02/M02/99/0B/wKioL1lDV5KQ53W6AADaJtN__Ps164.png" height= "293"/ >

Take a look at our SQL properties

650) this.width=650; "title=" clip_image004 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image004" src= "Http://s3.51cto.com/wyfs02/M00/99/0C/wKiom1lDV5PDfkpoAAGQ_jCMYyk252.png" height= "419"/>

Check out our SQL database default location

650) this.width=650; "title=" clip_image005 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image005" src= "Http://s3.51cto.com/wyfs02/M02/99/0B/wKioL1lDV5SSNM6YAAFs__aVV-g012.png" height= "484"/>

We can also create a new database

650) this.width=650; "title=" clip_image006 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image006" src= "http://s3.51cto.com/wyfs02/M00/99/0B/wKioL1lDV5bhY751AAFv8CRUJqU110.png" height= "420"/>

You can also select a compatibility level for the database

650) this.width=650; "title=" clip_image007 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image007" src= "Http://s3.51cto.com/wyfs02/M00/99/0B/wKioL1lDV5fSGxg1AAGVj9-TFp8840.png" height= "484"/>

In terms of security, service roles and logins are about the same as Windows

650) this.width=650; "title=" clip_image008 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image008" src= "Http://s3.51cto.com/wyfs02/M01/99/0B/wKioL1lDV5uDK_viAADMjrQjSx4553.png" height= "484"/>

In addition, we can manage our SQL on the Centossql host (because we have previously installed sqlcmd and BCP on this host, the SQL Server command-line tools)

Perform sqlcmd

650) this.width=650; "title=" clip_image009 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image009" src= "Http://s3.51cto.com/wyfs02/M02/99/0C/wKiom1lDV52g0EdaAADE3OcqYfM289.png" height= "272"/>

Connect to SQL

650) this.width=650; "title=" clip_image010 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image010" src= "http://s3.51cto.com/wyfs02/M02/99/0B/wKioL1lDV53wyGCKAAAiLB_qHgE464.png" height= "/>"

Run a simple query, query all database names, and see the database I just created from the SQL manager

650) this.width=650; "title=" clip_image011 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;padding-left:0px;border-left:0px;margin:0px;padding-right:0px; "border=" 0 "alt = "clip_image011" src= "Http://s3.51cto.com/wyfs02/M00/99/0B/wKioL1lDV57iqn74AABaHXkHmyw821.png" height= "209"/>

Well, let's introduce it, SQL commands are available on Centossql.

This article is from the "Zjunsen Cloud computing" blog, so be sure to keep this source http://rdsrv.blog.51cto.com/2996778/1937409

Managing SQL Server using CentOS 7