Announcing SQL Server Data Tools (SSDT) for ARM64 Architecture in Visual Studio 17.10 Preview 2
Published Apr 03 2024 09:00 AM 1,093 Views
Microsoft

 

We are thrilled to announce the launch of SQL Server Data Tools (SSDT) for Visual Studio in ARM64. This enhancement comes with the exciting release version 17.10 Preview 2. Release of SSDT for Visual Studio on arm64 adds SQL development to the capabilities of Visual Studio on arm64. This latest development brings a host of features tailored to enhance your database development experience on ARM64 devices. 

subhojitbasak_0-1712130815702.png

 

Key Features:

  • SQL Projects (Open, Build, Publish): Dive into your SQL projects seamlessly with the ability to open an existing project, and build and publish projects directly from Visual Studio on ARM64. 
  • Schema Compare: Ensure data consistency and easily identify changes with the schema compare feature, allowing you to visualize and synchronize schema differences effortlessly. 
  • Data Compare: Facilitate swift and accurate comparison of data between databases. 
  • Query Editor: Craft and fine-tune your SQL queries directly in Visual Studio with the intuitive query editor optimized for ARM64 architecture. Use GitHub Copilot to assist you in your database development by translating natural language into T-SQL code. 
  • Table Designer: Design and modify tables using the table designer GUI, offering a user-friendly interface for creating and managing database tables. 
  • Database Properties Editor: Tailor your database settings using the database properties editor, allowing you to configure various aspects of your database. 
  • Object Refactoring: Streamline database development process with object refactoring capabilities, enabling you to efficiently reorganize and optimize your database schema. 

subhojitbasak_1-1712130815390.png

 

Feature List

Feature  SSDT in AMD64  SSDT in ARM64 
Opening a SQL Project  ticknobg _quarter.png

 

ticknobg _quarter.png

 

Building a Project  ticknobg _quarter.png

 

ticknobg _quarter.png

 

Publishing a Project  ticknobg _quarter.png

 

ticknobg _quarter.png

 

Schema Compare  ticknobg _quarter.png

 

ticknobg _quarter.png

 

Data Compare  ticknobg _quarter.png

 

ticknobg _quarter.png

 

Query Editor  ticknobg _quarter.png

 

ticknobg _quarter.png

 

Table Designer  ticknobg _quarter.png

 

ticknobg _quarter.png

 

Database Properties Editor  ticknobg _quarter.png

 

ticknobg _quarter.png

 

Object Refactoring  ticknobg _quarter.png

 

ticknobg _quarter.png

 

SQL Server Object Explorer  ticknobg _quarter.png

 

ticknobg _quarter.png

 

Development using localdb  ticknobg _quarter.png

 

crossnobg _quarter.png

 

IntelliSense in Query Editor * ticknobg _quarter.png

 

crossnobg _quarter.png

 

Debugger  ticknobg _quarter.png

 

crossnobg _quarter.png

 

 

Steps for Installing SSDT in VS for ARM64

 

  1. Download the Visual Studio Installer from Download Visual Studio Tools – Install Free for Windows, Mac, Linux (microsoft.com)
  2. In the Available options, find 17.10.0 Preview 2. (Enterprise / Community / Professional)
  3. Click on the Installation button, which opens the Installation dialogue box for 17.10.0 Preview 2. Go to Individual Components and search for SQL.
  4. Select SQL Server Data Tools. It would automatically select all the SQL components.
  5. Select the other components / workloads as necessary and click on Install.
  6. Open Visual Studio and create SQL Server Database Project.

subhojitbasak_28-1712132127415.gif

 

Conclusion

 

With the launch of SSDT for ARM64 architecture in Visual Studio 17.10 Preview 2, we aim to provide a robust environment for SQL Server database development. Explore the exciting features now available and stay tuned for upcoming releases. 

Download the latest version of Visual Studio.

 

Update*

 

We have added the IntelliSense feature in the query editor in Visual Studio 17.10 Preview 3 (ARM64). 

Co-Authors
Version history
Last update:
‎Apr 19 2024 04:38 AM
Updated by: