Get started:
First, setup your SQL database in Azure. Then enter the relevant info inside the server.js config. Example config:
user: 'myAdmin',
password: 'myPassword',
server: 'yourServer.database.windows.net',
database: 'yourDbName',
options: {
encrypt: true, // for azure
trustServerCertificate: true, // change to true for local dev / self-signed certs
},
};
Now to get started,
- CD into the root directory
- Run
npm install
- Run
node './server.js/
- Right-click and run index.html with live server
- You are now connected to the database and working within it. You can view changes as you make them with SQL Server Management Studio.