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:
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):
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
Post a Comment