How to Use the Table Browser in D365FO using Chrome add-ins

 Install chrome extension for table browser

Add and do config as per req

Note: table & data entity also will work.

AOT Browser in D365FO

 Reference: https://dynamics-tips.com/aot-browser-d365-finance-and-operations/  

GitHub:

https://github.com/arbelatech/aotbrowser

Insert table data from one DB to another DB SQL script

 Insert table data from one DB to another DB SQL script

SQL 1:

INSERT INTO <Target DB>.dbo.<Table Name>

SELECT *

FROM <Source DB>.dbo.<Table Name>

where <Source DB>.dbo.<Table Name>.<Table field name>= '<values>'

 

SQL 2:

INSERT INTO [target db].[dbo].[table] (<columnA>,<columnB>,…)

SELECT <columnA>,<columnB>,…

FROM [source db].[dbo].[table]