User Tools

Site Tools


ra:development

This is an old revision of the document!


Configuration, project setup

For the first time:

  • It's necessary to setup sql alises for the first time. You can use SQL Server Configuration Manager from SQL Server Management studio (SSMS) - native client configuration - both 64bit andd 32bit. But SSMS is huge beast. You can use small windows utility - cliconfg.exe. \Windows\System32\cliconfg.exe for 32bit aliases, \Windows\SysWOW64\cliconfg.exe for 64bit aliases. It's necessary setup both. Alieses are on wiki - SQL_2, SQL_NEW_2012.
  • Setup local sql server express, it's enough version 2012. It's necessary, because modeling deployment script uses local server for generating models.

Configuration

Each customer has own environment - e.g. sql server connections - and configuration. Before work, it's necessary to setup environment configuration for these particular customer.

  • Go to directory for particular customer and run script for environment e.g. project Configuration/Agrofert/Activate_AGROFERT_TEST.cmd, it setups the connections strings, web configs, app config and other things.
  • Don't commit these changes in Configuration dir!

Database

There is database first approach.

  • First prepare data changes - update scripts for sql structures, stored procedures, views …
  • Generate changes into models
  • Table names are according particular module, and customers e.g. DDDiaryReportItem - item for DailyReport
ra/development.1535027804.txt.gz · Last modified: 2018/08/23 14:36 by koubel