Create a SQL database in the Fabric portal

Applies to: ✅ SQL database in Microsoft Fabric

In this tutorial, you'll create a new SQL database in Fabric.

Prerequisites

• You need an existing Fabric capacity. If you don't, start a Fabric trial.
  • Make sure that you Enable SQL database in Fabric using Admin Portal tenant settings. If you don't, you'll receive an error message "SQL database failed to create."
• You must be a member of the Admin or Member roles for the workspace to create a SQL database.
• You can use an existing workspace or create a new Fabric workspace.

Create new SQL database in Fabric

1. In the Fabric portal, select Databases.
2. Under New, select the tile for SQL database.
3. Provide a name for the New Database. Select Create.
4. When the new database is provisioned, on the Home page for the database, notice the Explorer pane showing database objects.
5. Under Build your database, three useful tiles can help you get your newly created database up and running.
   • Sample data option lets you import a sample data into your Empty database.
   • T-SQL option gives you a web-editor that can be used to write T-SQL to create database object like schema, tables, views, and more. For users who are looking for code snippets to create objects, they can look for available samples in Templates drop down list at the top of the menu.
   • Connection strings option shows the SQL database connection string that is required when you want to connect using SQL Server Management Studio, the mssql extension with Visual Studio Code, or other external tools.
6. Consider adding your new database to source control. For more information, see SQL database source control integration in Microsoft Fabric.

Note

You can also deploy a SQL database in Fabric with the REST API.

Next step

Load AdventureWorks sample data in your SQL database

Related content

• Connect to your SQL database in Microsoft Fabric
• Ingest data into SQL database via data pipelines