SQL Server File Location 檔案位置

SQL Server File Location
SQL Server 檔案位置

Tools	SQL Server	Location
sqlcmd.exe bcp.exe
	SQL 2017	C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn\
	SQL 2016	C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\
	SQL 2014	C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\
	SQL 2012	C:\Program Files\Microsoft SQL Server\110\Tools\Binn\
	SQL 2008 R2	C:\Program Files\Microsoft SQL Server\100\Tools\Binn\
DTSWizard.exe DTExec.exe SSISUpgrade.exe	SQL 2019	C:\Program Files\Microsoft SQL Server\150\DTS\Binn C:\Program Files (x86)\Microsoft SQL Server\150\DTS\Binn
	SQL 2017	C:\Program Files\Microsoft SQL Server\140\DTS\Binn C:\Program Files (x86)\Microsoft SQL Server\140\DTS\Binn
	SQL 2012	C:\Program Files\Microsoft SQL Server\110\ DTS\Binn\ C:\Program Files(x86)\Microsoft SQL Server\110\DTS\Binn\
	SQL 2008 R2	C:\Program Files\Microsoft SQL Server\100\ DTS\Binn\ C:\Program Files(x86)\Microsoft SQL Server\100\DTS\Binn\

Tools	SSMS	Location
AzureDTExec.exe DataProfileViewer.exe DTExec.exe DTExecUI.exe DTSWizard.exe ISDeploymentWizard.exe ISProjectWizard.exe ManagementTool.exe SSISUpgrade.exe		C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\CommonExtensions\Microsoft\SSIS\150\Binn\

Reference:

File Locations for Default and Named Instances of SQL Server
https://docs.microsoft.com/en-us/sql/sql-server/install/file-locations-for-default-and-named-instances-of-sql-server?view=sql-server-ver15

File Locations for Default and Named Instances of SQL Server
https://docs.microsoft.com/en-us/sql/sql-server/install/file-locations-for-default-and-named-instances-of-sql-server
dtexec Utility
https://docs.microsoft.com/en-us/sql/integration-services/packages/dtexec-utility