tfs2010 - Merge Issues With Visual Studio 2010 Database Project Schema Compare & TFS -


i experiencing issue working database project in visual studio 2010 ultimate tfs. following describes work flow use:

  1. i work locally modifying sql schema via sql server management studio.
  2. next open visual studio database project & perform "schema compare" operation.
  3. i choose local database latest changes "source schema" , "target schema" database project.
  4. next @ "schema comparison" results , choose "skip" "update action" on items not want change. items want change choose appropriate "update action".
  5. when finished choose "write updates" command apply changes database project.

the problem have when @ database project, of database tables told ignore updated in database project commenting out database create script.

for example 1 looks like:

/*create table [schemaname].[tablename] (     [col1]     bigint           identity (1, 20) not null,     [col2]     int              null );*/ 

the question is: since told compare ignore table why did modify project , comment out code?

ok people found solution issue via fellow co-worker.

it turns out there step need while performing schema compare:

step 4a - after choosing appropriate "update action" items must click "refresh" button. after perform refresh may proceed step 5.


Comments

Popular posts from this blog

windows - Why does Vista not allow creation of shortcuts to "Programs" on a NonAdmin account? Not supposed to install apps from NonAdmin account? -

c++ - How do I get a multi line tooltip in MFC -

unit testing - How to mock PreferenceManager in Android? -