How to write Download Job or Push Job in D365 for new Custom Table?
If you want to write the download/push job in D365. Please follow the following steps; Step # 1: You have to create the new Custom Table in the dbo schema of the database by using AOT. Or you can create it simply in the database for testing. For Example. You create a Table of books. dbo.DRBOOK Code: IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID('[dbo].[DRBOOK]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[DRBOOK]( TITLETAG nvarchar(MAX) NOT NULL, [DATAAREAID] nvarchar(4) NOT NULL, [PARTITION] bigint NOT NULL, [RECID] bigint NOT NULL CONSTRAINT [I_dbo_DRBOOK] PRIMARY KEY CLUSTERED ( [TITLETAG] ASC, [DATAAREAID] ASC, [PARTITION] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] END; GO GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[dbo].[DRBOOK] TO [DataSyncUsersRole] GO GRANT SELECT ON [dbo].[DRBOOK] TO [User...