Copy the buffer values from one form to another without storing recid in DB

salesLine.initFromProductDimensions(inventDim);

salesLine.InventDimId = inventDim.inventDimId;

salesLine.setPriceDisc(inventDim);

//salesLine.createLine(true,true,true,true,true,true);

FormDataSource fds = salesTable.dataSource();

FormDataSource fdsSalesLine = fds.formRun().dataSource('SalesLine');

fdsSalesLine.create();

// Create new record

SalesLine    salesLineNew;

salesLineNew = fdsSalesLine.cursor();

 

// Copy data from original record to the new record and adjust ValidFrom

buf2Buf(salesLine, salesLineNew);

fdsSalesLine.rereadReferenceDataSources(); 

 Import DB in SQL

1. Change directory to the path where SQLPackage.exe is available

C:\Program Files (x86)\Microsoft Visual Studio\2019\Professional\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\130

2. Run the below command

SqlPackage.exe /Action:Import /SourceFile:"C:\Users\Admin9470282646\Desktop\DB\backup.bacpac" /TargetConnectionString:"Data Source=localhost;Initial Catalog=MyDB;Integrated Security=True;" /p:CommandTimeout="0"