·þÎñÆ÷ϵͳ¼¯³É¼°Êý¾Ý·þÎñÖÐÐÄ

 

Ò»¼¶À¸Ä¿
Ò»¼¶À¸Ä¿
Ò»¼¶À¸Ä¿
Ò»¼¶À¸Ä¿
Ò»¼¶À¸Ä¿
Ò»¼¶À¸Ä¿
Ò»¼¶À¸Ä¿
Ò»¼¶À¸Ä¿
¡¾å¸‚场动æ€?¡¿¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­>>>

ÊÊÓÃ2008ÒÔºóËùÓÐMSSQL°æ±¾µÄ×îÐÂÆóÒµ¹ÜÀíÆ÷SQL Server Management Studio (SSMS)18.11.1

ÏÂÔØ SQL Server Management Studio (SSMS)

ÊÊÓÃÓÚ£ºyesSQL Server£¨ËùÓÐÖ§³ÖµÄ°æ±¾£©YesAzure SQL Êý¾Ý¿âYesAzure SQL ÍйÜʵÀýyesAzure Synapse Analytics

SQL Server Management Studio (SSMS) ÊÇÒ»ÖÖ¼¯³É»·¾³£¬ÓÃÓÚ¹ÜÀí´Ó SQL Server µ½ Azure SQL Êý¾Ý¿âµÄÈκΠSQL »ù´¡½á¹¹¡£ SSMS ÌṩÓÃÓÚÅäÖᢼàÊӺ͹ÜÀí SQL Server ºÍÊý¾Ý¿âʵÀýµÄ¹¤¾ß¡£ ʹÓà SSMS ²¿Êð¡¢¼àÊÓºÍÉý¼¶Ó¦ÓóÌÐòʹÓõÄÊý¾Ý²ã×é¼þ£¬ÒÔ¼°Éú³É²éѯºÍ½Å±¾¡£

ʹÓà SSMS ÔÚ±¾µØ¼ÆËã»ú»òÔƶ˲éѯ¡¢Éè¼ÆºÍ¹ÜÀíÊý¾Ý¿â¼°Êý¾Ý²Ö¿â£¬ÎÞÂÛËüÃÇλÓںδ¦¡£

ÏÂÔØ SSMS

SQL Server Management Studio (SSMS) 18.11.1 µÄÃâ·ÑÏÂÔØ

SSMS 18.11 ÊÇ×îÐÂÕýʽ·¢²¼ (GA) °æ±¾¡£ Èç¹û°²×°µÄÊÇ SSMS 18 ¾ÉµÄ GA °æ±¾£¬Çë°²×° SSMS 18.11.1 ½«ËüÉý¼¶µ½ 18.11.1¡£

  • °æ±¾ºÅ£º18.11.1
  • Éú³ÉºÅ£º15.0.18410.0
  • ·¢²¼ÈÕÆÚ£º2022 Äê 3 Ô 8 ÈÕ

ʹÓà SQL Server Management Studio£¬¼´±íʾÄãͬÒâÆäÐí¿ÉÌõ¿îºÍÒþ˽ÉùÃ÷¡£ Èç¹ûÄãÓÐÈκÎÒâ¼û»ò½¨Ò飬»òÏ뱨¸æÎÊÌ⣬×îºÃÊÇͨ¹ý SQL Server Óû§·´À¡Óë SSMS ÍŶÓÁªÏµ¡£

SSMS 18.x °²×°²»»áÉý¼¶»òÌæ»» SSMS 17.x »ò¸üÔç°æ±¾¡£ SSMS 18.x ÓëÒÔÇ°µÄ°æ±¾²¢Ðа²×°£¬Òò´Ë£¬ÕâÁ½¸ö°æ±¾¾ù¿É¹©Ê¹Óᣠ²»¹ý£¬Èç¹û°²×°µÄÊÇ SSMS 18.x Ô¤ÀÀ°æ£¬Ôò±ØÐëÔÚ°²×° SSMS 18.11 ǰжÔØËü¡£ ¿ÉÒÔתµ½¡°°ïÖúºÍ¹ØÓÚ¡±´°¿Ú²é¿´ÊÇ·ñÓÐÔ¤ÀÀ°æ¡£

Èç¹û¼ÆËã»ú°üº¬ SSMS µÄ²¢Ðа²×°£¬ÇëÑéÖ¤ÄãÊÇ·ñÕë¶ÔÌض¨ÐèÇóÆô¶¯ÏàÓ¦µÄ°æ±¾¡£ ×îа汾±ê¼ÇΪ Microsoft SQL Server Management Studio 18¡£

 ÖØÒª

´Ó SQL Server Management Studio (SSMS) 18.7 ¿ªÊ¼£¬Azure Data Studio ½«×Ô¶¯Óë SSMS Ò»Æð°²×°¡£ SQL Server Management Studio µÄÓû§ÏÖÔÚ¿ÉÒÔ´Ó Azure Data Studio µÄ´´Ðº͹¦ÄÜÖлñÒæ¡£ Azure Data Studio ÊÇÊÊÓÃÓÚÄãµÄ»·¾³µÄ¿çƽ̨¿ªÔ´×ÀÃ湤¾ß£¬ÎÞÂÛÊÇÔÚÔÆÖС¢±¾µØ»¹ÊÇ»ìºÏ»·¾³ÖС£

ÈôÒªÁ˽âÓÐ¹Ø Azure Data Studio µÄÏêϸÐÅÏ¢£¬Çë²é¿´Ê²Ã´ÊÇ Azure Data Studio »ò³£¼ûÎÊÌâ½â´ð¡£

¿ÉÓÃÓïÑÔ

´Ë°æ±¾µÄ SSMS ¿ÉÒÔ°²×°ÔÚÒÔÏÂÓïÑÔÖУº

SQL Server Management Studio 18.11.1£º
ÖÐÎÄ£¨¼òÌ壩 | ÖÐÎÄ£¨·±Ì壩 | Ó¢ÓÃÀ¹ú£© | ·¨Óï | µÂÓï | Òâ´óÀûÓï | ÈÕÓï | ³¯ÏÊÓï | ÆÏÌÑÑÀÓ°ÍÎ÷£© | ¶íÓï | Î÷°àÑÀÓï

 Ìáʾ

Èç¹ûÄãÕýÔÚ´ÓÒ»¸ö·ÇÓ¢ÓïµÄÓïÑÔ°æ±¾·ÃÎÊ´ËÒ³£¬²¢ÏëÒª²é¿´×îÐÂÄÚÈÝ£¬ÇëÑ¡Ôñ´ËÒ³¶¥²¿µÄ¡°Ê¹ÓÃÓ¢ÓïÔĶÁ¡±¡£ ¿ÉÒÔͨ¹ýÑ¡Ôñ¿ÉÓÃÓïÑÔ´ÓÓ¢ÓÃÀ¹ú£©°æ±¾Õ¾µãÏÂÔز»Í¬µÄÓïÑÔ¡£

 ±¸×¢

SQL Server PowerShell Ä£¿é¿Éͨ¹ý PowerShell ¿âµ¥¶À°²×°¡£ ÓйØÏêϸÐÅÏ¢£¬Çë²ÎÔÄÏÂÔØ SQL Server PowerShell Ä£¿é¡£

ÐÂÔö¹¦ÄÜ

Óйش˰汾ÖÐÐÂÔö¹¦Äܵĸü¶àÏêϸÐÅÏ¢£¬Çë²ÎÔÄ SQL Server Management Studio ·¢ÐÐ˵Ã÷¡£

ÒÔÇ°µÄ°æ±¾

±¾ÎĽöÊÊÓÃÓÚ×îа汾µÄ SSMS¡£ ÈôÒªÏÂÔØ SSMS µÄÔçÆÚ°æ±¾£¬Çë·ÃÎÊ SSMS µÄÔçÆÚ°æ±¾¡£

 ±¸×¢

×Ô 2021 Äê 12 ÔÂÆð£¬18.6 °æ֮ǰµÄ SSMS °æ±¾½«²»ÄÜÔÙʹÓà MFA ͨ¹ý Azure Active Directory ¶ÔÊý¾Ý¿âÒýÇæ½øÐÐÉí·ÝÑéÖ¤¡£ ÈôÒª¼ÌÐø½« MFA Óë Azure Active Directory Éí·ÝÑéÖ¤½áºÏʹÓã¬ÐèÒª SSMS 18.6 »ò¸ü¸ß°æ±¾¡£

ʹÓà MFA ͨ¹ý Azure Active DirectoryÁ¬½Óµ½ Azure Analysis Services ÐèÒª SSMS 18.5.1 »ò¸ü¸ß°æ±¾¡£

ÎÞÈ˲ÎÓë°²×°

»¹¿ÉÒÔʹÓÃÃüÁîÌáʾ·û½Å±¾°²×° SSMS¡£

Èç¹ûÒªÔÚûÓÐ GUI ÌáʾµÄÇé¿öÏÂÔÚºǫ́°²×° SSMS£¬ÇëÖ´ÐÐÒÔϲ½Öè¡£

  1. ʹÓÃÌáÉýµÄȨÏÞÆô¶¯ÃüÁîÌáʾ·û¡£

  2. ÔÚÃüÁîÌáʾ·ûϼüÈëÒÔÏÂÃüÁî¡£

    ¿ØÖÆ̨
     start "" /w <path where SSMS-Setup-ENU.exe file is located> /Quiet SSMSInstallRoot=<path where you want to install SSMS>
    

    ʾÀý£º

    ¿ØÖÆ̨
    start "" /w %systemdrive%\SSMSfrom\SSMS-Setup-ENU.exe /Quiet SSMSInstallRoot=%systemdrive%\SSMSto
    

    ÄãÒ²¿ÉÒÔ´«µÝ /Passive ¶ø²»ÊÇ /Quiet À´²é¿´ÉèÖà UI ¡£

  3. Èç¹ûÒ»ÇÐÕý³££¬Äã¿ÉÒÔ¿´µ½ SSMS °²×°ÔÚ %systemdrive%\SSMSto\Common7\IDE\Ssms.exe ÖУ¨¾ßÌåÊÓʾÀý¶ø¶¨£©¡£ Èç¹û³öÏÖ¹ÊÕÏ£¬¿ÉÒÔ¼ì²é·µ»ØµÄ´íÎó´úÂ룬²¢ÔÚ %TEMP%\SSMSSetup ´¦²é¿´ÈÕÖ¾Îļþ¡£

ʹÓà Azure Data Studio °²×°

  • ´Ó SSMS 18.7 ¿ªÊ¼£¬Ä¬ÈÏÇé¿öÏ£¬SSMS »á°²×° Azure Data Studio µÄϵͳ°æ±¾¡£ Èç¹ûÓëË渽µÄ Azure Data Studio °æ±¾Ïà±È£¬²»µÍÓڸð汾µÄ Azure Data Studio Îȶ¨°æ»òÔ¤ÀÀÌåÑé°æ±¾µÄϵͳ°æ±¾ÒÑ´æÔÚÓÚ¹¤×÷Õ¾ÉÏ£¬Ôò»áÌø¹ýʹÓà SSMS °²×° Azure Data Studio µÄ²½Öè¡£ ¿ÉÒÔÔÚ·¢ÐÐ˵Ã÷ÖÐÕÒµ½ Azure Data Studio °æ±¾¡£
  • Azure Data Studio ϵͳ°²×°³ÌÐòÐèÒªÓë SSMS °²×°³ÌÐòÏàͬµÄ°²È«È¨ÏÞ¡£
  • Azure Data Studio °²×°ÊÇʹÓÃĬÈÏ Azure Data Studio °²×°Ñ¡ÏîÍê³ÉµÄ¡£ ËüÃÇÓÃÓÚ´´½¨¡°¿ªÊ¼¡±²Ëµ¥Îļþ¼Ð²¢½« Azure Data Studio Ìí¼Óµ½Â·¾¶¡£ ²»»á´´½¨×ÀÃæ¿ì½Ý·½Ê½£¬Ò²²»»á½« Azure Data Studio ×¢²áΪÈκÎÎļþÀàÐ͵ÄĬÈϱ༭Æ÷¡£
  • Azure Data Studio µÄ±¾µØ»¯Í¨¹ýÓïÑÔ°üÀ©Õ¹À´ÊµÏÖ¡£ ÈôÒª±¾µØ»¯ Azure Data Studio£¬Çë´ÓÀ©Õ¹Êг¡ÏÂÔØÏàÓ¦µÄÓïÑÔ°ü¡£
  • ´Ëʱ£¬¿ÉÒÔͨ¹ýʹÓÃÃüÁîÐбê¼Ç DoNotInstallAzureDataStudio=1 Æô¶¯ SSMS °²×°³ÌÐòÀ´Ìø¹ý Azure Data Studio µÄ°²×°¡£

жÔØ

Èç¹ûÔÚ SSMS °²×°ÆÚ¼äÈ·¶¨È±ÉÙ¹²Ïí×é¼þ£¬SSMS ¿ÉÄܻᰲװÕâЩ×é¼þ¡£ жÔØ SSMS ʱ£¬SSMS ²»»á×Ô¶¯Ð¶ÔØÕâЩ×é¼þ¡£

¹²Ïí×é¼þ°üÀ¨£º

  • Azure Data Studio
  • Microsoft .NET Framework 4.7.2
  • ÊÊÓÃÓÚ SQL Server µÄ Microsoft OLE DB Çý¶¯³ÌÐò
  • Microsoft ODBC Driver 17 for SQL Server
  • Microsoft Visual C++ 2013 Redistributable (x86)
  • Microsoft Visual C++ 2017 Redistributable (x86)
  • Microsoft Visual C++ 2017 Redistributable (x64)
  • Microsoft Visual Studio Tools for Applications 2017

ÓÉÓÚÕâЩ×é¼þ¿ÉÄÜÓëÆäËû²úÆ·¹²Ïí£¬Òò´Ë²»»áжÔØ¡£ Èç¹ûжÔØÁËÕâЩ×é¼þ£¬Ôò¿ÉÄÜ»áÓöµ½ÆäËû²úÆ·±»½ûÓõķçÏÕ¡£

Ö§³ÖµÄ SQL ²úÆ·/·þÎñ

  • ´Ë°æ±¾µÄ SSMS ÊÊÓÃÓÚËùÓÐÊÜÖ§³Ö SQL Server 2008 °æ±¾ - SQL Server 2019 (15.x)£¬²¢ÇÒÔÚ×î´ó³Ì¶ÈÉÏÖ§³ÖÓë Azure SQL Êý¾Ý¿âºÍ Azure Synapse Analytics ÖеÄ×îÐÂÔƹ¦ÄÜÅäºÏʹÓá£
  • ´ËÍ⣬SSMS 18.x ¿ÉÓë SSMS 17.x¡¢SSMS 16.x »ò SQL Server 2014 SSMS ¼°ÔçÆÚ°æ±¾²¢Ðа²×°¡£
  • SQL Server Integration Services (SSIS) - SSMS °æ±¾ 17.x »ò¸ü¸ß°æ±¾²»Ö§³ÖÁ¬½Óµ½¾É°æ SQL Server Integration Services ·þÎñ¡£ ÒªÁ¬½Óµ½ÔçÆÚ°æ±¾µÄ Integration Services£¬ÇëʹÓÃÓë SQL Server °æ±¾Ò»Ö嵀 SSMS °æ±¾¡£ ÀýÈ磬ʹÓà SSMS 16.x Á¬½Óµ½¾É°æ SQL Server 2016 Integration Services ·þÎñ¡£ ¿ÉÒÔÔÚͬһ̨¼ÆËã»úÉϲ¢Ðа²×° SSMS 17.x ºÍ SSMS 16.x¡£ ÓÉÓÚ SQL Server 2012 µÄ·¢²¼£¬½¨ÒéʹÓà SSIS Ŀ¼Êý¾Ý¿â (SSISDB) À´´æ´¢¡¢¹ÜÀí¡¢ÔËÐкͼàÊÓ Integration Services °ü¡£ ÓйØÏêϸÐÅÏ¢£¬Çë²ÎÔÄ SSIS Ŀ¼¡£

SSMS ϵͳҪÇó

µ±Óë×îпÉÓõķþÎñ°üÒ»ÆðʹÓÃʱ£¬SSMS µÄµ±Ç°°æ±¾Ö§³ÖÒÔÏ 64 λƽ̨£º

Ö§³ÖµÄ²Ù×÷ϵͳ£º

  • Windows 11£¨64 룩
  • Windows 10£¨64 룩1607 (10.0.14393) »ò¸ü¸ß°æ±¾
  • Windows 8.1£¨64 룩
  • Windows Server 2022£¨64 룩
  • Windows Server 2019£¨64 룩
  • Windows Server 2016£¨64 룩
  • Windows Server 2012 R2£¨64 룩
  • Windows Server 2012£¨64 룩
  • Windows Server 2008 R2£¨64 룩

Ö§³ÖµÄÓ²¼þ£º

  • 1.8 GHz »ò¸ü¿ìµÄ x86£¨Intel¡¢AMD£©´¦ÀíÆ÷¡£ ÍƼöʹÓÃË«ºË»ò¸üºÃµÄÄÚºË
  • 2 GB RAM£»½¨Òé 4 GB RAM£¨Èç¹ûÔÚÐéÄâ»úÉÏÔËÐУ¬Ôò×îµÍ 2.5 GB£©
  • Ó²Å̿ռ䣺2-10 GB ¿ÉÓÿռä

 ±¸×¢

¶ÔÓÚ Windows£¬SSMS Ö»ÄÜ×÷Ϊ 32 λӦÓóÌÐòʹÓᣠÈç¹ûÐèÒªÔÚ Windows ÒÔÍâµÄ²Ù×÷ϵͳÉÏÔËÐеŤ¾ß£¬ÎÒÃǽ¨ÒéʹÓà Azure Data Studio¡£ Azure Data Studio ÊÇÒ»¸ö¿çƽ̨¹¤¾ß£¬¿ÉÔÚ macOS¡¢Linux ÒÔ¼° Windows ÉÏÔËÐС£ ÓйØÏêϸÐÅÏ¢£¬Çë²ÎÔÄ Azure Data Studio¡£

 »ñÈ¡ SQL ¹¤¾ßµÄ°ïÖú

ºóÐø²½Öè

 ²ÎÓë±à¼­ SQL Îĵµ

ÄãÊÇ·ñÖªµÀÄã¿ÉÒÔ×ÔÐб༭ SQL ÄÚÈÝ£¿ ÄãÈç¹ûÕâÑù×ö£¬²»½ö¿ÉÒÔ°ïÖú¸Ä½øÎÒÃǵÄÎĵµ£¬»¹¿ÉÒÔ»ñµÃÒ³Ãæ¹±Ï×ÕßµÄÊâÈÙ¡£

ÓйØÏêϸÐÅÏ¢£¬Çë²ÎÔÄÈçºÎ²ÎÓë SQL Server Îĵµ±à¼­

 

½¨ÒéµÄÄÚÈÝ

·¢²¼Ê±¼ä:2022/5/30 ÔĶÁ:3511´Î À´Ô´:MicroSoft
 


¡¡
市场动æ€?·ÖÀà
   
  ÐÐÒµÐÂÎÅ
 
  ¹«Ë¾¶¯Ì¬
 
  ¼¼Êõ×ÊÁÏ
 
  µçÄÔάÐÞ
 
  »Ö¸´°¸Àý
 
  SQLÊý¾Ý¿â
 
  ´ÅÅÌÕóÁÐ
 
  ·þÎñÆ÷
 
  ²ÆÎñÈí¼þ
 
  ÍøÂçÎÊÌâ
 
  linux-XFS
 
  Æ»¹ûµçÄÔ&ϵͳ
 
  °²×¿ÏµÍ³Ïà¹Ø
 
  °ì¹«Îļþ
 
  ²Ù×÷ϵͳ
 
  ÈÕ³£Éú»î(ÑĮ̀)
 
  ÍøÕ¾Ïà¹Ø
 
   
¡¡
ÓÑÇéÁ´½Ó
¡¡
¡¡
 
 
 
   
¹«Ë¾µØÖ·£ºÑĮ̀µçÄÔÊг¡#308
µç»°£º0535-6688830 E-Mail:163@163.com
Copyright©2011-2012 ÑĮ̀Èð³Û¿ÆóÓÐÏÞ¹«Ë¾ All Rights Reserved.
³ICP±¸11014811ºÅ-1
ÄúÊDZ¾Õ¾µÚ λ·ÃÎÊÕß