How to take backup of database from SQL
To take backup of database from SQL High-level resolution steps Detailed resolution steps Step 1 Open Microsoft SQL Server Management Studio and connect to the server. Step 2 Right-click on the database, select “Tasks,” and then click on “Backup”. Step 3 Select backup options and set backup compression to “compress backup”. Step 4 Select the […]
How to import bacpac file to SQL database using command prompt
Requirement How to import bacpac file to SQL database using command prompt. High level resolution steps Detailed resolution steps Step 1 By selecting the required database backup, we can download the bacpac file. Step 2 Before importing the bacpac file to the sql, we are supposed to download the sql package. Net Core for Windows […]
Related field fixed relation in table for custom lookup
Requirement: How to create Filter-specific Lookup field for a control in table level. Scenario: Suppose we have a master table which consists of list of colours in it, and this table is used in lookup field in the required table/forms and it gives a drop down of all the list of colours in the table. […]