Install SQL Server native client and sqlcmd separately

Source: Internet
Author: User
Tags connect to microsoft sql server
Background

I have a virtual machine that wants to connect to SQL Server, but does not want to install SQL Server.

Solution

SQL Server has a dedicated access client called SQL Server native client, and a command line connection program sqlcmd, in which sqlcmd depends on SQL Server native client. The two can be downloaded from the Microsoft SQL Server 2008 R2 feature package.

Microsoft SQL Server 2008 R2 native Client

Microsoft SQL Server 2008 R2 native client (SQL Server native client) is a dynamic link library (DLL) that includes both the SQL ole db access interface and the SQL ODBC driver ). It provides runtime support for applications that use local code APIs (ODBC, ole db, and ADO) to connect to Microsoft SQL Server 2000, 2005, or 2008. SQL native client should be used to create new applications or to enhance existing applications that need to use new functions of SQL Server 2008 R2. SQL Server native client this reseller installer is used to install the client components required for running, to take advantage of the new features of SQL Server 2008 R2, it can also install and develop header files required for applications that use SQL Server native client APIs.

:

  1. X86 package(Sqlncli. MSI)
  2. X64 package(Sqlncli. MSI)
  3. IA64 package(Sqlncli. MSI)

Note: Windows Server 2008r2 can only install the x64 installation package, because the system is 64-bit, and the following sqmcmd is both 64-bit and 32-bit.

Microsoft SQL Server 2008 R2 command line utility

You can use the sqlcmd utility to connect SQL Server 7.0, SQL Server 2000, SQL Server 2005, SQL Server 2008, and 2008 R2 instances, and send a Transact-SQL batch, and output the row set information from these instances. The BCP utility can replicate large data volumes between a Microsoft SQL Server 2008 R2 instance and a data file in a specified format. The BCP utility can be used to import a large number of new rows to SQL Server tables or export table data to data files.

Note:This component requiresWindows Installer 4.5AndMicrosoft SQL Server native Client(Another component provided on this page ).

:

  1. X86 package(Sqlcmdlnutils. MSI)
  2. X64 package(Sqlcmdlnutils. MSI)
  3. IA64 package(Sqlcmdlnutils. MSI)

 

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.