Skip to main content

MSDYN365BC 2019 Wave 2 - Missing Development Environment Task Part 3?

Hi Readers,

In this article, we will discuss things that we used to do in Development Environment till Business Central Spring Release and how we will do them now in Business central 2019 Wave 2 or higher.

This article is based on a question that I received on an email and guess what I never thought about it.

Previous articles we already talked about - Help, Window, View, Edit & Tools Menu Item in Development Environment.

In this article, we will discuss the File Menu Item in the Development Environment.


1. New

Past -  This menu option was used to create new objects with or without wizards in the database.

Future - Using Snippet and other extensions developed by Developers to develop new objects for extension.

2. Design

Past -  This menu option was used to design existing objects in the database.

Future - Using New programming language and code editor we can modify new objects created for the extension.

3. Run

Past -  This menu option was used to Run Objects in the Object Designer.

Future - All objects can be run from AL Object designer using extension build by other developers.

4. Close

Past -  This menu option was used to close the object designer.

Future - As there is no object designer in VS Code we don't need to close objects.

5. Lock

Past -  This menu option was used to Lock selected or all objects from Object Designer.

Future - There are no requirements in AL Programming to Lock Objects.

6. Unlock

Past -  This menu option was used to Unlock selected or all objects from Object Designer.

Future - There are no requirements in AL Programming to Unlock Objects.

7. Force Unlock

Past -  This menu option was used to Force Unlock objects from Object Designer if locked by other developers.

Future - There are no requirements in AL Programming to Force Unlock objects.

8. Import

Past -  This menu option was used to Import selected or all NAV Objects from Object Designer.

Future - There are no base objects that we can import objects in AL Programming or VS Code. Let's put this way before AL Programming Source Control was Object Designer in the database now it GIT. With AL Programming we are truly using Source Control the way it should be used.

9. Export

Past -  This menu option was used to Export selected or all NAV Objects from Object Designer.

Future - There are no base objects that we can export objects in AL Programming or VS Code. Let's put this way before AL Programming Source Control was Object Designer in the database now it GIT. With AL Programming we are truly using Source Control the way it should be used.

10. Database

Past -  This menu is so important for all developers because it provided us the following options -

  • New Database - Create a new database.
  • Open Database - Open an Existing database.
  • Alter Database - We used this option to change the following properties of the database 
    • Change Initial File Size of the database file.
    • Change the File Growth %.
    • Set File Growth Type.
    • Set Max Size of the database file.
    • Change Collation of database.
    • Set Recovery Model.
  • Delete Database - Delete Currently open database.
  • Close Database - Close currently open database.
  • Database Information - You can check the database name and server instance about the database.
Future -
Yes, databases are important and all above-listed objects are very important to us. We cannot do our daily tasks if we don't have alternate to these menu options.

New Database - 
We can create a new database from the Powershell.
Powershell cmdlet New-NAVApplicationDatabase can be used to create a new database for Business Central.

Open Database - Actually to tell you the truth we don't need an option to open a database with AL Programming. The database is mapped to a service that is used in the launch json file for the extension.

Alter Database - 
All actions defined above can be achieved by using the SQL Server Management Studio.

Delete Database - We can delete a database from SQL Server.

Close Database -  As we don't need to open database we also don't need to close the database.

Database Information - We know all information about the database from the Service tier mapped to it.

11. Exit

Past -  This menu option was used to close the Development Environment.

Future - No More Development Environment so this menu option is not required in the future.


Hope you find the information useful.

Let me know your views as a comment on this article.

Stay tuned for more.

Regards,
Saurav Dhyani
www.sauravdhyani.com

Comments

Popular posts from this blog

VIEW SERVER STATE permission on SQL Server?

Hi all, Sometime While trying to Login into a database we face an error message as shown below. --------------------------- Microsoft Dynamics NAV Classic --------------------------- You cannot start Microsoft Dynamics NAV Classic because you do not have the VIEW SERVER STATE permission on SQL Server. Contact your system administrator. --------------------------- OK    ---------------------------

NAV 2013 R2 - Cumulative update 12 Released.

Hi all, Please find below the details of  Cumulative Update 12 released for Microsoft Dynamics NAV 2013 R2. Title - Cumulative Update 12 for Microsoft Dynamics NAV 2013 R2 Build No. - 38053 Release Date - October, 2014 Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK, RU Download Link Note: Implementing this cumulative update will require a database conversion unless you have already implemented update rollup 5.

NAV 2013 Upgrade Part III - Data Upgrading.

Hi all, As per agenda we need to discuss the data upgrade in NAV 2013. The process is similar to what used to be till NAV 2009 R2 but with some changes. Let's start the process. Remember -  1) You can only upgrade a database to NAV 2013 from NAV 2009 SP1 / R2 SQL Only. 2) The Synchronization of users with SQL Server is no more required.