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:
- i work locally modifying sql schema via sql server management studio.
- next open visual studio database project & perform "schema compare" operation.
- i choose local database latest changes "source schema" , "target schema" database project.
- next @ "schema comparison" results , choose "skip" "update action" on items not want change. items want change choose appropriate "update action".
- 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
Post a Comment