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.
:
- X86 package(Sqlncli. MSI)
- X64 package(Sqlncli. MSI)
- 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 ).
:
- X86 package(Sqlcmdlnutils. MSI)
- X64 package(Sqlcmdlnutils. MSI)
- IA64 package(Sqlcmdlnutils. MSI)