Topic: the project with basis SQLEXPRESS.
Kind time of days!
One of new small problems in MVC 5 made with standard authorization (identity - + the password) fastening to it still roles (earlier as a rule Windows authorization + roles in the application). As consequence - basis SQLEXPRESS c is created by users, difficulties arose roles etc. At if to copy MDF a file in an application folder, I receive the message that the file already is and it it is impossible, if I do not copy - the message that the file of a database is not present. Came and a server in SQLEXPRESS and tried hands the basis necessary to me. Received the distinct answer that the basis at me from 2016 express trains, and and in any way is impossible for 2014.
Solved a problem basis in studio and fulfilling a script on necessary to me . that last time (on 2010 studios) had the same problems and arrived also. A question two -
1. Whether it is possible to automate bases together with application on the web server (setting the necessary version or as that to specify in studio that basis is necessary to create with compatibility level as on a target server).
2. Whether is the best practice transfer of such bases (only the data about users and roles) with servers on separate server MS SQL, for example application there where the main DB with which lies works.