1

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.

2

Re: the project with basis SQLEXPRESS.

On the future - transfer of a file of a DB is carried out through , instead of through a DB file.

3

Re: the project with basis SQLEXPRESS.

Shocker. Pro wrote:

On the future - transfer of a file of a DB is carried out through , instead of through a DB file.

Well it I in course, but  from 2016 on 2014 do not want .

4

Re: the project with basis SQLEXPRESS.

denis_viktorovich;
Well and speech certainly about basis express Aspnetdb.mdf dataful applications for authentification instead of about a working DB of application.