asp.net mvc - Moving a database to another server for MVC C# application -


i need move database local server another. moved data through ssms tool database. in application have 2 connection strings , tried exchange them not know how well.

local db connection string:

 connectionstring="metadata=res://*/models.biuromodel.csdl|res://*/models.biuromodel.ssdl|res://*/models.biuromodel.msl;provider=system.data.sqlclient;provider connection string="data source=komputer\sqlexpress;initial catalog=defaultconnection;integrated security=true;multipleactiveresultsets=true;app=entityframework"" providername="system.data.entityclient"  

my second server connection string:

data source=db-mssql;initial catalog=inzs9776;persist security info=true;user id=inzs9776;password=xxxxxxx 

my local connection string auto generated ado.net when try exchange these connections string errors like: enter image description here

entity framework connection strings wrap normal sql server connection string, replace appropriate part, observe:

metadata=res://*/models.biuromodel.csdl|res://*/models.biuromodel.ssdl|res://*/models.biuromodel.msl; provider=system.data.sqlclient; provider connection string=     "         data source=komputer\sqlexpress;         initial catalog=defaultconnection;         integrated security=true;         multipleactiveresultsets=true;         app=entityframework     " 

replace bit after provider connection string= new sql server connection string, , don't forget wrap in ".


Comments

Popular posts from this blog

c++ - llvm function pass ReplaceInstWithInst malloc -

Cross-Compiling Linux Kernel for Raspberry Pi - ${CCPREFIX}gcc -v does not work -

java.lang.NoClassDefFoundError When Creating New Android Project -