asp.net - Connect SQL Express Database to Team Foundation Express -


i managed use team foundation express visual studio express web 2012 want connect database (sql server express 2012) i've created. there way in sql server management studio?

yes, can, although built in source control in sql management studio bit clunky, better option redgate's sql source control:

redgate sql source control

this works brilliantly , simple use.

if want use native source control in management studio have install bits , pieces:

1/ need team explorer 2012 installed (i think need have visual studio 2012 installed, can install express version of in order working if don't have install of already):

team explorer 2012

2/ need install tfs msscci provider (chose either 32 or 64 bit depending on visual studio installation):

microsoft visual studio team foundation server 2012 msscci provider 32-bit

microsoft visual studio team foundation server 2012 msscci provider 64-bit

3/ need set sql management studio use source control:

  • click tools -> options -> source control -> plugin selection -> select msscci provider installed
  • right click on menu bar , select show source control toolbar (hidden default)
  • open .sql file , click "change source control" button, can use dialog enter server details , add files team project etc

just add, built in source control, don't think can add database source control, sql scripts, redgate, can add whole database , combine source control , sql compare create migration scripts between versions, built in source control basic.


Comments

Popular posts from this blog

linux - Does gcc have any options to add version info in ELF binary file? -

android - send complex objects as post php java -

charts - What graph/dashboard product is facebook using in Dashboard: PUE & WUE -