Skip to main content
Version: 4.0.0

Setup Database

To work with SQL Server:

Install SQL Server You can choose SQL Server 2022 Developer that is free. (But be careful you cannot install it on production server) After downloading the SQL Server 2022 Developer, double click on the icon to start the install process.

  • Choose "CUSTOM" option SQL Server Developer Custom

  • Either specify an install location or let it as is, then click on "Install" SQL Server Developer Install

  • Choose "Installation" on the left side, and select "New SQL Server standalone installation or add features to an existing installation" first option from the list SQL Server Developer First Option

  • In "Specify a free edition:", leave "Developer" as default SQL Server Developer Developer

  • Accept the license terms and click Next SQL Server Developer Accept

  • It will run check for Install Rules and click Next SQL Server Developer Rules

  • Uncheck "Azure Extension for SQL Server" and click Next SQL Server Developer Uncheck

  • Check "Database Engine service" and click Next SQL Server Developer Instance Features

  • Select "Default instance" and click Next (Need to remember Instance ID to be able to login in SSMS) SQL Server Developer Default

  • Click Next in the "Server Configuration" screen

  • Choose "Windows authentication mode", then IMPORTANT add your account as SQL Server administrator by clicking on "Add..." button SQL Server Developer Authentication

  • Review the summary, click Install, and close the setup windows SQL Server Developer Ready Install

At the end of the installation Install SSMS

To work with PostgreSQL:

Install PostgreSQL To browse the base you can use (pgAdmin 4)[https://www.postgresql.org/ftp/pgadmin/pgadmin4/v6.15/windows/]