RetroSearch Browse

Showing content from https://learn.microsoft.com/en-us/fabric/database/sql/create below:

Create a SQL database in the Fabric portal

In this article

Applies to: â SQL database in Microsoft Fabric

In this tutorial, 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 receive an error message "SQL database failed to create."
You can use an existing workspace or create a new Fabric workspace.
You must be a member of the Admin or Member roles for the workspace to create a SQL database.

Create new SQL database in Fabric

In the Fabric portal, select Databases.
Under New, select the tile for SQL database.
Provide a name for the New Database. Select Create.
When the new database is provisioned, on the Home page for the database, notice the Explorer pane showing database objects.
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.
Consider adding your new database to source control. For more information, see SQL database source control integration in Microsoft Fabric.

Next step

Additional resources

In this article

Was this page helpful?

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4