Frequently Asked Questions

How do I register?

Go to the /register page and fill in the form with your username, email, and password. Alternatively, you can sign in quickly with your Microsoft or Google account via OAuth2. After registration you will receive a verification email.

I did not receive the verification email — what should I do?

Check your spam/junk folder first. If you still cannot find it, log in to the app and go to Profile — there is a button to resend the verification email. If the issue persists, please contact support.

I forgot my password — how do I reset it?

On the login page, click "Forgot password?" and enter your email address. You will receive a link to reset your password. The link is valid for a limited time.

What is Enterprise mode?

Enterprise mode is designed for private company deployments. In this mode, a standalone version of core and web services are installed in your own server.

How does the license work in Enterprise standalone install? Where do I find the license key?

The license is tied to the running bc2sql-core instance. The license key is provided upon purchase and must be added to the core configuration file. You can verify the current license status on the Version Info page.

What happens when the license expires in Enterprise standalone install?

When the license expires, automatic synchronizations are suspended. The web interface remains accessible for configuration, but the sync engine will not run new jobs until the license is renewed or replaced.

Where do I find the Tenant ID and Client ID in Azure?

Go to the Azure portal (portal.azure.com) → Azure Active Directory → App registrations. The Tenant ID is shown on the Azure AD overview page; the Client ID is displayed in the app registration you created for BC2SQL.

Which API permissions are required on Azure for Business Central?

In your Azure app registration, add permissions for Dynamics 365 Business Central:

• Financials.ReadWrite.All — for reading and writing BC data
• Alternatively API.ReadWrite.All for full API access

Make sure to click Grant admin consent after adding the permissions.

How do I find the Business Central Environment Name?

Log in to Business Central and look at the browser URL. The environment name is the segment after /environments/ — typically Production or Sandbox. You can also find it in the BC Admin Center.

The BC API connection test fails — why?

The most common causes are:

• Incorrect Tenant ID or Client ID
• Expired or incorrectly copied Client Secret
• API permissions not granted or admin consent missing
• Company Name does not exactly match the name in BC
• The BC user does not have the required web API permissions

Does the SQL database need to be exposed to the internet?

No. The bc2sql-core component is installed on the same network as your SQL database and connects to it locally. Only bc2sql-core needs outbound internet access (port 443) to reach the Business Central APIs — your database never needs to be publicly accessible.

The SQL connection test fails with "connection refused" — what should I check?

Verify that:

• The host/IP and port are correct (SQL Server default: 1433, PostgreSQL: 5432)
• The firewall / Windows Firewall allows inbound connections on the configured port
• For SQL Server: the SQL Server Browser service is running if you use named instances
• The SQL user has db_datareader and db_datawriter permissions on the target database

Do I need to create the destination SQL tables manually?

No. BC2SQL can automatically generate a CREATE TABLE script based on the Business Central entity metadata. In the Entity Mapping page, use the "Suggest Create Table" button to generate the SQL script, which you can then run directly on your database.

Can I sync to multiple different databases at the same time?

Yes. BC2SQL supports multiple Remote DB Config entries (SQL endpoints), and you can associate different entity mappings with different databases. Each mapping can point to a different SQL endpoint.

Can I connect to a cloud database on Azure (Azure SQL / Azure Database for PostgreSQL)?

Yes. Fill in the standard fields (host, port, username, password) using the values from your Azure resource:

• Azure SQL Database: host = myserver.database.windows.net, port 1433, username and password as configured in Azure.
• Azure Database for PostgreSQL – Flexible Server: host = myserver.postgres.database.azure.com, port 5432. SSL is negotiated automatically.
• Azure Database for PostgreSQL – Single Server (legacy): same as above, but the username must include the server name: myuser@myserver.

For advanced scenarios (custom SSL certificates, specific connection options), use the Connection String field instead of individual fields — it is passed directly to the driver without any modification. Example for PostgreSQL:

What is the difference between Full and Incremental synchronization?

• Full: downloads all records from the BC entity and upserts them into the SQL database. Slower but guarantees complete alignment. Recommended for the first sync or after issues.
• Incremental: downloads only records modified since the last synchronization (based on the lastModifiedDateTime field in BC). Much faster — ideal for frequent scheduled syncs.

How does Field Mapping work?

For each Entity Mapping you can define the correspondence between Business Central entity fields and SQL table columns. If no field mapping is configured, BC2SQL attempts to auto-map fields with matching names. Custom field mapping lets you rename columns, exclude fields, or apply transformation rules.

What are Transformation Rules?

Transformations let you modify a field value during synchronization. Available functions include: UPPER, LOWER, TRIM, REPLACE, FORMAT_DATE, CONCAT, DEFAULT_IF_EMPTY, and more. They are useful for normalizing data before it is inserted into SQL.

Can I filter which records are synchronized?

Yes. In the Entity Mapping configuration you can set an OData filter that is applied to the Business Central API call. For example, you can sync only active customers or invoices from a specific year. The syntax follows the OData v4 standard.

What happens to records deleted in BC?

Incremental mode does not automatically delete records from SQL when they are removed in BC (the OData APIs do not expose deleted records). To handle deletions, run a periodic Full synchronization with the orphan-record cleanup option enabled.

How do I write a CRON expression?

BC2SQL uses the standard 5-field CRON syntax:

Practical examples:

• */15 * * * * — every 15 minutes
• 0 * * * * — every hour (at minute 0)
• 0 6 * * * — every day at 06:00
• 0 6 * * 1-5 — Monday–Friday at 06:00
• 0 0 * * 0 — every Sunday at midnight

What is the recommended minimum frequency?

It depends on data volume. For incremental syncs with few records, running every 5 minutes (*/5 * * * *) is feasible. For full syncs on large tables, once per day is recommended. Avoid excessively high frequencies to prevent hitting Business Central API rate limits.

Can I trigger a sync manually?

Yes. In the Entity Mapping → Detail page, the "Run Sync Now" button immediately triggers a synchronization for that entity, regardless of the CRON schedule.

How do I temporarily disable a job?

Every Sync Job has an Active/Inactive toggle. Disabling the job prevents the CRON from running until you re-enable it. You can also disable the entire Entity Mapping to pause all related jobs.

Where can I see synchronization logs?

The Sync Logs section shows the detail of every execution: status (success/error), number of records processed, duration, and error message. You can filter by date, entity, and status. Logs can be exported as PDF or CSV.

The sync fails with "401 Unauthorized" from Business Central

This error indicates an OAuth2 authentication problem. Check:

• The Client Secret has not expired (Azure secrets have a configurable lifetime)
• The Client ID and Tenant ID are correct
• API permissions on Azure have been granted with Grant admin consent
• The Azure app is registered in the correct tenant

The sync is slow or times out

If synchronizations take too long:

• Check network connectivity between the server running bc2sql-core and the BC APIs
• Use incremental mode instead of full for regular syncs
• Reduce the number of mapped fields if not all are needed
• Verify that Business Central rate limits are not being exceeded (error 429)

The sync service shows as offline in the dashboard

The status badge in the navbar indicates whether bc2sql-core is reachable. If it appears offline:

• Verify the bc2sql-core process is running on the server
• Check that the host and port in the config file are correct
• Review the core logs for startup errors
• Check that the firewall is not blocking communication between the web app and the core

How do I contact support?

You can reach us via:

• The Contact form in the application (login required)
• Direct email: [email protected]

When reporting an issue, please include: software version, error type, full error log text, and the operating system of your server.