Databases
StackOverflow2013
Postsdbo
POHow to merge changes from a source-controlled VS2010 database project to local development DB
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to merge changes from a source-controlled VS2010 database project to local development DB
    primarykey
    data
    text
    <p>We're trying out VS2010 database projects for a new development, using the following dev cycle:</p> <ul> <li>Use Management Studio to develop changes on a local DB instance (using the designers etc)</li> <li>Use VS2010 schema compare to sync / import these changes to the VSDB project</li> <li>Check in the VSDB project and run automated build / test etc</li> </ul> <p>When I want to 'get latest' from source control, I then:</p> <ul> <li>Update the VSDB project files from source control</li> <li>Use Schema Compare to push the changes from the project to my local database instance</li> </ul> <p>This is where it starts to break down... Because schema compare is trying to <em>synchronise</em> the two versions, it attempts to undo any changes I've made to my local database as part of my own feature development.</p> <p>Obviously, you can tell schema compare to skip changes to the objects I've modified, but sadly this doesn't always work correctly: <a href="http://connect.microsoft.com/VisualStudio/feedback/details/564026/strange-schema-compare-behavior-sql-2008-database-projects" rel="nofollow">http://connect.microsoft.com/VisualStudio/feedback/details/564026/strange-schema-compare-behavior-sql-2008-database-projects</a>.</p> <p>Fundamentally, the problem exists because the definitions in the VSDB project are not automatically synchronised with my local database; thus I need to use Schema Compare to do a 'poor mans merge' every time I get a change.</p> <p>One possible solution could be to:</p> <ul> <li>Use Schema Compare to sync any changes from my local DB to the VSDB project <em>first</em></li> <li>Update the VSDB project from source control (therefore using the source control tooling to do the merge, rather than Schema Compare)</li> <li>Schema Compare the changes from source control into my local DB instance</li> </ul> <p>...which is far from ideal.</p> <p><strong>Is RedGate SQL Source Control better in this regard?</strong></p> <p><strong>What about the new 'Juneau' SQL toolset?</strong></p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJohn Saunders
    1. USChris Brook
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow to merge changes from a source-controlled VS2010 database project to local development DB
      1. USDerek Kromm
      1. VTFavorite
    2. VO
      singulars
      1. POHow to merge changes from a source-controlled VS2010 database project to local development DB
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POHow to merge changes from a source-controlled VS2010 database project to local development DB
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWhy not simply use database projects the way they're meant to be used. Stop making changes in the database!
      singulars
      1. POHow to merge changes from a source-controlled VS2010 database project to local development DB
      1. USJohn Saunders
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload