Fabric SQL

To set up your Database instance, follow the steps below:

• Log in to the DBSync Cloud Replication instance

• To configure, navigate to the Database tab.

• Click the Database icon from the top navigation toolbar

• To start with, select Fabric SQL and enter all the configuration details like host, port, username, password, database name, and schema.

How to get Fabric SQL details

• Log in to the Azure portal and open your Fabric workspace at: https://app.fabric.microsoft.com/

• Create a database, then click the settings icon in the left panel

• Then select the Connection strings.

• The host name can be found after Data Source= in the connection string, for example

avrav7zpjxje3cthvcgnyigimac7mnyi5rj3qedi7s3gxmpkk7wm.database.fabric.microsoft.com

• Use port number 1433

• Use your Azure username and password for authentication The database name can be found after Initial Catalog=, for example: Fabric sql-6f742f08-00b4-4553-91d3-839339681861

• Once the user enters all the details, the URL details will get auto-filled.

• Click Save

• You can save and test your Database connection.

• Click Next