Dynamics Community Forum Thread Details

System table $ndo$dbproperty is missing or database bacpac is not a Dynamics 365 Busin...

Hello readers,

In the above error scenario for a database restored from .bacpac exported from BC SaaS, I guess we can give a try by exporting the Create table "$ndo$dbproperty" query on top of any existing Business Central Database in On-premises SQL server. and reuse to create the table "$ndo$dbproperty" in the ".bacpac restored database" where the issue is occurring.

In Simple terms.

Get on a Business Central database of a required version in your on-premises SQL server. In my case I'm using Business Central V22 Database.

Expand the tables part select the "$ndo$dbproperty".
Right-click the table -> Script Table as -> CREATE To

Thereby, we will get a create table query for table "$ndo$dbproperty".

The above query can be reused in a database and then on top, Business Central license can be attached further.

I hope this is already old and a known one to many.
If you are having any other way to tackle the above issue, let me and the community know your thoughts.

Create table Query.

USE [<Database Name>]
GO

/****** Object: Table [dbo].[$ndo$dbproperty] Script Date: 11/6/2024 1:13:16 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[$ndo$dbproperty](
   [programid] [int] NOT NULL,
   [chartable] [image] NULL,
   [maxrecsize] [int] NOT NULL,
   [maxloginattempts] [int] NOT NULL,
   [passwordexpindays] [int] NOT NULL,
   [supergroupid] [varchar](128) NOT NULL,
   [unifiedloginallowed] [tinyint] NOT NULL,
   [contype] [int] NOT NULL,
   [shadowpwd] [varchar](128) NOT NULL,
   [databasemagic] [int] NOT NULL,
   [databaseversionno] [int] NOT NULL,
   [clientdatabaseversionno] [int] NOT NULL,
   [maintainviews] [int] NOT NULL,
   [diagnostics] [int] NOT NULL,
   [identifiers] [varchar](2000) NOT NULL,
   [maintainrelationships] [int] NOT NULL,
   [convertidentifiers] [int] NOT NULL,
   [invalididentifierchars] [varchar](128) NOT NULL,
   [license] [image] NULL,
   [checkcodepage] [int] NOT NULL,
   [quickfind] [int] NOT NULL,
   [maintaindefaults] [int] NOT NULL,
   [locktimeout] [int] NOT NULL,
   [locktimeoutperiod] [int] NOT NULL,
   [hardrowlock] [int] NOT NULL,
   [bufferedrows] [int] NOT NULL,
   [securityoption] [int] NOT NULL,
   [enabledforserver] [int] NOT NULL,
   [uidoffset] [int] NOT NULL,
   [applicationversion] [varchar](50) NOT NULL,
   [applicationfamily] [varchar](50) NOT NULL,
CONSTRAINT [PK$ndo$dbproperty] PRIMARY KEY CLUSTERED
(
   [programid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[$ndo$dbproperty] ADD DEFAULT ((0)) FOR [programid]
GO

ALTER TABLE [dbo].[$ndo$dbproperty] ADD DEFAULT ((0)) FOR [maxrecsize]
GO

ALTER TABLE [dbo].[$ndo$dbproperty] ADD DEFAULT ((0)) FOR [maxloginattempts]
GO

ALTER TABLE [dbo].[$ndo$dbproperty] ADD DEFAULT ((0)) FOR [passwordexpindays]
GO

ALTER TABLE [dbo].[$ndo$dbproperty] ADD DEFAULT ('') FOR [supergroupid]
GO

ALTER TABLE [dbo].[$ndo$dbproperty] ADD DEFAULT ((0)) FOR [unifiedloginallowed]
GO

ALTER TABLE [dbo].[$ndo$dbproperty] ADD DEFAULT ((0)) FOR [contype]
GO

ALTER TABLE [dbo].[$ndo$dbproperty] ADD DEFAULT ('') FOR [shadowpwd]
GO

ALTER TABLE [dbo].[$ndo$dbproperty] ADD DEFAULT ((0)) FOR [databasemagic]
GO

ALTER TABLE [dbo].[$ndo$dbproperty] ADD DEFAULT ((0)) FOR [databaseversionno]
GO

ALTER TABLE [dbo].[$ndo$dbproperty] ADD DEFAULT ((0)) FOR [clientdatabaseversionno]
GO

ALTER TABLE [dbo].[$ndo$dbproperty] ADD DEFAULT ((0)) FOR [maintainviews]
GO

ALTER TABLE [dbo].[$ndo$dbproperty] ADD DEFAULT ((0)) FOR [diagnostics]
GO

ALTER TABLE [dbo].[$ndo$dbproperty] ADD DEFAULT ('') FOR [identifiers]
GO

ALTER TABLE [dbo].[$ndo$dbproperty] ADD DEFAULT ((0)) FOR [maintainrelationships]
GO

ALTER TABLE [dbo].[$ndo$dbproperty] ADD DEFAULT ((0)) FOR [convertidentifiers]
GO

ALTER TABLE [dbo].[$ndo$dbproperty] ADD DEFAULT ('') FOR [invalididentifierchars]
GO

ALTER TABLE [dbo].[$ndo$dbproperty] ADD DEFAULT ((0)) FOR [checkcodepage]
GO

ALTER TABLE [dbo].[$ndo$dbproperty] ADD DEFAULT ((0)) FOR [quickfind]
GO

ALTER TABLE [dbo].[$ndo$dbproperty] ADD DEFAULT ((0)) FOR [maintaindefaults]
GO

ALTER TABLE [dbo].[$ndo$dbproperty] ADD DEFAULT ((0)) FOR [locktimeout]
GO

ALTER TABLE [dbo].[$ndo$dbproperty] ADD DEFAULT ((0)) FOR [locktimeoutperiod]
GO

ALTER TABLE [dbo].[$ndo$dbproperty] ADD DEFAULT ((0)) FOR [hardrowlock]
GO

ALTER TABLE [dbo].[$ndo$dbproperty] ADD DEFAULT ((0)) FOR [bufferedrows]
GO

ALTER TABLE [dbo].[$ndo$dbproperty] ADD DEFAULT ((0)) FOR [securityoption]
GO

ALTER TABLE [dbo].[$ndo$dbproperty] ADD DEFAULT ((0)) FOR [enabledforserver]
GO

ALTER TABLE [dbo].[$ndo$dbproperty] ADD DEFAULT ((0)) FOR [uidoffset]
GO

ALTER TABLE [dbo].[$ndo$dbproperty] ADD DEFAULT ('') FOR [applicationversion]
GO

ALTER TABLE [dbo].[$ndo$dbproperty] ADD DEFAULT ('') FOR [applicationfamily]
GO

Thanks.

Categories:

Dynamics 365 Business Central

Adding the same as answers here. Anticipating the responses and comments to know if there is another way.

Get on a Business Central database of a required version in your on-premises SQL server. In my case I'm using Business Central V22 Database.

Expand the tables part select the "$ndo$dbproperty".
Right-click the table -> Script Table as -> CREATE To